Hi, anybody could help me to find a way where in once I enter a new badge
number to a textbox it will tell me whethere that Number is already existing
or not if it is exist it will display that record on the form. If not it will
add it on the record.

I am attempting to fill a ListBox from a recordset which has been generated
from a DB that has been opened within a Workspace/Transaction.  However,
setting the RowSource property to the table containing the records (which
have just been appended, but not yet committed) does not ...

Access 2003 headache, new guy thinks he's bitten off more than he can chew...
I have a report that has 11 controls to display the current subtotal of all
expenses relating to 11 budget catagories.  These relate back to individual
budget limits for each catagory, limits set for ...

Is there a way to loop through all the report objects and write their name
and description to an access table in the same database?

I looked up the code that will compact a database if it reaches a certain
size.  I'm supposed to call this function before the application exits.  I
know how to call a function before a user closes a form, but I don't know how
to call a function before the actual application ...

Hello forum,
i need running a timer-event permanent behind my Access
2000 application. I set the timerintervall of my first
form (with stay most on the screen), but if the user close

Hiya,
I need to import data from text files into a database... but it's a bit
complicated:
1. The data for each table is actually in more than one text file. Is there

Hey folks - I'm looking for a sample code snippet on
writing to an Excel spreadsheet one cell at a time from a
query built within MS Access.
Any assistance is greatly appreciated.

I'm fumbling through a procedure to programically add columns to an existing
table. The purpose of this is to send an updating database that when launched
- updates objects in another database. So far, the only way I can add fields
is using the .append method as follows:

I'm starting a mailmerge from ACC2000 like this:
 Set wordObj = CreateObject("word.application")
 wordObj.Visible = True
 wordObj.Documents.Open case_file

Is it possible to program Access to perform an automatic backup every time it
is closed?

Enviornment:  MS Access 2002 (XP) and VSS 6.0d
Is there a way to clear the list of modules that the VBA editor
'automatically' opens? What's happening is when I go to open a module and
answer yes to checking it out of VSS, it then asks to check out a bunch of

    Is there any way to backup the open db before the "Compact on close"
runs?  I want a backup of my db in case compact corrupts it.  I'm using
Access 2002.
Thanks!

Server = SQL Server 2000 SP3a
Client = Access 2000 SP3 data project
I have a button on a form which when clicked creates a view based on the
users selections, then opens a report who's recordsource is the newly created

I would like some suggestion about the best way to read from an Excel
spreadsheet into an Access form. The data I want to read from Excel is only
from a few specific cells, not a range of cells, and it needs to be fed into
an Access form that mirrors the 'look and feel' of the ...