I have a form with a few command buttons.  These command buttons open forms.
In the OnActivate event of the main form I put in the line
    msgbox "Activate"
When I press a button to open a form, close the opened form, I get the

How do I add a filter in VB?
is this enough:      DoCmd.ApplyFilter , "LastName = 'King'"       or I
need something before this which would say in which table or query?
And how do i close the filter,how do i remove it?

An application I wrote has been deployed on Citrix, and the Citrix admin
tells me all users run the same .mde file.  There aren't a lot of concurrent
users, but even 2 could be cause for concern.
I think the use of globals is worrisome in this case.  Anybody have any

A97 HELP shows the proper syntax for using Nz as
Nz(variant[, valueifnull])
I'm wondering what to expect from potential past
misuse I've made. For example, consider the following...

If this is what MySQL is set to...
SELECT DISTINCTROW qryVehiclesNowners5.SerialNum,
qryVehiclesNowners5.VDescr, qryVehiclesNowners5.Owner,
qryVehiclesNowners5.VehicleJobID , tblVehicleJobs.Reclaimed,

Using A2003.  I've got 2 tables: one a lookup table with 27 items, and
another table with client ID's and items from the lookup table.  For
every client, there should be 27 records.  However, some clients have
less than 27.  Is there a way to append the missing records to this

How do I make a command button which would make some form fields
visible when clicked? Or maybe those fields could pop up on another
form
Sunil

Should mscomm32.ocx have accompanied the installation fileset?

I have a query that is being created in code.  When the query is
executed I get the error: "The specified field 'Acct' could refer to
more than one table listed in the FROM clause".
As you can see below, the 'Acct' field is fully qualified in the

OK - I'm not an access dude anymore... 'beer' with me.
One of my clients thought they were 'doing the right thing' and
cleansed their access program folders.  Now, when they attempt to open
their database - they get:

Is it possible to convert a date format ("yyyymmdd") to ("mm/dd/yy")?
Thank you in advance

I am running the code shown below, and when it runs the
"doc.Permissions=1048319" line, I get a "Run-time error 3358: Cannot open
the Microsoft Jet Engine workgroup information file".  I've looked on the
Microsoft website (where I normallly get 1000 convoluted results based on my ...

Is it possible to remotely set a database password, provided that there are
no other users and it can be opened exclusively?  I'd like to do this in
code.  Ideally, when I deploy back end dbs with passwords on them, I'd like
to be able to change that password through various ...

In a recent review of someone's web site on a hobby forum, one poster
mentioned the difficulties for folks with some forms of colour blindness
to see some of the text of the web site in question.
Are there any general guidelines for this sort of thing in designing

OK, so I know to:
   Dim RS As ADODB.Recordset
   Set RS = CurrentProject.Connection.Execute("EXEC " & "mySPROCname")
        'make all sorts of cool stuff happen here...