Search results for query: *

Tony, It would not print out page headers and footers of the orignal reports in the sub reports. I tried to bring the information that was in the header down to the detail area but it was getting all messed up. Also the page calculations (i.e. 1 of 2) that were in the original reports were...

dcompto, Thanks for the information but it still spools as multiple print jobs.

Thanks Anne, but I need the printer to spool it as one print job. The reason is because I want this printer to take the order sheet report and the packing list report and staple them together. Unless it sees it as one print job it will treat them seperately and not staple the two reports. I...

I would like to print a couple of different reports as one print job in Access 2000. I have already tried making these two reports sub reports on a master report but was running into all kinds of difficulty. Any information or ideas are very much appreciated. dgp2

Thanks a lot humbleprogrammer. It works great!! I really appreciate it.

Thanks for the idea but it isn't quite what I'm looking for. I would like to track what computer it comes from regardless of the user name.

Does anyone know the Visual Basic code for capturing a computer IP address and put it in an Access2000 table? I currently have a form in Access where a user can enter an order, I would like to capture the ip address of the computer of where the order was processed. Any help would be greatly...

Thanks for explaining. I really appreciate all your help.

Thank you very, very much. I can't tell you how much time I've spent on this. I don't understand how to check for the leap year, can you explain this? Thanks again.

Could someone please help. I am trying to write a query that will pull all the orders for the current month LAST YEAR. For instance since this is February 2003 I would want all the orders for February of 2002. I would like this query to be automated so I don't have to put in the new...

Thank you very much ETID. That's what I was looking for.

Thanks ETID that was close but what I'm looking for is Year To Date (ie. January 1st-through todays date). and then Last Yeat To Date (would be January 1st last year - todays date minus 1 year). Any idea how I can incorporate the code you have to the code that's already there. I'm kind of a...

Thanks bkpchs237 but I'm trying to avoid having to go and reset the dates every year. Also on the year to date last year would be for the same time period as year to date this year. For example YTD would be from 1/1/2002 - 11/6/02 and last year to date would be 1/1/2001 - 11/6/2001.

Could someone please help. I have a report in MS Access2000 that shows me the number of call reports for a given company. =DCount("LinkNumber","TblCallReportLog","LinkNumber = '" & [linknumber] & "'") However, I would like to show the number of calls...