I have a sub form in my form. The sub form displays pricing for my customers
based on customer number entered on form and run through "Load pricing
Query"
I want to only display active pricing (customers have many pricing values)

When i double click on an mdb i get a 7 second delay before the spalsh screen
appears.
If i click on Access from START-Programs, i get no delay. If i create a 2007
database i get the same delay.

I have this query:
SELECT "ID Referral" as TableName, logID, actID, caseNum FROM
[tbl_logReferralAction] WHERE [caseNum] = Forms!frm_AdvSearch!
findKeyword

I have an access database that we've been using for sometime now. It has
some errors and doesn't work properly. I was going to have a look myself and
see if I can fix the problem.
The person who created isn't around anymore and I get the Read Design, Read

I am trying to export an access query that has a run time prompt to a text
file and get an error message saying: Too few parameters.  Expected 1.  
Clicking OK to that message just stops the wizard.

I have created a database using 2003.  The user only has on their computer
2007.  When I load it, it seems fine and works well.  Is it a must to convert
the database to a 2007?  Any big issues to worry about in general that I
should be thinking about?

Hello   I inherited a workbook from someone that is no longer here.  I
modified the workbook then I copied the code below from the Ron De Bruin
site. Problem is that it does no copy the formulas as values. Where there
were formulas I get #NA .

I have noticed that Access Help uses a "User-Fiendly" method to refer to
DataTypes in Access 2000. This makes it hard to set datatypes for Fields
when Creating Tables with SQL using the DataTypeEnum constants. So can
anyone tell me what is the DataTypeEnum for Long Integer. I can ...

Hello experts,
using Access ’03…
I understand that Forms are the best way to enter data, but…
I have a Table that a few people (3 or so) utilize on a network

I have a form which refers to a table.
The table has a row named location which is a hyperlink.
The form is in a datasheet view. I would like to set an on-click command to
display a dialog box to refer to a specific file loction. Once the user

I have an ‘Order’ Form which has a subform ‘Freight Detail’ table where I
enter details of freight (cartons, pallets etc) for each order.
I have also created another form ‘Freight Invoice’ which has a same subform
‘Freight Detail’ table.

Is it possible for me to download an Access file to my website and have users
open it online and enter data/get reports if they don't have Access on their
computer?  If so how can this be done and is there anyone out there who might
do this for me? I am age 67 with little ...

I have A97 on a computer running WinXP SP2
Does anyone know of any problems with A97 and SP3?
TIA, John

I am trying to populate the value of an unbound text filed on a report, but I
am doing somethign a little wrong, because it doesn't recognize the name of
the text field..  Here is my code, I'm msure someone here will post this it
is so simple, but not for me - today..

How do I move to the previous record?
I have an unbound control (findDoctor) where the user could type in
the doctor's last name. The matching record is displayed in the bound
controls with the doctor's license number, last name, first name,