I am currently trying to learn VBA from a book called Access VBA programming
for Dummies which has been written with Access 2000 , 2003 users in mind. I
am using Access 97. While most of the code seems to be the same, I have hit a
problem with a reference to the current database. ...

This is a very strange issue, but I'll try to be clear.  I have a main form
with two separate subforms.  (The subforms are not nested.)  Each subform is
in datasheet view because it should look like spreadsheet data.  The main
form is in standard form view.

My MS Access application is the front end to a SQL database.
I add a field to the SQL table (1 bit).
Then, in MS Access, I refresh the links through table manager.
Sounds correct, but non of the previous data can be changed!!!

I have a dialog box that is supposed to find records in a table that match
records in another table and update one of three dates based on the selection
made in the dialog.  I'm using the Seek method in VBA.  However, when I split
the database, this no longer works, as Seek ...

Access 2003:
If I wanted to create an object variable as a reference object to the
CurrentDb object property of the Application object, other than the generic
Object datatype, is there a specific datatype that will work?

I find myself in a situtation.  I have about a million backend .MDB's and all
of them need to be compacted.  Let it be known that I am being lazy.  I
really don't wont to write a compact program if someone has allready done it
and is will to share. :)

I use this code to allow my user to select a specific file.
   Dim dlg As Variant
   Dim stPath As String
   ' Browse to the file to attach.

I am making up a program where i use an userID and i need the userID of the
session in Windows 2000 Pro to use it in my program. I wanted to know if it's
possible with Visual Basic to get that or if there is a specific reference to
add to enter in the system.

I have been asked to create a program to monitor holidays and sick leave. The
user wants to be able to call up a screen that shows a calendar type screen
with every day of the year on it, and a code input for the days the staff
member was off (ie AL for annual leave).

I have a  three forms 1 (main), 2 (sub), 3(subsub).  My third level sub form
gets its data from a query which gets an id passed in by the 2nd level sub
form.  I'm having problems with getting this query to refresh or reload when
the id has changed.  My query for the 3rd level ...

I am trying to get the following to run:
Dim Directors As ADODB.Recordset
Set Directors = New ADODB.Recordset
Directors.Open "tbl_Directors", CurrentProject.Connection, adOpenStatic

Is there a means up updating VBA code programatically (i.e.: using a sub
linked to a control's click event, to modify an existing function)?
I'm trying to create a change password form that modifies an If..Then
statement in my password verification function. For example, in the ...

I have a compile error I can't understand. I placed >< around the line that
the debugger highlights. Any help is greatly appreciated - THANKS!
Private Sub Country_Region_DblClick(Cancel As Integer)
On Error GoTo Err_Country_Region_DblClick

OS:WinXP
Access 2k3 (2k file format)
Im trying to round currency using the Round() function for example:
If Rst_Inventory_Master![Taxable-Burlington] = True Then

I have tracking devices fitted to the company's fleet of vehicles. They write
data to a .pos file.
The .pos file consists of a zero terminated string containing the position
info for every point. These are stored at 128 byte intervals within the file.