changing sort sequence (like tab order) 4 297 (2/16/2007 10:51:10 PM)
Today data is entered into a table in the order it needs to appear on reports. there is no well defined sort key such as alphabetical, or age, or address or anything. If the user is very careful and enters ...
Utf

Pre-position a combo box 9 115 (2/15/2007 10:21:54 PM)
How does one pre-position a select in a combo box? I've just added a new record to the Rowsource and have Required the combo and want to have the newly added record pre-selected following the Requery. I would...
Bill

Newbie 1 131 (2/16/2007 8:47:10 PM)
I am a total N00b at access and coding within. I would like to learn more, Especially how i can when i press the command button search that it will look in table "users" and find the user id which was typed i...
Utf

Walk me through configuring a db for trusted authentication with SQL Server 2005? 5 122 (2/16/2007 5:27:09 AM)
I am using SQL Server 2005 Express and the Management Studio as the backend for an Access 2003 database. I would like to use trusted authentication. So far have done this: Created a windows group called dbu...
paro

RTF2 1 149 (2/16/2007 5:22:51 PM)
I'm been trying to mess around with some older db's I developed in Access 97. Basically what I have is a form with fields inputted by users, they use them to print out reports that should look like the follo...
Jer

Very frustrated with BeforeUpdate event 4 128 (2/16/2007 4:48:15 PM)
Hi I'm mainly a lurker and I've been searching through the list for a few days trying to find an answer to my very frustrating automatic save problem. I have a form with a subform in it. In the subform there ...
NoviceNana

Need to check for duplication 1 132 (2/16/2007 4:24:15 PM)
Good morning, I am trying to do some validation to check for duplication in records and I can't get it to work right. In my form (frmStudents, based on the Students table) I am trying to assign student number...
Beth

Using a check box to filter a combo box 2 586 (2/16/2007 2:18:13 PM)
Is it possible to filter a combo box based on a check box - or multiple check boxes. I've got combo boxes that list all the standard parts a company has in their inventory. [cmb_Parts1] and [cmb_Parts2] Two ...
gweasel

Create a new Parts record from an exiting one 2 178 (2/15/2007 8:20:04 PM)
I would like to create a form that prompts for an EXISTING part number record in my tblParts and then creates a NEW part record for a prompted NEW part number. All of the existing field values would be "copi...
Peter

Errant Form ShortCutMenu Behaviour A97 1 141 (2/16/2007 1:37:51 PM)
Hi Folks I have several forms which use a custom shortcutmenubar. Generally this works well - but I have just noticed on several forms it offers the Hide Column menu selection. a. This is not in my custom s...
Kahuna