In Form I put a button that was wizard to open a Report.
I went into build event for that button and at the DoCmd added a WHERE
condition
was:

I have a th following code and i am trying to open saved form based on odred
id.  When i am opening form I am loosing top part of that form (names,
address..) Bottom portion of this form is correct and have correct info
(order id, totals..)  Thanks for your help

I have an option group with 5 radio buttons, if at data entry the operator
mistakenly clicks a button yet didn't want any of the 5 then I want to set
the option group back to null, the default. The control is a number, integer.
I would be happy to have a button when clicked sets ...

I am currently editing .ctl files with word, since there is no automation
with notepad.  Has anyone else done this, and if so, how successful did it
go?  Just want to know what I'm getting myself into...

I could use some help with manipulating existing dates around weekends and
holidays.  In other words, I have existing dates that need to be changed so
that they only fall on a workday.  I need to write a routine that will do the
following:

where can i go to find out how to use bookmarks

I have been using the technique shown below to create forms bound to SQL
server tables and views using ADODB recordsets.  It works so well that it
seems almost too good to be true.
My major concern is whether using ADODB recordsets will lead to deadlock

I use late binding to instantiate an object as an InternetExplorer WebBrowser.
I would like to have some code get fired when an event within the WebBrowser
Object is fired (specifically in this case, the DocumentComplete event).
Is there any way to trap this event and have it call ...

I have a databse which creates and drops 15 - 20 large tables  each day. I
want to mimic the compact on close feature available on later versions of
Access. I have tried the below at the end of my code which builds and drops
the tables

I've a procedure (given below) that attempts to indicate Password strength to
User who wants to change his/her log on Password. But, I'm not convinced
about the elegance of this procedure.
Can someone help me with a better code ?

I am looking to set up a VBA function that looks at a field on a report and
if that field matches the criteria, it displays a dollar amount found in
another field on that form. Example...
If the month found in [forms].[payment].[month] is January or April or July

Hi - I have created a database in Access 2000 that works fine.  When I view
the database using Access 2003, the data entry forms stop working.  Are there
any bugs I should know about or code changes in Access 2003?  I have checked
the libraries and the only difference I can spot ...

This shouldn't be too hard but I can't find the right answer: How can I
enumerate all databases in my SQL Server (V7)?

I have a report, which essentially has one record, and I'm writing the data
to a text file within a specific format. However, although it's only one
record it has a one-to-many relationship with records in another table, and
the report lists these. What I want is a for-each loop ...

I have a another database that is on our server and I would like to open it
from
our switchboard. I would like this to be accessed from a button on the
switchboard.