I have the following code, which returns an error Runtime Error 2464 Data
Type Mismatch in Criteria expression
Private Sub Form_Delete(Cancel As Integer)
   Dim varDeliveryID As Variant

I am constructing the following
forms!formname!pageno.visible=False
from variables held in a table. Specifically the pageno and False/True are
picked up from the table. I'm getting formname using CodeContextObject.

I have a database with a logon screen, I would like to be able to open a
separate form for anyone logging in as an Admin vs someone logging in as a
User. Bellow is the following VB code used to open the WelcomeForm once they
authenticate the logon. Is there a possibility to add that ...

Hi - My automation database imports a lot of reports from excel. I have been
running this database for quite sometime now and all these days it has been
working fine. I split the databse and now i get this error
"Numeric field overflow"

I work for a medium sized college's security deparment
all deparments use radios and comunicate via a central dispatcher
when the call dispatch they enter their radio call into an accses database
that i have now inharited.

A report creates temporary tables for its own use during the Open event.
These tables cannot be deleted during the Close event, because they cannot
be locked while "still in use" (by the report itself apparently).
- How can the tables be released by the report before attempting to ...

I have a form with many fields.  Users on a network are allowed to create new
records or edit existing records in this form.  I have 3 fields in the form
that must be filled in by the user so I can properly identify the issue.  I
can set these fields to “Required” and that will ...

I would like to know how to programmatically get a list of all macros AND
their sub-macros.  For example, if there is a macro called "Reports" and this
macro contains the following Macro Names: "Report1" which opens report #1 and
"Report2" which opens report #2, I'd like to ...

I want to pull a group of random numbers within a certain range, but
don't want to check after each grab whether I've previously pulled the
number.  For example, let's say I want to generate three random numbers
between 1 and 100.  I'll store the numbers in an array.  Can I do ...

I have the following code in a from where user is to enter New Ingredient.  
It catches the error when a duplicate Ingredient ID is used.  It works so
far, but what I want it to do is to clear the incorrect IngredientID they
have started to enter it.  I can't figure out what code ...

Is there a way to display images in a combo box so the user could select
which one they want?  I know there's a way to do this in a separate form, but
I'd like to know if there's a way to do so directly in a combo box.
Thanks,

I have a database connection as follows. It uses a named server and NT
(Windows logon) Authentication. It connects to a SQL server:
With dbconn
  .Provider = "Microsoft.Access.OLEDB.10.0"

I am wondering what kind of code I need to use to open an existing Excel file
& paste Access data into an existing tab - with the key being to preserve the
formatting on the worksheet tab that already exists - such as font, column
width, page headers, conditional formating and ...

I have developed a application in access. Now, i moved this to the a common
drive where all my tem members can access it.
I tried database splitter which splits  into front end(forms, queries...)
and backend(tables). also, i can see all tables from the front end are linked

I have conditional formatting set up (see below) and I would also like to
open a form if the conditions exist.  Can someone help me.  My form name is
"CRITICAL STATION FORM" and it's a pop up form.  Thank you.
Public Function fTestConditions(strLine, strDesc, strWorkStation)