Search results

Well this isn't fixed. I thought it was from the macro, but now I am not sure. If I open the db and don't have the form open in startup then when I click on the button for the query to open the query opens on top of the form. If I make the form open on startup, press the button on the form...

I got it fixed-It was a macro that was closing it-that someone had wriitten during one of the many revisions-thanks for your help.

Thank you for the reply. Nope-I checked that already-The pop-up is set to no. This is a form I created and had to make the form invisible when opening reports and then make visible when the forms close, and I can't figure out how to do the same things for queries. I am working in Access 2000...

Hello All, I have a form which from a button opens a query. Once the query is open I have to close the form so the query is on top and can be veiwed. I created a macro to do that. But now when the user closes the form, I want to open the form again. I have tried to create a macro to do this and...

Thanks Paul. I checked that and started looking even more and actually I had paramters on the form that I didn't clear from when I trying everything to get it to work. It is working great now. Thank you!

Okay-so I figured this part out and have placed this in the criteria section of the begin_date. Now I get a prompt asking for the begin_date_input and the end_date_input though the form is completed. Between [Forms]![Form_Date_Input]![Begin_Date_Input] And...

Good Morning All, I am trying to get a query to read from a form a beginning date and an ending date for the query. If I query just by the user id it works great, but once I add the time-I get blank results. I have several fields in my table-user id, start time, end time are the three I am...

It makes more sense now! Thank you very much!

Still confused. How do I get to the record source sql? I understand where the label at the top comes in from the form, but cannot find any code for the dates. Sorry for being so new to this and not understanding. Thanks again for your help and any further explanation.

I apologize-I have attached the database. I assume everyone is in my head! Thank you for any help.

There is no where condition in the button-

rprtwithdates is the sample database.

Hello all, I am learning Access and am continuing to learn more and more and love it! I have gotten so much help on this forum from reading the posts and asking questions, I really thank everyone for there help. Just when I think I am getting going, I stumble though. I am trying to make a...

I got it working -thank you!

I get an error message stating I have to use the Exists reserved word. When I search i get nothing on how to fix this. Any ideas? Thank you for your help. I am working in Access 2000 and have just enough experience in Access 2000 to get me in trouble. Thank you

Hello, I think maybe there is a flaw in my design, so any help or suggestions would be appreciated. I have a table which has the fields name, productivity, grade. The grade is based on a formula and is A,B,C, D. These grades are given the time the query is ran. Is there a way I can Add how...

We'll trythis again-now I am getting an overflow error!!! UGGHHHH!!!

Sorry-Here you go

I have attached some of the queries and a table-unflrtunetly I can't add some of the linked tables-but you should be able to see all of my code. Thank you so much for your help. I just can't see why it is happening.

SELECT OTM_STATS_40.USER_ID, OTM_STATS_40.MANUFACTURING_EQUIPMENT, Count(OTM_STATS_40.MANUFACTURING_EQUIPMENT) AS CountOfMANUFACTURING_EQUIPMENT, Sum(OTM_STATS_40.Time_Percent_worked) AS SumOfTime_Percent_worked1, Sum(OTM_STATS_40.OTM_credit) AS SumOfOTM_credit...