hey guys,
if someone could please provide me with some assistance it would be
very much appreciated...my problem is as follows:
I have just downloaded a Scheduling utility to Run my database on a

I'm converting a .mdb application to .adp format. In .mdb application I
have a button which sends a query(join of 3 tables) to .txt file
through transfertext of Docmd.
I'm not able to use this transfertext in .adp format. As I have

I have a database that has been in use by the department for some time
without problems.
We recently added a team member who needs to be able to do some development
work on the database.  As I had the developers copy of the database, I moved

I posted a reply to an old question and am unsure if I should have just
posted a new question so here it is:
I would like to also export a databse to multiple worksheets in a single
workbook but have not been able to accomplish it using the method in this

In Access 2002, I used to be able to export to multiple sheets in Excel using
the TransferSpreadsheet Action in a macro. It does not let me in 2003- does
anyone know how I can do this? Maybe I'll have to use VBA code? I am not very
familiar with VBA. Help please!

I am using the send object command in a macro to send 3 seperate query's via
Outlook email. These query's create 3 seperate spreadsheets....How can I
incorporate these 3 query's in one spreadsheet?  I would like to send these 3
query's in one spreadsheet (3 seperate ...

I'm sorry if this ends up being a post similar to someone else's that has
already been answered.  Here is what I am trying to do.
I'm creating a database that has in it fields for first name and last name.  
To prevent duplicate entries, I want the used to be able to click a New

="O:\Folder\Folder\FileName" & (Format(Now(),"yymmdd")) & ".xls"
I'm trying to transfer a spreadsheet but want to add the time to the date
because the spreadsheet may be run several times in a day, so I don't want it
overwritten.  I've tried adding time by doing the ...

I am trying to create a lookup for employee id to open a time sheet entry
form using a filter in the open form in a macro.  The form contains several
tables.  It says that if you use a filter and not all of the fields are in
the filter, then to set the outputallfields property to ...

I have a form to record customer payment receipts into a Receipts table
indicating customer, amount, date etc...   Within that form is a
subform based on a query that selects all open invoices to that customer
from the Invoices table.  I want to be able to allocate the receipt ...

I used access 2000 , i have a table that containe the fields for the
text file
need macro for read the file ,import it,and after all delete the file
can anyone help me?

does anyone know how to have a macro execute at a given time during the day?

I  am using article KB208529, which has worked in other databases of mine, to
set up a report filter from a pop-up form.  When I choose a value from a
combo box, then click "set filter", I get the following error:
Syntax error (missing operator) in query expression '([Provider

I have a DB with a from when you input the emp # it pulls the name, dob, etc
from one table then you are to enter data in the rest of the empy fields on
the form. The form is laid out in Tab view (which doesn't matter much) except
after you enter your data on the first line and ...

I would like to be able to prevent users from creating new macros but not
prevent them from running existing ones. I can disable access to the Macros
option in the Toolbar and Menubar, but access to Macros is still available
from the list of objects when they create a new ...