I have a  table with two primary keys.  I have a query that displays all
primary keys for that table.  I want to be able to double click on a primary
key in that query and then display the entire record in a new form using a
macro.  I do this without any problems to tables with ...

We have an Access Database that has fields which have been populated by sloppy users.  A typical example of one of the address fields says "13 abercorn street".  This needs to be "13 Abercorn Street" but I need to make similar changes to all record fields and the sort all fields ...

I can not figure out to have my macro run a query in Access 2003

I have a form on which I am attempting to add a control button which when
clicked on will run a macro and return the value in a field on the form.  I
need for the macro to look at the source table and get a count for how many
records are in that table with specific criteria.  ...

I know that people ask a lot of times about this, but I realy don't know how
to do it. I'm not that good with access. I'm trying to create an automated
update condition but I need that the macro stop when it reach the last
record.  Can someone help me on this...

Is it possible to start QD or RW from macros/vb6/.Net independent of the
whole Access application?
[If you can please email: elliott.coates@uspto.gov]
Thanks!

We have an app built with Access 97, that we archive often.  What we are
currently doing is opening the form, clicking on a button which calls a
module that runs a function called slf_monthend().  My question is can I set
up a Macro which would open the module and run the ...

Hey, I'm trying to run a macro that will enable a table to be exported to
Microsoft Excel. For some un known reason, when i try to run the macro, a
help message appears telling me that i cannot run the macro due to the fact
that the fact that Access cannot find the file that i ...

I have a macro that runs several queries, each selects 'today' out of a
different field (activity today each group). I want to change queries to
allow select date. How do i pass ONE parameter to the macro to run the
requested date for all queries in the macro?

I have a data-entry form in HTML format, however, data type formats / input
masks seem to be ignored.  How can I get drop-down menus to flow-through from
underlying table properties to HTML Form?

Need to create a condition in a macro while using the
GoToRecord>Next function, such that if I am at the end of
the records, that the macro does not run.  This would
prevent the annoying "End of Recordset" error messages and

I have a one line db and need to save it as an Excel .csv
file.
If possible, the file needs to be automatically created
and named (the name comes from a couple of the fields in

I'm working on a database, and wish to make it "Idiot-Proof".  I have
the Access window hidden, and only a switchboard showing.  When I
click on the View/Edit button the switchboard hides, and the database
form shows.  Clicking Exit closes that form and brings my switchboard

I wish to have the full screen covered with my initial form at startup,
without any toolbars etc. Also, how do you edit the database when the
toolbars are no longer visible?
Thanks

I think I did this once but can't remember. Anyone know?
Thanks in Advance
Melani