Recent content by brokenwh

Thanks Thanks - That made it work - I appreciate it!

Still not working I tried the requery and it changes the information on the form to the first one done instead of staying on the current form. Any other suggestions?

Good Morning: I have one small questions and am having trouble with it. I have a form with a macro button to preview a report based on a value in the form (PONo) The report is based off of a query. My question is - What can I do to make it so the report is "up to date" when the button is...

Thanks Thanks for the Help - It's Working Now!!!

Thanks The information in the combo boxes are text and I reworked the code as you suggested. I am still getting an error message stating. Syntax error (missing operator) in query expression '[Project]=Supplies'. Any other ideas that I am doing wrong? Private Sub Combo60_AfterUpdate()...

I am creating a combo box that selects its list based on input from another combo box. I have done this several times before, but I am getting a "Missing Operant" error message and am not having any luck trying to get it fixed. Here is my code: Private Sub Combo60_AfterUpdate()...

Greetings: I am trying to create a report that will list various project categories. I am basing it off of a query that uses three tables (PONo, ProjectNo, Project SubNo). The design is such that the PO# table has 4 sets of ProjectNo and Project SubNo lists (i.e. Project 1, Project 2...

THANKS - One more question I appeciate the help and so far it is working GREAT. I do have one more question. All of these entries are based on a date (mm/dd/yyyy). On my form I need a way to be able to select the month and year and have it relate back to the mm/dd/yyyy format. Any suggestions...

Good Day: I am trying to create a form where you can select different criteria from combo boxes (i.e, account names, months, year) and use those criteria to print reports. I am not sure where to start and how to organize this. Any help and suggestions would be GREATLY appreciated. THANKS

THANK YOU THANK YOU THANK YOU!!!!!!!!!!!! That worked.:D Thanks for all of your help!!!!!!!!!!!!!!!!!!!!!!!!!!! ;) ;) :o

It is a number field as a Double Field Size

Almost Thanks Fizzio I think we are really close. I had a few errors that I worked out. The only problem is my query is empty with any of the ID numbers tested. Anyother ideas? Thanks

HEre's the SQL Thanks I think this is what you are wanting. I hope it is explainable. SELECT [Classes&Premiums].ClassNo, [Classes&Premiums].ClassDesc, Exhibitors.ExhibitorNo FROM Exhibitors, [Classes&Premiums] WHERE...

First of all I am quite new to Access and on on a short deadline, so please bear with me. I have created a query that lists class numbers. I need the query to limit the class numbers based on an ID field off of a form. I think I have the ID field related to the form correctly, but I am having...

Greetings: I have a form that has two sets of combo Boxes. One is labeled ExhibitorID and the other is ClassNo. I need some way of making it so that no ExhibitorID above 500 can enter into a class below 2000. I am sure there is an easy way, but I can't figure it out. TIA