Tab Control select issue
Mon, 1 Dec 2008 17:16:01 -0800
I have a tab control with the following proceudre for on the On Change Event:
Private Sub TabCtl0_Change()
DoCmd.Requery
End Sub
Everything work perfectly until someone clicks a SECOND time on the tab/page
that is ALREADY selected. The tab gets a light dashed line around it and many
of t ...
|
Determine office version that is running on users machine
Mon, 1 Dec 2008 13:58:17 -0800
I'm in a situation where I have multiple users of a database application that
are using different versions (2003, 2007) of the same application.
I've got a "front end updater" that I'm trying to give the additional
functionality of downloading the correct version of the database. This is
easy if they alr ...
|
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 ...
|
