Recent content by bharlow

It's been a while since I been out to AWF and I hope everyone is doing well! I am trying to write a query that will group sales records by sale number and set type, but when the sets are the same the query groups incorrectly. I do not know how to create unique group points. Here is an...

Hi Bob, That does not appear to work for multi column reporting. I can get that to work fine for regular reports but when I set the property to hide duplicates in the multi column version it does not do anything. Also, I would need the first column of dates to show up on the second page as...

I have multi column report that goes over then down and I need to figure out how to only show the first column once. The first column is the date which is the same for every store so it does not need to repeat with each column. What I have: STORE 1 STORE 2 STORE 3...

Here is the code. It works great on all our other servers and it works fine on this server as long as I am logged in.???Any help is greatly appreciated. Private Sub cmdEmailIndividualCustReports_Click() On Error GoTo Err_cmdEmailIndividualCustReports_Click Dim dbs As DAO.Database...

I have a number of Access 2007 DB's on different clients servers that I send emails from daily. I send emails using two different methodologies. First, summary emails go out via the SendObject Macro (no code). These go out every day with no problem. Secondly, I send report bursting...

The control for UPS is named Text96 the control source is =Sum([UPS])

Here is the code... Private Sub UPS_Label_Click() Me.OrderBy = "[UPS]" Me.OrderByOn = True End Sub

Thanks both boblarson and ajetrumpet. I tried the code as suggested... Me.OrderBy = "[FieldNameHere], [Field2NameHere] Desc, [Field3NameHere]" Me.OrderByOn = True I got this error message... You tried to execute a query that does not include the specified expression <name> as part of an...

If I have a report based on a simple multi column table, how can I let the readers sort by the different fields on the report by clicking in the column header (label) or clicking somewhere in the column?? As always, any guidance is greatly appreciated!

Mstef, Thank you very much. This has been working consistantly since we changed the close application process.:)

Thanks MStef I'll give it a try. It will be tomrrow before I know if it gets around overnight issue.

I have built a process using task schedulers to run Access DB macros and then close the application with a Quit Command. If I am on the computer, testing the process, the task schedulers run perfectly and all macros run and the Access application is closed. When the task scheduler process...

Thanks David I'll look into how to accomplish this.

David, If each user has their own copy of the front end DB on their machine and I have 15 users, does that mean I need to link in all 15 tables to the backend and Union the tables or is there a better way that I am missing? Thanks for your thoughts on the subject!

The Network guy is loading SP2 so hopefully that will fix the problem. I was wondering if it had anything to do with the Front End shared users being open while running the macros on the Backend. I was not sure if the linked tables were causing the problem. I have been getting a lot of You do...