I have a program in VBA in which I tried to run an SQL for which two
parameters (text) are entered by calling for them from the 'criteria' field.  
I also want to use those same parameters as the front part of the name of a
file to save.  However, no matter what I do (Public, Dim, ...

I have created an Append Query (qryAppendTests) that looks like the following:
INSERT INTO tblQueue ( REQUEST_NO, REQUESTOR, DUE_DATE, TEST_TYPE, CYCLE_NO,
TEST_ID )
SELECT tblTest.REQUEST_NO, tblRequest.EMP_ID, tblRequest.DUE_DATE,

I have a simple flat file database of a questionaire of about 130
questions/variablea. I need to a report with the frequencies, mean, median,
mode, min, max, range, standard deviation etc. I thought it would be easier
if I could code VBA  to create functions for each of the above ...

Old to programming, new to ACCESS.  Have project dumped on me
with old database.  Need to do it quick and dirty, for now.
Sorry these are basic questions, but I couldn't find and real
answers to them in the threads.

I am looking for direction on how to insert a hyperlink into a table field
that has been designated as "Hyperlink" by using VBA that will look to an
input form for the correct path.  Currently, the Hyperlink field updates the
field with the data, but when I click on the field to ...

After converting an existing mdb to an accdb, the tool bars were put into
Add-ins on the ribbon.  I could not determine a method to modify the tool
bar/add-ins after the conversion.  So I deleted the Add-ins and went a
different route.  But now the accdb thinks it is still tied ...

Is there a way to program a button in Access to launch a known file into a
program other than the one associated to the file in Windows XP?

If we have two forms and one report opened at the same time is there a way to
set programmatically at any time which form or report will be on top of the
other?

Hi, using Access 2003 is there a way to dyamically list a query's columns
order?
The column property of a cross tab query can be used to specify the order in
which column headings are listed. However, I do not know at time of

I am receiving the error "wrong number of arguments" when I try to call a
function from a text box.  I am trying to put =BuildCriteria() in the contol
source.  
The function it is calling is on the form and is as follows:

how do I call date field from a stored procedure?  I don't know the syntax
Thank you.

I have a split database that holds miscellaneous HR information, and is
being used by approximately 40 people at my company.  Approximately 5-10
people access the database simultaneously, using the runtime version of
Access, via a local front end that is linked to the back end on ...

How do I write two conditions in DLookup? I wrote this
*IsNull(DLookup("BookName", "Trans", "BookName='" & I & "'"))*
But this is only one condition I want that it should also have to check
IsNull(DLookup("MemberId", "Trans", "MemberId='" & Code & "'"))

Hello,
Question 1 is how do you automate the importing of a text file?
Here is an example of the information;
"Emp","63","Department","87","05-24-2008","06:50:37","Process","A","87",

**Not sure which discussion group to post this***
I have successfully imported a data list from an excel spreadsheet into a
temporary Access table.  Now I want to transfer the data from that temp table
to existing access tables but don't know where to start or the best way to do