I've been browsing through some of the previous questions however I still
can't quite find what I'm looking for.
I would like to store the path and filename of various documents in a table.
Users should be able to browse windows for files and when they select a file

I'm using datamatrix barcodes withtwo numbers separated with a carriage
return CHR(13)
Is it possible to create somethng like the statemant  inputbox in vba that
read one scan into two variables in a form?

How can I delete a form from a project? Thanks

I have a table called ACH that I search for a customer id and find out
if that customer has passthru, upload or application. Each customer
can have both passthru and application. If they have both, they will
be in seperate records.The customer table has two fields. One for

I am building a db system whereby my users MUST enter certain data into the
db before they can continue with other activities (the db form is opened when
they finish a telephone call) . I need to make the db form come to the front
of their screen and then keep it there until they ...

I have an odd request from work which is giving me quite a bit of trouble.  I
need to figure out the 3rd Business day prior to the 18 in VBA.  I have been
trying to manipulate the code "GetBusinessDay" by Arvin Meyer to no success
(below).  Just a FYI.. This is going to be used in a ...

Is there a way to implement Excel's MAX function in Access?
e.g. MAX(field1 ; field2; field3)
Thanks a lot

I have a form in my database that has a hyperlink to open Crystal Reports.
There I open a file and refresh data in a report. I then export the refreshed
report data via ODBC to my database and save it in a table that I query. Each
time I try to save the table I get a message that ...

Hello, i am not a programmer but a dabbler and need some help with the
following please.
I get a record from my table by dtAdded with the code below... How would i
change this if i put a combo box to select the record i want, as this takes

I am using below Passthrough query which is workig for SQL:
Set qdf = db.CreateQueryDef("")
qdf.ReturnsRecords = False
qdf.Connect = "ODBC;DRIVER={sql

The "modified date" and file stamp always shows the last time the database
was opened. Even if no changes were made to the database design OR data.
Is there an easy way to tell if data in an access database been updated so I
can display the "data date" on my startup screen or will ...

I use shell to backup my database where I put the xcopy /N /Y,
/N for handling the big names and /Y not to prompt for overwrite.
Shell(command /c xcopy /n / y c:\myfile d:\)
Myfile I get it from the Database using

Hey Guys n Gals,
I'm attempting to develop my first Access VBA application. I have managed to
connect to the database via coding when the form opens. My question is when
I'm ready to submit info via forms, do I for each form have to put in the

I'm working on a smal DB which will act as a kind of an updater against
another db installed on users pc's.
This updaters will make changes/corrections to their data.
I would like to have this small db to write the actions taken on data on a

Litwin, Getz, & Gunderloy, in Access 2002 Enterprise Developer's Handbook
offer a BuildUserList() procedure that lists all current users in the
database, setting an ADODB.Connection variable to the current project:
Set cnn= CurrentProject.Connection