Append new and changed records2953 (11/16/2009 2:39:01 PM) UtfI 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 sub11662 (11/16/2009 3:19:02 AM) UtfI'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
Private Sub Form_Open (Cancel as Intege...
Controlling the DatePicker21912 (11/15/2009 2:06:01 AM) UtfHi,
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 output2758 (11/15/2009 10:04:01 PM) UtfI 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 email2651 (11/15/2009 9:54:02 PM) UtfHello,
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 table2700 (11/13/2009 1:18:01 PM) UtfI 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 menus0824 (11/15/2009 4:41:01 PM) UtfFirst up, thanks to everyone who has been answering my various questions! I'm
I have followed the instructions in the online help for adding a
context-sensitive menu to a report. I only se...
Requery needed twice2896 (11/14/2009 10:33:01 PM) UtfI 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)amiguation2461 (11/14/2009 9:28:01 PM) UtfHello,
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...
Syntax error using dlookup41195 (11/13/2009 8:45:02 PM) UtfHi All,
I have the following piece of code
ChkProv = DLookup("[Province_Cde]", "Provinces", "[Province_Cde]= ' " &
which I want to use as part of validating that the 1st 2 left chr...
Locked out of my database5731 (11/13/2009 7:59:02 PM) UtfIs there a safe key to open an Access 2000 DB without running code in the
start up form?
Combining two fields1712 (11/13/2009 5:21:01 PM) UtfI'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...
Update syntax for a remote table access11065 (11/13/2009 7:10:02 AM) UtfI 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 problem1875 (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 Function1741 (11/13/2009 3:06:02 PM) UtfI 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 box4741 (11/13/2009 11:14:01 AM) UtfI 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
I have a form with...
Access loosing Memory with Printer-Object0883 (11/13/2009 12:42:01 PM) UtfHi,
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