hello everyone, could you please tell me how, or if it is possible, to sort data in a txt box. I am using this textbox on a report and have concatenated...

I just installed access 2007 and my application uses reports to print labels. Specifically a Dymo turbo 400 and 30252 address labels. when i was using acess...

When exporting data from Access to Excel using the 'Analyze it with Microsoft Excel' facility, the columns on the spreadsheet appear in a different order to...

Hi, I want to suppress the page footer on all pages of the report except the last page. In the report's On Open event, I run the following code: ...

I use DoCmd.OpenReport and the Load event code gets executed. But when I use the DoCmd.OutputTo for the same report, the load event code does NOT...

Greetings, If Access 2000 there was a button I could add to the form toobar that would save the form as a report. I can't find it in Access 2007. Please...

Hi, I'm using Access via Office XP Pro. I am trying to format the Zip Code on the detail line of my report. I have tried the following lines of code in...

Hi I'd be really grateful for any pointers for a problem that is driving me nuts! I am trying to change a 'static' report into a 'dynamic' one. I have a...

Accuracy Accountancy at http://www.accuracy-accountancy.com ¦b http://www.accuracy-accountancy.com ªº "ºë½T·|*p" E-Mail : ¹q¶l...

Ok i am having trouble wrapping my brain around this one. I have a table, tblTotals, with Fields: Station, WeekEnd, Revenue. (text, date, number...

Access 2007 I have a report with seven sub reports within the detail section of the main report. Non of the sub reports is inside another sub report. The...

Hhi, I'm using Access on Office XP Pro. Is there anyway to force the Report Footing (not page footing) to print at the bottom of the current...

I am creating a database for one of the workers who is not computer savvy, so the database must not need behind the scenes alterations, it has to be up front...

I have a database that has two field, one by company and another by group name. I sort the report by a data range, which I use a form to select the dates,...

I have report set up - that I need to maintain the formating when exporting to a .txt file. The columns stay fine - but it adds a lot of "hard returns" or...

I am so close to completing my project. I just need to figure out how to conditionally format a strikethrough when it is not an option in Access Reports. I...

I have a report that has sums for each cost item. For a particular scope of work, I have the labor, material, contracts totaled separately. I want to add a...

I am using Access 2003 I created a Db to list and sort products by Lot #. I made this field a text field because the Lot #'s sometimes contain letters as...

I have a formula to add travel hrs and another to add work hrs. =Sum() =Sum() Can you give me the formula to add the two together? Thanks

I have a main report for Order details (RepOrders), and within it a subreport (RepInvoices). The subreport has details and a total of all invoices in its...