Search results

cascading "boxtype" is a combo box and "boxcrop" is a list box, they are both controls on my form [Forages] Once I click through my error messages, I can select from my boxtype to select my types of crops. If I do, I get an error message "User-defined type not defined" (It is refering to the...

Cascading NOT Sorry, it is Forages in both instances.

I have tried to research this on my own, and I'm now turning to the pros. My setup: Combobox 1 = boxtype Combobox 2 = boxcrop Form = Forages Table1 = Type of Crop Table2 = Cropnames I have two cascading boxes which when I select my first, it gives the error: "Enter Parameter Value -...

RichM, What you are saying makes perfect sense. Sorry if I was not very clear in the beginning. You are correct in saying that any weed can infest any crop. As such, a crop-weed table cannot exist. I have created the two junction tables I need. As for which entity is on top, I would...

This is so GREAT! I will copy this and try it. Thank you very much. Do I straight copy it into the module tab? I'm very new coding. I realize that I have to change my table/field names. One thing, you mention : "In your table of weeds, you would add a yes/no field "Selected". Name your list...

Still not working I have thought about the Crop to Weeds table and I do not think this table can exist. Crops and Weeds' common ground are herbicides. I have no data for these two alone. I have tried your suggestion, and my query will still not show results if I add my weeds table and it's...

I have checked my tables to enforce RI on all lookup and junction tables and somehow it still will not run any results on my query once I have added my weed tables. Does my query have to work before I proceed? I have the 2 junction tables set up, do I enforce RI on those links as well?

Forage Database I finally have the time to reply to both posts. doulostheou: I would appreciate knowing more about dragging items to the second list box. I think that would be ideal. You asked if the detailed notes only refer to the particular combination of crop and herbicide, the answer...

A good way I found to verify my results is to create a query with everything field you want to appear on your form. If your query is not working, then neither will your form, I would start by checking your relationships.

Once you have pasted the image in Word, right click on it, a pop up window will appear and allow you to select "show toolbox" one of the selections of the toolbox is cropping, it looks like two L's. This will allow you to crop (delete unwanted areas) of your picture. Note: your toolbar might...

One quick way for you to copy your form design would be press the "Print Screen" on the keyboard, then paste into word. Just crop the image like you would any other, resizing can be done to increase visibility.

I just looked it up and this is what my book says: SELECT [data], [type] FROM [NameofTable] UNION SELECT [data], [type] FROM [Name of second table] etc.... Each SELECT statement requires the same number of fields, in the same order. When you use Union command in the SQL SELECT...

How do I best display my weeds, If I use a multiple list box, the user will have to scroll up and down to verify his selection of weeds. I would like to keep them all in sight. Can I split up my list (56 weeds) into various boxes or will this complicate it too much. or can I make columns in...

second part (for some reason it did not accept my full post) 1. Select Crop (done) 2. Select weed RESULTS 3. Give a list of herbicides registered to use on your crop, and on the weed(s) you selected. In addition to this I also have many notes to include: The more complex ones refer to...

I'm starting a database from scratch and this is what I intend to accomplish. Give choice of Herbicides registered for a specific forage crop to control weeds selected. With Alex's help, I have created cascading combo and list box for the user to select the type of crop and then crop. Now the...

I'll make a few changes tonight, with combo 1 as is; Combo 2 as a listbox; and Combo 3 as a subform executed with a command button I can also change my query so I can include some or all of the notes/restrictions which go with herbicide selection to appear on my subform. Maybe I won't have to...

Combo box #1 is not related to Combo box set #2. My first box is selecting the crop. My second will be selecting weeds and since it's probable that they will have more than one weed in their field, I would like to set up more than one combo box to give them multiple selection. Then Combo 3...

Thanks, I'm just starting with access and I could use some guidance to set it up with three (actually I have more like 9 boxes). I have the instructions to make the 2 combos work, but if you could explain the concept to have them all link up that would be great. I will do some research in...

I have been reading about cascading combo boxes and I wonder if it is possible to have the final (results) combo box display if you have more than one combo box to select from. My first combo box would be to select a crop, my others would be to select weeds. Finally the third, (cascading-...