Can anyone help me in the right direction.
In a dirtectory i have multiple excelfiles with the same number of sheets ,
but the data is different.
I need to transfer data from (for instance sheet4) of multiple excelbooks

I am building a basic form that the user can enter data into. (just 1 table)
I am gettin "From" and "To" Dates from the user
how do i display data that the user could edit based on the From and To Date??
I tried giving the data source for the form as a query, but in this case

Could someone please point me to an article defining all the (access)
form-related events and the sequence in which they occur. Thank you

I have an MS Access application that generates Excel spreadsheets (single
tab) for emailing to respondents.  When the emails are returned, they are
detached into a single folder for uploading.  I have a requirement to load
these into an Access table (named "Responses") on a ...

I am using TransferText to export the results of a query to a CSV file.
Originally, I was using the TransferTextType acExportDelim, but this enclosed
th exported fields in quotations marks which is not suitable for my purposes.
I then used the export text wizard to create a new ...

I have a form (call it Form_A) that I open from several different forms. On
Form_A I have a button that closes the closes Form_A and opens the form from
whence it was called. I do this by storing the name of the form opening
Form_A in a variable. When the user clicks on the ...

I am trying to make this code work using ADO in Access but I get an
error message:
Run-time error '-2147217904 (80040e10)'
'No value given for one or more required parameters'

Already posted in "security" but maybe this is the right place.
Hello,
we have developed an application to administer a questionnaire on a system
which use a touch screen monitor.

I have a linked table in an Access Database 2003. The linked table is updated
via a 3rd party application that is an Access database of all printouts done
on a printer. While 3rd party db doesn't have a primary key, I can use Print
ID, User ID, Time and Date as a combined 'key.' ...

I am trying to update a table using VBA and SQL.  A form is filled out
with user ID  and PW, then these data are sent to global variables.
The global variables are used to create a record in tblUserActivity.

good morning, this is maybe not the right section to post this question, but
anyway, this is my problem, every month I receive about 150 separate csv
files and each csv file has header information, I'm trying to find a way to
merge all these files into one single csv file!, when ...

Would like to update the value in Tbl_AddNew.NamesAdd with the value from
Tbl_Double.NamesAdd  (I really do not want to have a different field name in
each table).
 I thought code below would work but it does not!!

How do I work with an Excel spreadsheet that is password protected from
Access?
Is it possible?
In all likelyhood, I would probably be doing a DoCmd.TransferSpreadsheet to

I want to import a file wih extention .res to access.
What i am doing now is i am telling the user to manually change it to .txt
file and then import.
Is there a way that access could take this .res file and convert to .txt

Program runs great all day in single user mode with absolutely no errors but
is very "unstable" in multiuser mode because it will occasionally get error
messages when two users apparently access same table (but different records)
Usually receive one of three Error messages: