Search results

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...

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...

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...

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!

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...

Every few weeks one of our DB's give the following error message... The database can not be opened because the VBA project contained in it can not be read. The database can be opened only I fthe VBA project is first deleted. Deleting the VBA project removes all code from modules, forms, and...

I have a front end DB for stores to enter certain performance metrics that combine with POS data in the back end. We allow the stores to input data in forms through MS Terminal Services remote connection. This has worked perfectly in the past but one of the groups we are currently setting up...

Is there a way to replace the title/header for all reports in a DB at one time? For example...I want to change the Report titles for about 50 reports from XXXX - SOUTH to XXXX - NORTHWEST without having to open all 50 reports.

I am about to have a heart attack because I got the following error message after an entire days work in access .......Unrecognized database format <filename>. (Error 3343) Any thoughts on how to fix this problem would be greatly appreciated!!:(

I have written a ranking report and would like to give the user the ability to rank on different fields in the report. My query gives rankings for all fields. Is there a way to use code and the on-click event procedure to allow the user to click on the label on the top of each column to...

I created a macro to close Access by simply using the Quit action with the Exit argument. When I run the macro I get an error message like this... You may be in a read-only db or an earlier version of Office The type of object the action applies to isn't currently selected or isn't in the...

Has anyone ever written a P&L or Balance Sheet using Access reports? This is going to sound pretty bad but... how do I add a row to the report for each line item? My table looks like something this... DESC ACT BUD VAR SALES 100 90 10 COGS 50 40 10...

I have a number of macros that send reports via the SendObject action. They all run perfectly except for one that gives the error message... A custom macro in this report has failed to run, and is preventing the report from rendering. The report opens perfectly and I can run the SendObject...

I have a form with a singe button that on click runs the following code... Private Sub cmdEmailIndividualCustReports1_Click() On Error GoTo Err_cmdEmailIndividualCustReports_Click 'Declare Variables and Objects Dim dbs As DAO.Database Dim rst As DAO.Recordset Dim strSQL As...

I have built a form to send out multiple emails by clicking a button. What is the best way to automate/schedule clicking he button once a week. I was building a macro to OpenForm, GoTo Control an SendKeys "{Enter}" but it keeps getting an error message at the end. It does not get that error...

Is there a way to disable the Outlook security warnings so that I can send email from Access with clicking "Allow" Program to send email on my behalf?

I have a query that allows the users to pick a date range using the criteria Between [Enter begining Date] and [Enter Ending Date]. Is there a way to replace the box under Enter Beginning Date and Enter Ending Date with the built in DatePicker in Access 2007? Thanks for any advice!!:confused:

If I have a report that returns results for below goal, meets goal or exceeds goal is there a way to show the results as an image? For example... My report currently says Store Period 1 Period 2 Period 3 100 B C A where A=exceeds goal, B=meets...

It's been a long time since I've been out to this board and I'm glad to see it's still going strong. My question.... Is there a way to use an if then statement to format numbers differently in each row of data returned in a report? For example, I have created a report that returns 25 rows...