Search results

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

Bob, I tried application.quit but it pretty much causes the same error. The error message I am getting is The command or action ‘Quit’ isn’t available now How do I make the action available? Thanks for your help

I am using a macro to exit the application in conjunction with a task scheduler. In the Macro's action box I am choosing Quit and in the argument box I am choosing Exit. I'm not sure how to accomplish this with VBA code. A bit of a neophyte. PLease advise

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

gemma the husky.... that sounds great but I am not sure I've ever heard of NL coding structure. "shows current month/year budget/actuals prior year/ variances percents, all from 1 query " It sounds like you've already accomplished exactly what I need to accomplish. Could you explain...

Kiwiman, If you could send just the report and any code associated with the report that would be great. That's a huge file to zip down to only 6meg. When I get done I'll send my report for comparison purposes. My email is bharlow@visionaryfs.com Thanks,

Kiwiman, Your P&L is an excellent example of what I am trying to accomplish. I am building a 200 line P&l for a local company. Can you put the report out here so I can see how you did this?

Thanks guys for the great response. Two questions... Mike375..If I go the null value route, which is what I was considering, is there a trick to adding a line for formating purposes after the null value driven space? Pat...That's an interesting idea. The report has different fields for...

Attached please find a dummy version of the report. As you can tell, I am just getting started. My main problem is seperate formatting and spacing. Thanks for any suggestions.

Thanks for your recommendations. Unfortunately, using Excel is not an option. I have written many P&L's, Balance sheets and Cash flow statements in excel and I know the benefits. This time I have been asked to create the P&L in Access for numerous reasons. Has anyone ever done something...

Thanks Dkinley. I was hoping to avoid sub-reports but it might be the only alternative. This P&L has 200 lines and has about 40 sections. I am hoping there is a way to include all line item descriptions in the detail section and pull only the data corresponding to each row/line item...

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

That was it. Thank you very much PBaldy

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

Mike, Thank you very much for all your help.