Search results

Have you explictly closed and saved the spreadsheet file, rather than just setting the object to Nothing?

Just read yor original post and saw that it was Access that was freezing - not Excel. My apologies to you. I would imagine that the problem is in Excel, but I don't think that it is realted to the macros. Without seeing examples of both types of spreadsheet, it will be difficult for me to work...

Just looking quickly at the code : it looks as though if it opens an valid Actuals Spreadsheet OK, appExcel never recieves a ".Quit" method.

Use http://www.access-programmers.co.uk/forums/showthread.php?t=77377&highlight=report+attachement as a basis. You would need to save the report as RTF (or whatever) to disk, then code based on the above.

Possibly, but I don't think so because when you run report using the second SQL string, Access shows a prompt box as well. Are you sure about the date/string data type thing? My only other piece of advice (if you're not already doing it) is to run the DoCmd line from within the native access...

Try MySortedField : nz([TABLE1]![employees number])+1000*nz([TABLE1]![agency number]) You should avoid spaces in Access fieldnames, if possible, but the above syntax will help circumnavigate that problem. EDIT: Or use the expression builder - that will give you the correct syntax

Do you mean that you placed it in the Filter property for the report? If so, I don't have any ideas. If not, try putting CustomerXOrder.CollectionDate = '24/12/2005' into the filter property and open it within (a) access and (b) VB6

Do you mean that you placed it in the Filter property for the report? If so, I don't have any ideas. If not, try putting CustomerXOrder.CollectionDate = '24/12/2005' into the filter property and open it within (a) access and (b) VB6

You could create a new field in your query that adds employee number and agency number together. I'm assuming that agencies have zero (or null) values for employees (and vice versa) The calculated field would look something like MySortedField : nz([employees number])+1000*nz([agency number])...

I think you need '#' around the date, not single quotes.

You could use the /cmd option to pass arguments to VB and extract using the Command() function.

I see. The following link will allow access to obtain the login name: http://www.mvps.org/access/api/api0008.htm I would then create a table similar to tblUserLog LogID (autonumber) UserID (FK to tblUsers) TransactionType (ie...

How are you going to identify each user then? Putting some form of login in a networked multi user database would be a good idea, not just so that you could identify them, but also adding soem levels of security.

Same thing happend to me. Turned out that the printer was in a Draft mode. check your printer settings. I think you can change the print quality in Macros, though.

volto.com has an ActiveX object that might suit your needs...?

ISTR that if there is a problem with the printer setup on a machine, access reports won't open. Might be worth checking if its a PC-dependant issue.

Fields D, F and G can probably be calaculated controls on the report, which should make access less likely to choke on the query. If that fails, you'll need to post the SQL so people can look at it.

If its a straight choice between Access Reports and Word mail merge, I'd go for Access reports every time. I've done alot of Word mailmerge from access and while it works 95% of the time, accounting for every eventuality of Word automation behaviour (and end user behaviour) is a pain. In your...

In report design mode, you can add columns (Page Setup) which should do what you want.

Hi Try stepping through the code one line at a time, using the F8 key. I've just tried it on my system (Acc2000) and it works fine. I don't have a machine with Acc97 on to hand, but I can try it at home this evening.