(0.012 seconds) Articles (1670) |<First << Prev /84 Append new and changed records 2 753 (11/16/2009 2:39:01 PM) Utf I have an Access database that I use as an analysis tool. I import several tables form a larger database. The Records I import may or may not have been edited in the main database. I can easily append ne... passing a control to a sub 1 1293 (11/16/2009 3:19:02 AM) Utf I'm having trouble passing a MSFlexGrid control to a sub. The control name is "flxGalleries". The error is "Type Mismatch. Error '13'". I have the following code: Private Sub Form_Open (Cancel as Intege... Controlling the DatePicker 2 1474 (11/15/2009 2:06:01 AM) Utf Hi, I need to be able to control which dates can be picked from a date-picker control. At the very least, I need to limit dates to weekdays, but in various circumstances, I also need to be able to block ... Generate a random 6 character output 2 522 (11/15/2009 10:04:01 PM) Utf I am looking for a way to randomly generate a 6 character output of letters and numbers like abc123 or 258qwe etc... Can anyone show me how to do this or point me to some examples? Thanks for any help. -... Delete sent email 2 539 (11/15/2009 9:54:02 PM) Utf Hello, I need some help please. I have found and know how to send email with VBA. What I need to know now is, how can I prevent the sent email from being saved in my sent folder or delete folder in Outloo... Subform table 2 491 (11/13/2009 1:18:01 PM) Utf I have brought a table into a form as a subform- while I can get rid of the navigation and scroll bars from it, it still has extra space below the "*" at the bottom of the table- As I only want the user to ... Access2007 Context-sensitive menus 0 679 (11/15/2009 4:41:01 PM) Utf First up, thanks to everyone who has been answering my various questions! I'm getting there. I have followed the instructions in the online help for adding a context-sensitive menu to a report. I only se... Requery needed twice 2 737 (11/14/2009 10:33:01 PM) Utf I wrote a name seach routine to be sure a new name is not already in the table. This routine changes a code, if necessary, so that the query in the main table will include this record. My problem is that wh... Classes and (dis)amiguation 2 329 (11/14/2009 9:28:01 PM) Utf Hello, I'm in process of trying to write my first class and have a fairly general question... do we need to disambiguate property/routine names in class modules as we would in standard modules? I've do... Retrieve Full Path From Attachment Recordset Multi Value Field 0 826 (11/14/2009 11:53:01 PM) Richard Hello, Is it possible to retrieve the full path from the Attachment Multi Value Field in Access 2007. It seems that Access obviously stores it if it knows where to find it, but is the full path availabl... Syntax error using dlookup 4 1070 (11/13/2009 8:45:02 PM) Utf Hi All, I have the following piece of code ChkProv = DLookup("[Province_Cde]", "Provinces", "[Province_Cde]= ' " & Left(Nat_Reg, 2)) which I want to use as part of validating that the 1st 2 left chr... JDBC-ODBC Bridge driver & ODBC driver are two different installati 0 582 (11/14/2009 2:01:01 PM) Utf http://www.paphoscarhire.mobi/odbc-bridge2.jpg desktop control panel settings, I have above URL (IMG) Settings well, I need to run in my PC: Type 1 db driver Access / java[SE1.6] Desktop Applications, wh... Locked out of my database 5 534 (11/13/2009 7:59:02 PM) Utf Is there a safe key to open an Access 2000 DB without running code in the start up form? ... Combining two fields 1 541 (11/13/2009 5:21:01 PM) Utf I'm trying to combine two fields in a particular way, and am trying to write a function to do so. However, I'm getting caught up in how to actually grab the contents of the fields. I've tried going the DA... Access 2007 - Use Report or HTML file as body of Outlook email mes 3 1631 (11/13/2009 3:47:01 AM) Utf Hi, I’m using access 2007. I would like to use one of my reports as the body of an outlook 2007 email message. I’m able to export the report as an HTML file but can’t figure out how to use either as body o... Update syntax for a remote table access 1 794 (11/13/2009 7:10:02 AM) Utf I have to update a remote database. I can't link to the tables because it slows down my application to a crawl. So I just modified the SQL statements to get to the remote database. The append was easy an... OpenRecordset problem 1 559 (11/13/2009 5:38:11 PM) Ron I am using Access 2003. I am fairly new at writing code. I have a Table (InvHdr) that contains Invoice information. I have another Table (InvDet) that contains the detail lines of each Invoice. They are... On Error check for Function within Function 1 519 (11/13/2009 3:06:02 PM) Utf I have a Function (Called "A") that has "On Error" logic coded for it. I have another Function (Called "B") that is called from Function "A". If an error occurs within Function "B" will the "On Error" con... Limit Text displayed in Combo box 4 528 (11/13/2009 11:14:01 AM) Utf I have a table with a column that contains the following data: Example: SB MDMD-XX-XXX The first 8 spaces (SB MDMD-) never change. The last 6 spaces (XX-XXX) are always different. I have a form with... Access loosing Memory with Printer-Object 0 672 (11/13/2009 12:42:01 PM) Utf Hi, please see following code, where I demontrate, that access will not free memory after an object is net to nothing: Public Sub testprinter() Dim pPrinter As Printer Dim i As Long ...