Search results for query: *

I have a picklist table which contains: PickKey, FieldA, FieldB A Form bound to a table which contains PickKey from above picklist table as foreign key. A combobox field on the form links to above picklist as row source with PickKey as Bound Column. This combobox field had been working for a...

Thanks PH! your way does work... Do you know why the other way does not work?

The qurey I ran is: Select FieldA from TableA where (TableA.FieldA = IIf([Forms]![frmFormA]![ComboA]<> "ALL", [Forms]![frmFormA]![ComboA], 'ALL') When I select an item, the query returns the correct item record set, but when I select 'ALL' it returns an empty recordset. (There is no SQL...

Hi PH, I must be running a different query when I tested it. When I tried it again and it still failed.

I just tried it and it works. Thanks.

Thanks PH. But 'ALL' is not an value in Field A.

Not sure why the following query failed: Select FieldA from TableA where (TableA.FieldA = IIf([Forms]![frmFormA]![ComboA]<> "ALL", [Forms]![frmFormA]![ComboA], ([TableA].[FieldA] like "*")) This query gets created dynamically in Forms.frmFormA based on FieldA's comboBox selection with...

Evalesthy's post works! I was doing the same thing along the line accept I was not awared of the KeyPreview property. This is great! I also noticed that user can also select all records from Menu Bar --> EDIT --> Select All. The suggested code would not intercept it and Customize Menu Bar...

While a form is opened, pressing on cntrl+a and then delete would actually all the records from the table that is bound to the form. Is this a hole in Access and is there a way to circumvent it? Thanks.

Thanks all for your suggestions. Great forum!!!

Hi Richard, This is just a simple database to track workload. Every hour on the hour the system generates an Unique number and all the workloads within the hour will be grouped by this unique number. As you see, the Unique number does not require any additional descriptions other than just...

Hi Richard, Thanks for the response! The linkage between these tables are set properly. That is why the viewing and scrolling through records are working okayed. The problem I am having is the Main Form has only one field which is USERID with AutoNum. When I am trying to add a new UserID...

I have 2 tables set up in a one to many relationship. Table 1 contains only one AutoNum field as UserID. Table 2 has 2 fields with UserID as Number and Datestamp as Date. (These are just simplified examples and the relationship between tables are set to cascade update and delete). I created...