Can you tell me why this code is not working???
Private Sub cmdDoCost_Click()
Dim db As DAO.Database
Dim rstPO As DAO.Recordset, rstPORoducts As DAO.Recordset

I am using Dev Ashish's "Relink Access tables from code" which works
wonderfully but I would like to link tables from a second database also.
I created a seperate database for staff tables so they can be used in
multiple databases and would like to link these in.

How would I be able to use the double click event for a text box in a subform
to open a particular form to specific record?

I am needing to see how I can have a report open up for a specific record.
For example, I have a form where users input inspection data for a site and I
have a button on the form that opens the appropriate report, but I would like
to limit the report to the specific record ...

I have used
Application.FileDialog(msoFileDialogOpen)
technic in one of my modules.  At first it gave me a runtime error but later
on worked correctly (I do not remember what I had done to get it working).

I have an application that has the data split in tables in a backend mdb
file.  These tables are linked in the frontend mdb application file.  The
application could be deployed on different company's networks, so the folder
locations of each file may vary.

I have taken over an application that parses out data from a flat file.  It
has been running in the UK without issue.  I am in the US and am having
problems with a date field.  I believe the issue is with datevalue().  
The records are in the file in reverse date order.  The ...

I have a subreport in the header of a report. Is there a way to get a
separate header and/or footer for the subreport (different from the header
and footer in the main report)?

I am wondering if it is possible to provide options for Sub/Function
arguments just as VB does for intrisic methods, so that when a user is typing
out the method call, a drop down box appears for each argument showing
available options?

I have a Query1 that generates a list of product names and quantities
(Quantity1). I have a different Query2 that generates product names and
quantities (Quantity2). I want to make a report that joins the results of the
two queries so that where the product name is the same, ...

I'm working in Access 2000 with a List box that is inteneded to look up a
record on the form.  I have MultiSelect property set to 'None' .  For some
reason the ListBox is behaiving as if MultiSelect were true... IT never
release the previous selection which remains highlighted.  ...

I have developed a new Database on my PC using Access 2002 with Windows XP.  
When I try to run it on a laptop using the same version of Access but with
Windows Vista I get problems.  In a couple of Macros my SendKeys instructions
fail - I am changing a field type from Number to ...

i want to set a creat date and last update date in form.
creat date and last update will be add automatically when the record creat.
last update will be update everytime when saving.
how to set auto update the textbox when i save the form? Thanks.

Hi,
I have set a form of proforma invoice worksheet, has 2 subforms.
As we the actual qty of goods for ship to customer often has some difference
with proforma.

I have a system that is driven by VBA from Access. It uses Excel for charting
and generates reports in Word using data from Access and charts from Excel.
Programs were originally written using DAO but I've started converting them
to ADO. Part of the system is converted and runs ...