I have some code running on an event procedure. At one point in the code I
need to run an append query. If the data to be appended to the table
LETTERHISTORY was in another table, I would just have an append query and
DoCmd.OpenQuery "QueryName".

I have a "frmOrder" made up of 2 subforms with customer information and 1
calculated field.
Made up an "frminvoice" based in a query (based on the 2 subforms) to be
able to auto-fill some information)

I have a laptop with an access database (front-end / back-end setup)
that functions properly until you try to search using the combo box.
As
soon as you hit Tab or Enter it says "Microsoft Access has encountered

My code gets hung up on this line where I get the run time error.
DoCmd.TransferText acExportMerge, , "qrytop1000", strInstallDir & "\"
& "Empwage" & ".txt"
The Empwage.txt exists in the directory, but when it gets to this

I have code that will change a list box height when the user clicks in it. My
form is set up that when dropped down this way it overlaps another label and
listbox. The issue is that the other 'lower' list box obscurs the data in the
expanded listbox. I've tried to force the upper ...

Hi people.
This may seem a basic question, but im using a subform to add product
details to , and this has the fields 'price' and 'quantity'. I have then used
these to work out a subtotal on the cost for each item depending on the

How to define number of copies on printig. My code is:
Private Sub PrintInv()
Dim strDocName As String
   Dim strWhere As String

What would the best way be to select one item, from several lists of items.
Sorry thats the best way I could say it.
I have 8 categories of items, with say 50 items each.  Each item would
provide the information, when selected to populate another form.

I have a field [UNIT_MEASURE] in a query that I have this in the
criteria
Like "W" Or "V" Or "P"
this pulls everything with W, V, P in it, I have another field

I have a main form: ConfigUpdate that holds several subforms.  One subform is
entitled Config the other is ConfigWorkTotals.  What Im trying to do is
update / refresh / requery ConfigWorkTotals when an item is updated in Config.
I've tried several different things on the AfterUpdate ...

I can't seem to break this into two lines...also is there a better, or
shorter way to code this?
Thanks
DS

I have a main form with a subform.  There are several items on the main form,
but the only control that contains data is a date field and an autonumber
field (meant to assign a unique ID automatically to each new record.)  The
date field on the main form may be populated using a ...

Okay, i've spent half a day going through all the different question here in
the newsgroups to try and find a solution but have had no luck.
I need to open a form, but on a specific record. I have a control button
that has the follow commond onClick;

We have a access database in a folder under server. Once first user
open the database, noone else can open database anymore! It is
happening only for that database.
What might be reason please?

Gang,
I'm programmatically modifying the foreground property of some text controls
on a continuous subform for formatting purposes.  When I close the main form
it wants to save both main and subform which I don't want the users to see /