In either Access XP or Access 2003, the VBA Application.version property will
return the currently running version (10.0 or 11.0, respectively). How do you
retrieve the version from Access 97 or Access 2000 (8.0 or 9.0, respectively)?
Thanks

Is it possible to create a new blank database with all table structures and
relationships by VBA code?  My new task is to create a button "create new
database" , when the user click that button, user will prompt to open
directory, type the file name with defaut .mdb, when click ...

I put a toggle button on my form that I want use to switch the recordsource
of my form.
Here's the code I am trying to use:
Private Sub tgl_Active_Pending_or_Comp_Click()

I have built a form with a textbox where I can drag and drop text. I want to
be able to call a function after I drop the text on the box. My problem is
the onChange event must fire before the text is in the box because my code
fails because there is no text to work with. Is there ...

The following sub works fine--fromAccess it opens Excel and plops a formula
into a given cell and does the calculating.  My question is:  Can I make a
form in Access where the user can enter a formula and associate that input
with a variable in the program below so that we can ...

I am trying to update approximately 15,000 records. I keep on getting Error
3052: File sharing lock count exceeded. Increase MaxLocksPerFile registry
entry.
How do I get around this. This program ran fine under Access 97. We just

I want to create a search form where there are unbound text fields (search in
one or more fields) in the Form Header, with the subform in Details. I would
like to display the fields in the subform. I would also like there to be an
option to create a report... I'm a ...

I am trying to use the Shell Function. I know that the Shell function opens
up a .exe file but what if you have to open up a exe file plus a setting for
that exe file.
Pcomm = Shell("C:\Program Files\IBM\Personal Communications\pcsws.exe")

I know this is a VERY BASIC question, but would appreciate help. I have a
form in Access2000 that is tied to a table and used for input. I want to
write a very simple SQL in VB to retrieve an ID number from a table within
the mdb

I came across this code and am trying to use it for my database.  Is a small
database that will track the process of moving code through the SDLC process.
Each time there is movement to testing  an approval is warranted.  There may
be up to 20 or so people using this database at ...

I need a lesson in recordsets. I want to use a recordset to open a form and
add a new record. I am having trouble finding all the necessary code to
create the recordset, make the form use that recordset and then update the
table after they choose to save it. Should they choose ...

I need to link a table to a text file that is always open as a service log
file.  This is for read-only reporting, and I don't care if the file changes
after I open the table.  I tried to link to the file, but Access refused.
How can I link to an open text file?

I have a form which is used to run an update process. The update process is
coded in a class module called clsUpdateProcess. clsUpdateProcess is
instantiated by the form to begin the process. As the update process runs, it
generates events which are consumed by the form to ...

i am using dbase program with .exe file from .prg files. i need to move
program to access 2003. is there any software that will let me convert .prg
file that can create executable file that will work in access?
thanks

hi
I m using the Employees form in the Northwind Sample in Office Xp,
i have created a separete database & imported the tables , forms , macros
from the Sample Northwind Database...