Hi..
Im working in Access 2000 and have created code as part of the Onclick Event
Procedure.  Within this code I open a form that requires the user to make a
selection.  The selection passes back to the form where the OnClick event

Hello...
I am working with Access 2000 and have a form that opens a number of
recordsets to test for specific conditions.  Is there a way to open a query
using this recordset?

I believe this is more of a VBA problem, as my ODBC code works, in
another module...
I have a module with code that I assembled last year.  And my ODBC
code works.  When I run the code, Access does *not* ask me for a

I have 24 queries or so that run data by Day.  I just realized I may
want to see data by Year.  Rather than do a whole set of 24 queries all
over again, I see that if I just interrupt one with a little If-Else
code, I could be set.

Private Sub Lot_No_AfterUpdate()
Dim db As Database, rst As Recordset
Set db = CurrentDb
Set rst = db.OpenRecordset("SELECT * FROM tlbReceiving WHERE Lot_No = " &

The text file will receive accounting records for a third party accounting
package. Each record set contains 2 or more transactions. The third party
package requires a double carriage return to signify the end of each record
set.

First, some background:
All teachers can author a multiple number of projects, and can be the lead
author or co-author for each project.
I have 2 tables - TBL projects and TBL teachers. Projects looks up teacher

I am moving from dbas to access. I have 2 tables - todays runners and past
results.  identical structures.  the results table may have numerous lines of
form for each of todays runners. I only want to return the most recent 4
formlines.

My code is as follows:
Dim con2 As ADODB.Connection
Dim sqltext As String
sqltext = some query

My library database has books in to locations--identified as LocationID
= 1 or LocationID = 2 in my tblBooks.
I successfully created an option group on frmBooks that filters the
records so the staff can look at titles in only their location or both

What is it faster to run a SQL querie, running docmd.runSQl or execute DAO
method?
Thanks

I am developing an application that uses linked tables from SQL Server db to
ACCESS, after the number of linked tables exceeded 50 I started facing some
application run time errors while refreshing the Linked Tables Connection to
SQL Server ?

I have to write a code where I have 2 tables table 1 and table 2 which are
similar structures. I got to insert only those records which are not found
based on a key field called rec_isn
So I am trying to do something like this in access forms coding.. but it

The shortcut target is:
"path mydb.mdb" /cmd "abc"
The function Command returns nothing regardless of where I use it. By 'where
I use it" I mean that I have tried it in many places just in case it has a

I have had some challenges with some code I wrote working in Access 2000.
I read that the OpenArgs parameter does not work for reports in Access 97
and 2000.  Is the same true for OpenArgs when opening a form?
Thanks for you help.