Search results

Thanks Bob, does exactly the same thing as 'Make MDE'

sorry, I misstated. Knew how to get there, just don't know how to compile from there. I thought making an mde actually compiles the db ?

Can't quite figure how to do that from form properties. I don't have any modules in the db. I did finally get it to build mde on the older db so you are correct that it apparently is in the new db. I have run analyzer as well as compact & repair.

Hadn't thought of that. I just tried it and, yes, it did. Where does that leave me ? I can understand the new one might not but the older one I tried, I had made an mde a few months ago from it. I have installed SP3 since I posted and uninstalled various programs based on info I got from...

All of a sudden, I can't make an mde file. No error messages just a blank grey screen with main menu at top. I have uninstalled and installed office numerous times, no luck. So I tried on an older db that I have never had trouble with, does the same thing. Does make a db1.mdb file in the...

That's great. So how do I open a report at the closing of another ? I am running an append query 'on close' of this report.

Never mind, that's a dumb question. Each report would be using different queries. Thanks a lot for the help.

I got that ironed out coach. Thanks. Let me ask another question. Is there a way to print 2 or 3 different reports from the one search form ? As in, print the invoice, close it which saves that to a table, (that all works) then auto opens a second report that uses the same inputs from the...

It is working this morning Bob. Played around with the docmd statement. I simply now have docmd.OpenQuery "QryInv2Tbl" and nothing else. Curious thing though, it will not append the exact same record more than once. Not that it will need to other than during testing, but I found that curious.

sorry, added to the other append query - INSERT INTO TblInvHistory ( empname, office, aremanager, unitno, unitserno, aerialno, wdate, costcenter, miles, partscost, perdiem, workhours, lodging, Totperdiem, Totpartscost, Totwrkhrs, InvTotal ) SELECT TblMain.empname, TblMain.office...

Heck, here it is. Plus I can sleep on it SELECT TblMain.empname, TblMain.office, TblMain.aremanager, TblMain.unitno, TblMain.unitserno, TblMain.aerialno, TblMain.wdate, TblMain.costcenter, Sum(TblMain.miles) AS SumOfmiles, Sum(TblMain.partscost) AS SumOfpartscost, Sum(TblMain.perdiem) AS...

Ok, I will post later today - have my other pc off and it's 2:30am and I've got to get up in a short while. Thanks and I'll get it posted

The query that populates the report works fine. I input the unitno and the date the work was performed(wdate). Both of those I have displaying on the report also. It does some calculations based on those two parameters. Once the report is printed, I just want to append all the data on the...

I copied the query I am using for the report and made the copy an append query. Every time I try to run it, since it has the criteria in it, it prompts for the info again, even though the search form is still open.

Bob, I'm using a search form to input the parameters for the report such as date, unit number. Problem is, if I try to run an append query on exiting the report, I have to re-input the parameters.

Ok guys another question I want to save/append the results / data from this report to a table to maintain an invoice history.. Since I am using a query based on input criteria to populate this report, I can't use it as an append query. Trying to copy it as an append query and running it on...

I had that in the control source but did not have brackets around the field for some odd reason. WORKS I appreciate your patience and help so much. I do this seldom just to make a program for a family member from time to time so I don't do it enough to retain things in my old brain. I always...

Hope you don't mind, but I imported your little search form FrmRptCustomers, changed the appropriate paths then I changed IN THE QUERY Between [Forms]![FrmDates].[begdate] And [Forms]![FrmDates].[enddate] in the 'edate' criteria to - Between [Forms]![FrmRptCustomers].[begdate] And...

Here's what is in the criteria of 'edate' in the query Between [Forms]![FrmDates].[begdate] And [Forms]![FrmDates].[enddate] Here is what is in the control source for the text boxes ="From: " & Forms!FrmDates.begdate & "to" & Forms!Frmdates.enddate what I;m puzzled by is using FrmDates in...

does the same with two boxes named 'begdate' and enddate' as in the statements you know this never gets to a command button it prompts on opening for the begdate then for the enddate put a command button on but no where to set event code