Search results

I am trying to create a image from an Access report. This report has a chart on it. My Docmd.Outputto code doesn't seem to work right. I've tried DoCmd.OutputTo acOutputReport, "rptNode", acFormatRTF, "C:\My Documents\rptNode.rtf" and DoCmd.OutputTo acOutputReport, "rptNode", acFormatHTML...

You might want to have a look at http://www.utteraccess.com/forum/Monthly-Quarterly-Yea-t1957959.html&hl=quarterly

Is it possible to put an Access chart in the body of an e-mail? I cannot find an example of this that works. I have a chart that can be dropped on a form or a report. What I want is to put it in an e-mail programmatically. I want to put it in the body of the e-mail, not as an attachment. Can...

I am a newbie with XML to Access. I am trying to import some data from a website into my database by simply copying a line of code from another database. Here is the code: Application.ImportXML DataSource:=http://website/Engineering/Tech%20Ops/RepeatTC.xml (I have changed the name of the...

For the backend?

Thanks. How do I set the backend so it supports multiple users?

I'm a newbie when it comes to putting Access databases on network drives. I thought if you put a database on a network drive that more than one person could open it. But that is not happening with a database I put on one. Is there some property I need to change?

If you're expecting continued growth you might want to move to SQL Server as the back end to hold the data.

Thanks for your help. I have a table where I save the date and time each table was updated and it seems to be working well.

Replacing Currentdb with an explicit declaration changes the table date? The problem with checking record counts is that the 2 queries are run one after the other when nobody is in the office.

The count is 0 only after the records are deleted which is immediately before they are appended.

I don't follow your before and after. I do have a button set up for running the delete and append queries.

I guess I was mistaken thinking that the date modified was updated when the queries were run manually. Unfortunately, I need a way to determine if the records were replaced in the morning before the user runs the report and a count won't do that. The only way is to update a date in a table and I...

I have 2 queries scheduled through Windows to run early in the morning. The first one deletes the records from a table and the second one (a pass-through) puts records into the table from another system. I need a way to confirm that this ran successfully. The problem is the table date does not...

When I run an insert query from the database the table's date modified is changed but when I run the query with Windows Scheduler the table's date modified is not changed. Is this possible? Any suggestions on how to get around it?

I have a form in database No. 1 that has to be imported into Database No. 2. The library references in the code module have to be put in again for this form after being imported. This is part of a daily process. Yes, the form will eventually be put into database No. 2 but in the meantime I have...

I am looking for working code or a working example of an Excel pivot table creation from an Access database. If you have ever successfully created a pivot table in an Excel spreadsheet using VBA code in Access, please post the code or a database with working code. I need to insert an Excel...

My Access 2007 is saving form changes on exiting design view without prompting or giving me a chance to back out of my changes. Anybody know how to set this so it won't do that?

I am creating an Excel spreadsheet from within Access using VBA code. In some of the resulting numerical cells there is a green triangle in the corner indicating an error. There are numbers (which are correct) in these cells. I would like to get rid of these tags and right-justify the numbers...

Is there any way to export data from Access to Excel with drill downs in the result? I've tried exporting a datasheet with a subdatasheet on it but the subdatasheet was not included in the resulting spreadsheet. I also tried exporting an Access pivot table and that didn't work. (In Excel drill...