I'd like to write something that interacts with Epay so I can keep
track of my auctions, but I have no idea where to start.  Can it be
done?  If so, does anyone know where any sample code is?  I'd assume
Epay won't let you connect to their data so it must be done via a

Suggest any best tool for creating ER tool from the database ?

In my report I have a calculated field that counts the number of records of
the underlying table, =Count([ID_customer]). This field is placed in the
report's header. I'd like to repeat this value on every page but when I drag
the field to the page header it shows 'error' when I ...

All,
I'm trying to move this code (which I bastardized, thanks!) from the
form where I have successfully implemented it to a Module, so I can
implement it for all of the appropriate forms in my app.

i had a button on a form. when clicked, the button runs code that
retrieve the values of unbound textboxes on the form and saved the
values in a table. the application runs fine on all pc except one. on
this one pc, when the button on the form is clicked, it gives this

If a report has a some text fields, let's say in the detail band, and
you set one (or all) of the fields to CanGrow, and all the fields have
borders around them, and one field exceeds the regular size of the
fields, it will grow but the report looks a little funcky because the

As I look through the drop-down list that appears after I type the
word 'as' in a dim statement, I see options such as, collection,
control, controls, form.  That makes me think the functionality I am
seeking is available...my problem is I don't know how to put the

I am looking to write a query with multiple factors and do not know
the best way to do it.
I want use Event Type, Status, and Region as my queries variables.
By

I have two main forms that I am preparing. These have been passed back and
forth between a consultant and me. For some reason I cannot copy (duplicate)
these in order to make changes/trials. I know he is operating from Access
2007 and I am from Access 2003. Can anyone think of a ...

I am trying to create a from with a series of combo boxes that each
query a different field (called Specific01, Specific02 etc., except
the first field which is called Condition). Each combo box has a SQL
statement in it's rowsource so it will only display distinct records

I want to be able to click a button, open a form, and run an SQL statement
via VBA. In the example below, I want to open frmBoM and display all
records for Job Number 5494 in tblJobs. If I can get this to work, I can
substitute a variable for the Job Number and select it from a ...

Hi Group,
I'm creating a maintenance switchboard and am trying to create forms
to update tables and wanted these to appear as datasheets.  Although I
have the default view set to datasheet and when opened directly the

I have an access application with a backend Sql Server.  All data is passed
from the back-end  (remote Sql Server) to unbound forms via stored
procedure.  I then set the recordsource of the form via vba to the recordset
returned by the stored procedure.  If an unexpected error ...

My environment:
A parameterized query that MUST be run as a pass-thru (MS Access
cannot handle the SQL) and so cannot accept a parameter from MS Access
without being re-written programmatically to include it.

I'm trying to export a table to an ODBC database using a VBA subroutine. I
have tested the ODBC setup manually and it works fine but when I try to do
it with VBA, I get a "connection failed" error. This is the code I'm using.
Can anyone tell me what is wrong with it?