Anyone come across this? With capslock on, typing into a combobox after a few
letters are typed in, the text in the combobox fleshes itself out, but not in
the normal way.
The normal way is for Access to display in the combobox the first entry in

Hello again <g>.
This time I'm looking for comments / suggestions as to whether I'm on
the right track or not. The code sample below is doing what I expect it
to, I'm just wondering about my coding technique.

Throughout a database, I have used a command button in forms to close the
form when clicked.  While it has worked for a long time, recently when I add
a new Command button to do the same thing in a new form, I get the message
“You entered an expression that has an invalid ...

I need help with getting one of my forms to auto populate if a text string is
found in the table.  The Database is used for medical record tracking of
documentation.  The key record is the SSAN (social security number).  I have
a form based on a table called TblRecords and a subform ...

Hello.  Thanks for the help.
I have a form where I am using an if/then code to open a subform.
Example:
If Color = "Red" Then

I have a simple form I created for a customer database. On it I have included
a group of option buttons.
ie:  Relationship To Pt
    O  Self

I have created a database for a group of users who have different
screen/monitor sizes. On the larger screens, the main form 'overflows' at the
bottom of the screen so that the user is unable to see all the form. Is there
any way to modify access (on the machines with the larger ...

I have created QueryTable from MainTable showing data sorted by StartDateTime. Is there a formula or way of updating the added column QueryTable.PreviousEndDateTime with the value of QueryTable.EndDateTime from the previous row in the query for each record in the query?
The end ...

Keyboard shortcut for Delete - Is there such a thing and can I disable it?
I did a quick look through both Help and this forum, but didn’t see an answer.
Working in 2007
The Pres. of my company accidentally deleted a “record” while trying to add

If I have 2 list boxes, one that contains part numbers and one that contains
reasons why that part may be defective, how to do make it to where the list
given in the "reason" list box changes based on the part number selected in
the "part number" list box?

I am creating a user interface project for data to be updated/inserted into
some SQL Server tables.  My question has to do with how Access 2003 forms
handle updating records.
Basically, when using the form, I change a value of a field and go to the

Hello,
I'm trying to set up the tables, forms, and reports required to generate
chains of custody for samples collected in the field.  So far I have the
following tables:

Can I create a form in Access and email it to someone for them to fill out?

In ac2007 how do I prevent access from anchoring labels to fields??!!
There doesn't seem to be any easy way.
James

I created a form with one option group on it and later added a second option
group but when I try to reference the options in the second group in VB code
it doesn't "see" them.  
Basically my form consists of a text box called KW