When I open Access 2000 and go to a form and start writing code I begin with
"dim dbs as", and then the drop down dose not have the option of "database",
and I can go no further.  The only solution seems to be to go to an old
instance which happily does work, clean out all that ...

I 'think' this is an Access technical glitch but perhaps someone can
recommend a way of correcting it (I've searched the net and it appears to be
a recurring problem with no clear answers).
I put code into a field property event and now get an error message that

Hi all, I have set my data base to ask for password when it opens, if the
password is wrong it wont open the database, but when the user presses Shift
and open the database it baypass all the start up settings, is there any way
to password protect the open database while holding ...

Ok.  This is odd....
I programmed a button to act as a "Finder".  I modified the code that the
form wizard develops for you.  Basically, it asks whether or not you want to
search by a number.  This "number" field is typically locked, disabled and

I have created a simple find form. It has one control which is a combo box
based on a field  (txtsurname) in my table (tblcontacts). I have a command
button that when the user has selected the surname of the record they want
to find opens up a form (frmcontacts). However when the ...

I have a field in form view. and I wanted the input value to be changed the
first char to uppercase during during the filling.
How do I do it?
Thank you

how do i sort the listbox entries without getting focus on?
I am searching this function and googled through the internet not
finding an answer ;-)
my objects: form, listbox and command

I am attempting to obtain the Text value of a combobox control in the
footer of an Access form.
As Access does not allow you to obtain these values without first
having "focus", my code looks like this:

I'm using Access2000. I have a form and a combobox that filters the
recordset attached to the form. This has worked before (and for over a year)
but has failed recently. Not sure why.
I get the error  "Run-Time Error 2501: The ApplyFilter Action was cancelled"

Is there a way to check if the Access application main window is minimized?
I'm not talking just a form window - I mean the Access application itself.
I want to be able to behave differently depending on whether Access is
minimized ot not.

I've got 2 combo boxes on a form, the 2nd one is filled based on a selection
from the first combo box, triggering off a Change event.
If I select a name and then clear it from the 1st combo box the options
available for that choice remain under the 2nd combo box, how do I set it ...

When entering code like
           Me.Rabies.Visible = True
after typing the period (.) following Me a list appears that includes the
word Rabies (one of the fields I created).  In looking at the online

Hello. I am trying to create an input mask of the following:
060131SB01
Here is what the numbers and letter represent:
06=Year

I know the string  that I am using works but I have restrutured it.  What I
am trying to do is have a varsortby option and combo box drive mulitply
reports.  All the quiers and reports have been tested they work.  However,
when I use process button where I created the string of ...

Can someone suggest how i might get this line of code to read $50.20
instead of 50.2 ? (the field in question is [Sell Rate]
       MessageText:="Please note the following invoice is overdue:" &
vbCr & "Invoice #: " & [REF #] & ": for the amount of " & [Sell Rate] &