Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Wanet Telecoms Ltd on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
ComboBox Recordset Index Field Disappeared
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...- bigjohn99
- Thread
- Replies: 2
- Forum: Microsoft: Access Forms
-
Imbedded IIF Query Statement
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...- bigjohn99
- Thread
- Replies: 10
- Forum: Microsoft: Access Other topics
-
cntrl + a
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.- bigjohn99
- Thread
- Replies: 7
- Forum: Microsoft: Access Other topics
-
Add new record in one to many recordset
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...- bigjohn99
- Thread
- Replies: 7
- Forum: Microsoft: Access Tables and Relationships
