Search results
-
R
Limit to List and using the On Not In List Event and error question.
I have a set of cascading combo boxes. This deals with the first one and using the limit to list and On Not In List Event. When an item is entered into the field not in the list I am having it execute the below code. I receive the "Not in list error" when selecting yes in the below message. Can... -
R
Please Help
Please Help: New page on Occurance This is probably a very elementary question, so please forgive me. I have a report that displays all records. It is setup with the following design Location -> ID / Field1 / Field2 / etc... It shows the location then all the records that match that... -
R
Setting a Queries Criteria based on specific value inputs
I have a query that has a criteria set based on a particular field in a report. That field is generated from a list of locations along with an all option. Is there a way I can set the "ALL" entry to show all records while keeping the individual Location# intact? Thanks for any enlightenment. -
R
Calling criteria of a report based on form text box.
Please forgive my ignorance on this, but I am new to the Access world. I have searched the forums and am lacking on ideas. I am working on calling a report based on a textbox on my form. The textbox is populated by a combobox. The text box will consist of choices like all, location1... -
R
ListBox Search
Need some guidance/suggestions on this one please. I have a form Frm_IPList. That form house a ListBox LB_IPList. The list box utilizes a query to populate the multiple fields displayed from a table TBL_TCPIPLIST. I have already successfully setup a ComboBox that will change the records... -
R
Determining items in a listbox based on selection of combo box
I need some more guidance. I have a form that contains a listbox. The listbox populates from a table (multiple fields). I would like to add a combobox on the form, that, given it's choice will show only those entries. Combobox Options: All (shows All), Location1 (Shows Only Location1), etc... -
R
Listbox
I have a Form that contains a Listbox. This listbox is populated with the contents of a table. What I am attempting to do is when a field within the listbox is double-clicked it brings up that record in another form. I have searched various resources and could not find the proper syntax to do...