Search results

Ok Ok now I do. Sorry to misunderstand.

Am I reading this right? Forms don't store data they just let you enter it. If you click the close or exit without entering any Data why would you need a Coded "Close" button to delete the form? Or an Update either for that matter the Tool bar Save button works just fine.

You can check some through reports You can check some of whats needed with the show Feilds buttom on the reports screen it also shows you the name of the querry of table involved. I hope that helps a bit at least.

Might be Hidden But if you don't see it, click on Options and then click on Hidden objects. I've got some of mine hidden to keep them out of the users hands.

Try a Form Try using a Form with combo boxes for you selections. You could then feed those results into your query and create a report from that query to show the results.

I don't think so I don't think there is a way to do this. At least the way i was taught you can't. I usualy end up recreating forms, querys and reports when my fields change. I could be wrong, If anyone has an another answer that would help me as well.

why not use a macro Why not use a macro to run the Querys in Order. You could also set a Form with a combo box for selecting the Table that you want the querys to run on and feed that info into the querys. I hope that is not too confusing.

querys of querys It does work as neileg says i've used it my-self for a Sum of a Count in a Different Query. It should work for your totals as well.

Thanks Thank you that sample base will be a great help in the future. I figuered out how to fix my entry problem without it. for some reason (i don't know why) if I enter the dates as Month, year, day, everything works. the form reorders it as Month, day, year and then it feeds correctly...

A possability Why don't you create main report that is a summary of the Data and then in the Detail section put a subreport to list the rest of the data. just my 2 cents hope it helps.

I'm having problems with my date formats. I've entered into my tables and forms the format of "mmm-dd-yy" I'm assuming that this should display as month (3 digit), Day (2 num), Year (2 num). The problem i'm having is with one of my forms. when i enter the date it displays as Month, year, Day...

What i was using for the format was "mmm-dd-yy" thats how all of thr data reads.....no that might not be right since i put the format in after data had been entered, i better check that. EDIT nope thats not it. all my data is in the right order.

Please Disregard Please disregard my last post. I got everything working. I had to use subreports and querys out the yin-yang but everything works and works well. I hope they don't want any more changes.

Yes!!! Thank you, thank you, thank you. :D :D :D It works. Damn didn't look far enuf. The code works but only for the first value. In other words the first value for Historysum!total is 2. It fills that through the whole report rather than sorting it as it should. How can i get the...

dlookup? I've already got 2 subreports. and i'm trying to avoid a third. Especialy since the value that i insert into the main has to be used for a calculation. "=DLookUp([total],[Historysum])" Is this right for the DlookUp code? I renamed the Count field to "total" for ease of checking...

this is a bit of a mess please bear with me I have a report that uses values from a Query so far so good. now I have values in a second query (History) and I sumed a Count in that query in a Third query (Historysum). Now I set an unbound field in my report to "[Historysum]![SumOfCountOfTime...

I've set up a from with dates for Archive and Current date Information. I've entered the Follwing code for the Queries "Between ([Forms].[All Absent Data for Date Range].[Start Date Archive]) And ([Forms].[All Absent Data for Date Range].[End Date Archive])" this changes only slightly for...

ok this is so beyond me Ok i'm going batty here...the between now works. But not the way i want it to. as lon as i enter Dates in my form that are between the ranges it gives me all the data in the table. If i enter the dates from the first date to the last date i get nothing. can somone...

why don't use an Append Query An append query might be what you want just pull the data you want in T_data from the Form based on T_InitialData. If you want them in different feilds then just make sure that your where statments are directed corectly. But don't ask me how to pull that Data...

Hey Karj or anyone else. Here is a Screen shot on my form and the criteria that i put Querries. On the Main report in last Name: "[Forms]![All Absent Data for Date Range]![Combo4]" On the Subreports in Dateofabsence "(([Data Archive].[Date]) Between ([Forms]![All Absent Data for Date...