Search results

THANKS! DCX Duh -- Wack!

I'm sure this is easy but as ussual can't get it to work I have a pull down list box in a form - List is off a table I've sorted the table (asending) but canot get the list box to do the same. I'm already to slap the forehead and go "duh" so don't hesitate to show me my error Thanks

Worked like a charm! God, some time the simplest things makes you feel like a dope. Thanks again.

Hello all - I've done this before but for some reason it doesn't seem to be working now. I have a table with auto number as the primary key. In testing my database i made up stuff to test and am now ready to begin using it. the problem is I would like the auto numbers to be in sequence and not...

sorry Bat. I was out of the office- I don't see any attachment but that might be my firewall- I cannot download from the net.

when I open the form that I made and enter the dates, hit ok, it closes the form and nothing happens. am I making this any easier to understand? sorry guy have some patients. I did follow the help step by step on how "use a form to enter report criteria"

I think I'm doing that. is there something I can paste here that would make this easier to debug?

thanks bat, but no luck - also I'm using 2000

where to start? I have a report running off a query. Criteria is entered off a form. when I enter the criteria by running the query I get the result I need but when I run it from the report it goes through the motions but I get no results (blank report). I know more info is needed but as a...

I was afriad some one would say that. I've tried that a couple of times with no luck and not sure where the problem is to even post it here. Thanks anyway - until I can get to the cause of the problem with entering it with a form I'll have to stay the course for now. Thanks! Tcommis

Hello all - Is there a way to have an imput mask for you criteria in a query? I'm asking for a "short" date, (I don't want it displayed in the query though, not sure if that makes a difference) and right know I'm relying on the operator to type it without an input mask, which is causing some...

JT -- disregard my last post -- it worked! i must have been doing something wrong Thanks Again!

Jt - I tried that, but because I'm hiding the date in the query results it doesn't show up in my control list in my report. If I unhide the date in the query - yes it prints out, but then my query doesn't sum correctly. I'm really not sure if its a report problem or query problem, but thats for...

hello all - kind of new at access but know enough to get around. I have a report being generated off a query that is asking for a start and end date. Problem is I can't display the dates (or don't know how too) because it screws up my sum command. no big deal in the query but I need that...

Thanks Dcx693 that worked - knew it had to be easy.

I'll try and put this a simple as possible - I know it can't be that hard. I have 2 tables - chemicals purchased and chemicals used and two querys that give me the sum of each the 3rd query is the (sum of chemical x purchased) - (sum of chemical x used) which gives me the sum of chemical x "on...