I am having trouble with the code for the following task
Table: Master List
Form: Home
Form: Details

Good day all,
I have a form that is loaded based upon an option in a table.  For example,
depending on the layout the user wants to see they can have either frmTodayA,
frmTodayB or frmTodayC loaded.

I have added code to a form object's Not In List event to add the item to
the row source automatically.  While I'm in the form, the item is still there
to select, but when I close the form & re-enter, the new items that I just
had code add, are not there anymore & it defaults ...

I don't understand why this isn't working.  I just want to make sure that
they don't put a future date in the polydate field.  Is me.polydate > now()
an invalid expression?
code:

I have developed a form for generating reports.  Users have an option
to select criteria as well as the option to export to an excel
template or Access report.  The problem I am having is that even
though "multi-select" is enabled for my list boxes, reports will only

Spent a good day searching the groups and learned that it does not
seem to be possible to use some type of dropdown with checkboxes.
I find it very hard to accept that a product like Office2k7 offers
such a flexible way to filter your data (dropdowns on column headers

Is possible to open a database that is protected by a global password (Tools
Menu, Security, Set Database Password...) programmatically from another
database and without having Access prompt the user to enter the password?
I've tried almost everything... but hope there is still a ...

I use the function below to return the server or database name for various
uses.
However, now that we've switched to 2007 the line
CurrentDb.TableDefs(0).Connect

I have been working on this Access DB since early this morning and now
somehow the file has become corrupted. I cannot run a compact and repair. I
ran Jetcomp and it created a new file but the corruption is still there. I
cannot export or import the modules to a new database. I ...

Thank you I'm using Office Access 2003Why this code not work? And this
message box appear to
me?'''''''''''''''''''''''''''''''''''''''''''''''''''Runtime error '91'Object
variable or with block variable not set

( I KNOW i've done this before!)
I have 2 unbound subforms on a main form. When the user clicks a record on
subform A, i need to find the corosponding record in subform B.
This code:

I have a form that has two Combo boxes. One is to select a
department(Collateral, Loan Accounting, Inaging etc... and the second is a
CBO that has different items hyperlinked for that department like databases,
forms, spreadsheets etc..

Morning all.  I'm seeing something really strange on a form I'm
reviewing, wondering if anyone can offer any suggestions.  Access XP/
Windows XP.
I'm opening the form to add a new record with:

I have a subform with a tab control that I would like to toggle between form
view and datasheet view.  Is there an easy way to accomplish this.  I tried
the following code, but changes the master form, not the subform within the
tab.

I'm trying to insert all records that meet a certain criteria and I'm
getting an error.
Whats wrong with my syntax?
Thanks