String to Date
Mon, 1 Dec 2008 13:53:02 -0800
I have a piece of code that runs an append parameter query. When I run it as:
Set db = CurrentDb
Set qdf = db.QueryDefs("Pre-2008 Step4 app_Transactions")
qdf.Parameters(0) = #12/31/95#
qdf.Execute dbFailOnError
it works.
But if I try to make the date a string variable that I concatenate it ...
|
Required Field Problem
Mon, 1 Dec 2008 13:30:06 -0800
I have a form with several required fileds (set with the property in the
underlying table). One filed is a drop down list. If the user does not find
it in the list, he/she will have to add the value to a lookup table so it is
available for them to use when creating a new record.
So a user begins to type i ...
|
Error Handler (Global?)
Mon, 1 Dec 2008 11:59:01 -0800
Hello All
I have been using local error handlers for some time now and for the first
time I have something that I feel I need to add as a global error i.e. a way
to handle database connectivity failure.
I thought about global error handlers and have read a few things on them.
All articles seem to be devo ...
|
Move to a new added record
Mon, 1 Dec 2008 11:55:01 -0800
After having added a new record with among others an index field "NID", I
want to display the new record in the Form. I have tested with the following
code, but end up in the NoMatch line. I have traced that the right value of
NID in the new record is assigned correctly to strSearchName, but apparently
the n ...
|
Add a Label or Textbox with VBA
Mon, 1 Dec 2008 08:23:02 -0800
windows 2000, Access 2002
I would like to add a label or textbox using vba. It tells me you need to
be in design view. I want to check to see if a textbox or label exists and
if it does not to add it and set the properties.
Can this be done? I tried the following. I want to do this when a user is
op ...
|
Help with code please
Mon, 1 Dec 2008 03:55:00 -0800
I have a data sheet form in which I want to enforce entry in Date Issued
before Date Returned is completed. Both are set to short date field
properties in the table.
I have included the following code in the after update property on Date
Issued but I keep getting debug - would be very grateful is someone c ...
|
Repair command
Sun, 30 Nov 2008 23:27:01 -0800
Hey,
we are having a problem with the Repair command of the ODBC setup.
In an XPe environment the database is deleted by this command. To understand
this I'd like to know is, how the Repair command is working. So this is why I
posted this ODBC question here.
So does anyone know how Repair handles the databa ...
|
|
|
Loop Help
Sun, 30 Nov 2008 22:53:51 -0500
My code works but I cannot figure out how to reset the payment amount when I
get to the next account number. I have the following query that I want to
allocate a balance to. For example, the payment is $300, and I need to
allocate to the largest amount first and then finish it off. For example,
my qry is a ...
|
Trying to Send Email, Via Outlook, Using VBA
Sun, 30 Nov 2008 16:42:30 -0800
I followed the example at this site:
http://support.microsoft.com/kb/318881
It didn't work after I modified the code slightly; trying to use this code:
Sub SendMessages(Optional AttachmentPath)
Dim MyDB As Database
Dim MyRS As Recordset
Dim objOutlook As Outlook.Application
Dim objOutlookMsg As Ou ...
|
>> check whether still processing
Sun, 30 Nov 2008 16:06:46 -0800
Hi, using Access 2003, is it possible to check whether a process has
completed. That is when I step through the code a query that relies on a
previous line suns successfully. However, when simply running the routine the
query fails. I can put an arbitary wait of 1 second. But this seems like a
work-around an ...
|
