i have written a query as follows:
SELECT LabData.ParameterName, LabData.SAMPLE_NO, Month([SAMPLE DATE])
AS AMonth, Year([SAMPLE DATE]) AS Ayear, LabData.RESULT
FROM LabData

I have a table called tblstock in this table I have a field called SalePrice
which is where the actual sale price is entered once this is entered I would
like for the field vat to be popullated with the amount of vat @ 17.5%
eg SalePrice £100 therefore VAT = £17.50

I put some code in my subforms on current event to check if the foriegn key
field contains a null value. If it does I dont want the user to be able to
enter anything into the forms fields. Because to do that you would of course
want a record in the parent. The parent table is Agen. ...

I need help and am inexperienced.  I want to do a workout database and have
the basic setup (based on the downloaded template on the website). The
problem is this:
When I open the workout form, I have a subform (Bound Combo Form, which I

Alright, I have a form that contains three subforms. In the main form,
I made a text box to total up the BookedMsg field from the Invoicing
Subforum. For some reason or another, I constantly get a #Error. I just
don't get it. Below is my control source. Any assistance is greatly

I have a form I use to append the transactions from table 1 to table 2.  On
the form I have a button to run an append query.  For some reason, the
transactions are being duplicated in the table 2 from time to time after the
append.  

Access 2003
I should be able to remember this or find it, but ...
Select query being displayed on a form (one record at a time with
navigation buttons).

Is there a way to store report names in a table in which I can have a user
press a button on a form and have a select query run where all the user had
to do is enter the form "Number" and it be automatically sent to a specific
pritner?  Don't want the user to see the list of ...

In a form I want to be able to call up the record I want to edit based on the
primary key I have defined, not the record number at the bottom of the form.
How can I do this?

I have a search form which currenlty searchs one table and opens a recordset
to another form for editing etc. This works great!
I now need to modify this search function to also search 2 other tables. I
am having trouble getting this to work.

I've got a rtf2-memo from www.lebans.com, thanks, stephen!, and there are a
bit more than 36.000 characters in it.
i can't add any more characters.
are there any limitations?

In Access 2002 I have a continuous forms form and I want to change a flag
field's back color based on criteria in the current record. I do it in
reports all the time but am  at a loss of how to do it in a form.
Thanks

Can someone point me to some good instructions on using the
WinInet.dll functions from VBA?
I need to interact with a MySQL database via HTTP strings.
We already have the database set up and a PHP script that can receive

I have a .TXT file with 800,000 rows.  Each row has three columns:
   1. a number
   2. a city name
   3. a Zip Code

I am using INSERT INTO to add a record to an existing table. I want to
change only one value that is the linking field to the Master table so that
I dont get message record cannot be added without a reference to the main
table. I already have the nessassary number (an ...