Recent content by r3df1sh

Thanks WayneRyan that did the trick.

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...

Derek, That worked wonders. Thanks for your 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...

Thank you for your response. I will try to better explain my situation. In my table the records are stored with a Location field (ex. Earth, Venus, Mercury). I currently use the combobox on the form to dictate what records are displayed on the listbox. The combobox has All, Location1...

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.

ok I figured out how to do most of my problem via a query, however I am stumped on how to include the "ALL" entry. If the field is set to All it then populates all records in the report.

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...

For those interested I have changed the way my text boxes search to now allow partial entry. Placed in After_Update of TextBox Although this does not satisfy my origional question it will serve in my case as a route around what I am wanting to do.

The reason it is not working is the reference to the Microsoft DAO 3.6 Object Library is missing. Here are some steps you can try. 1. Go to your Database:Modules 2. If no module exists click on New. 3. Once the module page loads, click on Tools. 4. Click on references. 5. Check and see if...

Please disregard question 2. It might not be the right way to accomplish this but here's what I did. In the command button I placed:

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...

It might be the newbishness, but I have looked throughout several examples and am still lost. Perhaps I can explain my attempt better: On my form Frm_IPList I have cb_iplist list box. (The displayed contents of this form are 7 fields in my tbl_iplist table.) Right now it simply pulls all of...

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...

Thanks for the speedy response. I followed your instructions and it works great! Thanks again