I've inherited maintenance responsiblity for an Access db that uses dynamic
SQL and passthrough queries.   The code is very problematic and susceptible
to problems if a user tries to stop a query while running.
I want to use ADO and stored procedures to speed up the queries and ...

I have used code which retrieves the User and Computer names. I am looking to
retrieve something more permanent which cannot be changed by the user,  (to
be used in preventing the application from being copied to another computer).
Any suggestions?

what is the step that i need to take to create code in VBA?
i create acombined box that pull cust_id & cust_name from customer table.
i whant to create button that base on bulder - vba that pull all the invoice
from invoice table for the customer that the user choose.

hi my name is ritesh i am trying to design yahoo messenger , and msn
like one on meebo.com
can anyone help me how it can be done,,,
bubyee ritesh

I need have a calculated field based on hight and wt in inches and pounds.
Can anyone help implement this?
Thanks and Happy Hollidays!
RobUCSD

I have an MS Access database that is fed off about 30 linked ODBC ORACLE
tables, however the machine that this is stored on is just a stand-alone PC,
that can not be networked.
What i ned to do is somehow copy the data into standard Access tables that

i need the foxpro 7.0 product key .

When I tried to creat an MDE file from Access 2003, I get an error message
saying that my database is too big. So, how can I secure my database, so no
body can access the forms design, the modules and the queries?
thanks a lot, Lina

I have a form with a few bound fields and a subform. I also have an addnew
command button. When I press the addnew button the form goes to a new record
where the fields take their defauld values.  If I don't make any changes on
the default values or new entries in the main form ...

Im trying to find a way to put todays date into a querys where. I want the
date to change with the computers date. date need to go in looking like
1/18/2006

For instances where my FolderPath value is "C:\MyQuotation\Jan" it won't
create the directory. Is there something I can do to correct the code?
   Dim Path As String
   If Not IsNull(DLookup("FolderPath", "UserPass")) Then

I'm using Access 2000 with DAO.
I have a query that contains approx 50 fields for each record. I would like
to be able to check every field in the query for a value of "T"
If any field for the selected record has a value = "T" then the value of the

Is there a way to set some of the Access user settings (Tools/Options
settings) in application code so they are automatically set a certain way
when the user opens the application?

How can I test to see if a query is returning an empty recordset?

How to quit form the following loop after 15 seconds if Not success ???????
       Do While lngprgID = 0
           ' Quit after 15 seconds if No success
           DoEvents