Does this work for code behind forms?  Debug - F8 is a no-op for my forms subs

I have the following function which uses JET to return a disconnected
recordset; this runs great.
I just need to tweak this function to work with a password protected (i.e. a
database password) Access DB file, can someone show me how best to accomplish

How can I convert todays date to hex for use as password validation??  
For example, todays date 11202006 = AAEDD6
If password entered = AAEDD6, and today's date = November202006, then allow
access, else exit sub.

I have a problem with a split database when it initializes.  The front end
connects to a SQL ODBC connection.  I have commented out one line of code and
the app seems to work perfectly.  I was just wondering why this one line of
code could be the culprit.

Is there a way to ping a DB just to see if it is corrupted?
I'm sure there are many things that can fail and many results possible
depending upon how a DB fails. Basically, I just want a programmatic test to
see if a DB seems to be working OK.

i would like to know, how to create a report based on the date entered. for
example a report about items purcased on 1/106 till 30/1/06. how to use the
[start date] and [end date]? in my database, i have a date purcased field. so,
i would like the user to enter the range of date of ...

I have encountered an error with Access 2003.
If an Access mdb database contains a reference to another mdb database and
one attempts to 'Compact and Repair' the database after compiling the
database in the same session, Access will end in error.

I seem to be having a Monday morning moment.  I have a simple task to code,
but for some reason I can't get my head around it.
I have a recordset open.  That's fine.  I know that there will only be 8
records in this recordset.  What I want to do is populate an Array with a

Recently, a user came to me and said that the email code that use to run as
of last week no longer runs in the database I support. The odd thing was with
this request is that not everyone had the function stricken. But if a user
that couldn't use the email function logged into ...

i would like to know, how to create a report based on the date entered. for
example a report about items purcased on 1/106 till 30/1/06. how to use the
[start date] and [end date]? in my database, i have a date purcased field. so,
i would like the user to enter the range of date of ...

Is it possible to set the focus of a form to Null from VBA?  I have a form
that when it loads I would like to NOT have a control highlighted (ruins the
look).  
Thanks in advance for your help.

When I run the example from MSDN title 'Creating managed addins for Access
2007' using the C# version the process errors out after reading the
HookupControls procedure in the managed code and returning to Access control.
The error message suggests that there is no instance of ...

In order to open database of access in design mode i use Shift on the start
to disable the startup action and macros.
I got here before a code that nutrilize the shift action of access.
i need it again. can i get it?

I am trying to increment a job number with the following code
Private Sub BtnAddJob_Click()
   'Increment Job No By 1
  Dim dbJobs As DAO.Database

Not sure if i'm posting in the right spot so sorry if its not, please
direct me to the correct location :)
I have three fields in a form, [quote accepted], [days to results] and
[target date]. I need to calculate the target date by adding the [quote