I have some code that inserts the username, date and file location of the
.mdb file into a table called tblUsers.  This works on some pc's but not
others.
Here is the code:

I am using this module on a new data base and I get a "Run Time Error #3021
No Current Record" and I cant figure out why it is giving me this. Im new to
vba but I think it has something to do with it not being able to find data it
is looking for because of it being a new ...

Server = SQL Server 2000 SP3a
Client = Access 2000 data project
Im trying to ouptut a form to snapshot view, this surely must be possible as
it works fine in the reports.  I've tried coding it with:

I reference the proper DAO Library.
I included Dim rs as DAO.RecorSet.
I created the SQL in native Access.
The Query works in native Access.

The relevant fields are entity, amount, account, and debit or credit (call it
d_or_c). A table (call it journal) collects the information from various
sources. All
appended to the journal table. The accounts are balanced by specific

I am trying to see how Access stores data type information within a database.
I believe there is a way to view the actual values stored.

When the user enters a date in a date field, I need to have the day of the
week autofill in a separate text box.
I'm stumped, please help...

I have this report that is run from a cmd button.  The click event contains
code that is suppose to determine whether or not the sentence is concurrent
or consecutive.  If concurrent sets the TotalYears to the largest number of
years.  If there are also consecutive sentences it ...

I have written exact code in Access 2000 that I have in Access 97 using the
DAO and receive an error 13 'Type mismatch' when the recordset object is
being initiated.  
I tried converting a test db from Access97 to Access 2000 and the code

If I have a table that lists a Style,Color, InventoryUnits, and
DateOfLastInventory, how can I find the last change in inventory?  That
is, I wish to find Inventory that isn't moving.
For example, let's say I have the following in a table:

I populate a bound subform by programmatically changing the underlying query
statement, passing the ClientID to the query definition. This is so that the
query returns a single record rather than thousands and hopefully speeds up
the form.

I presently have a booking system which is Access 2000 DB and I want to add
some new functionality to allow the user to copy a booking to a new date for
repeat bookings.  The problem I have is that after selecting the requested
record from a table and copying it back with a new ...

I'm using Access 2003 Professional Version. I have installed Visual
SourceSafe (separate product) and the plug-in for Access.
When I click Tools->SourceSafe->Add Database To SourceSafe, it does the
following:

I've formated new computer,
Installed windows xp SP1,
Installed Office 2003 SP1,
Is there a way to get last vertion from source safe?

I want to store more than 1 hyperlink for every record in the textbox.
I have tried the following code, but an error occur (runtime error 7980: the
hyperlinkaddress is read only for this hyperlink. what did i do wrong?
Me.txtFile_Name = strName