Search results

Auction Database Report showing like items only once. I have a auction databse for a small scholl. They have multiples of some items. What I would like to do in the main report that is going in a program is to have the multiple items just be listed once with all of the item numbers for it...

Got an Answer from an SQL expert thought I would share. I received some SQL for this issue from a friend of mine. It is as follows. Tables and colums are: tblItems ItemNum,ShortItemDesc,FullItemDesc tblCatRanges BeginNum,EndNum,Category,GroupNumber Here is the SQL SELECT i.ItemNum...

Pat, Thanks for the reply. I am running this SQL and getting error Join Expression not supported. I am running Access 2003. Here is the SQL: Select Categories From tblCategories Inner Join tblNewTable On ItemNumber >= BeginNum And ItemNumber <= EndNum I also didnt quite understand what...

I am working on a small database for a school to track their live and silent auction. Currently I have a table set up as follows. Silent Auction table : Item Number Short Item Description Long Item Description there are more fields that I am not interested in right now. Mainly what I am...

Much like that From your example, I got my drop down search to work. It displays in a query window. I would like to have it display on the same form below where the seach combo box is. I am thinking in a list box. Just so that is looks cleaner. Also I dont want them to be able to edit any...

I have a small database to track childrens books for a Preschool. I am keeping the database as simple as possible for the director. I have 3 tables Book_Information Authors Book_Category I have relationships established and a form for them to enter data easily into. I used the OnNotInList code...

Figured it out Thank you to SJ I finally found the code that you have posted on the forum and it works like a champ. Or maybe the light bulbs just finally turned on. Anyway....thanks to all on this forum. I really like the wealth of information available. Next time I will be sure to post...

I am totally confused. I have read many posts regarding the subjects above. I am using Access 2000 and have tried much of the code posted here to get OnNotInList to work. I keep getting errors and now I am lost. Please help. Thanks in advance.

I dont currently have an ID field in my Lead_information table. I can put one in. Also I dont know that I want to delete the record from the lead_information table. The form name is Lead_information and the form for sold_jobs table is sold_jobs. I have no subforms.

I have a table lead_information and a table sold_jobs. I want to put a sold button on the form for lead_information. I want the sold button to append the current record to the sold_jobs table. The fields in each table are the same except for the sold_jobs table has fields that the...

The two tables dont have the same data. They have some of the same information. The sold jobs table has additional data that the lead information table does not. I dont want the lead information cluttering up the sold jobs table.

I have a table lead_information and a table sold_jobs. I want to put a sold button on the form for lead_information. I want the sold button to append the current record to the sold_jobs table. The fields in each table are the same except for the sold_jobs table has fields that the...

I would like to add a button to my form that will print the active record in a report format. I am somewhat a rookie in working with Access so any help would be appreciated. Lee