Search results

I can add to this that the Excel file is properly created and opens correctly. I can right mouse click this filke, send to, mail recipient and it sends it (Outlook 2003), it's received and opens correctly. It does seem that it's CDO that doesn't like the Excel file unless there's something...

All I needed to do was declare strxlfile3 in a module and then just use it in my forms as if declared there. As others have said, variables can be declared as 'global' in modules but not in forms. Still no idea why the resultant file wont open after emailing ... it opens quite happily before...

Thanks both, absolutely right. The declaration 'Global strxlfile3 As String' in a module solves the problem and the email mail + attachment gets sent. I wonder if I might extend my question a little? The original attachment was in adobe acrobat .pdf format. This latest attachment is in Excel ...

Hi All, For some time I've been using Paul Sadowski's great CDO script to send mail from within Access 2003 and it has worked well including the use of a named file as an attachment. Into the future, I need to attach a file by reference rather than the exact file name ... but I can't get it to...

With jdraw's help, I can get the output fields that I need ... but need to understand more about sorting and grouping. In the attachment, I can now get fields such as Starts, start, entries and entry by using an alias (i.e. "" as Starts) but the output file needs to be sorted/grouped by those...

jdraw, that looks spot on. A test has generated the right info in the XML file. Thanks so much. Off now to load up and test the rest! Best regards, Brian

Not sure where this belongs, apologies if it's the wrong place! I've been asked to produce an XML output from an Access 2003 database for input into another application. The output file format is fixed and includes field names that must exist within the output file. I can provide the key data...

For Sean I've been all around this one. the IntStrRev function is available only it seems in VB 6. I can use string functions to cut bits out of the CurDir function and produce a new dbname .. the issue is that this approach can't be run when the db is already open - this is why I was so keen...

Thanks Sean I'll get right on that. The app is a club database. I look after it for errors and changes but the data is entered by the club secretary who in turn EMails regular copies back to me and to other club officers. They all tend to keep a few copies but what they choose to cal them and...

Thanks to jfgambit & yippie The issue for me is that copies of the database are held by various people. They get the database on EMail and generally rename it and store it locally - so when they get dbname.mdb in the post they may change it to (for example) dbname_july03.mdb. What I need then...

Hi Folks, I see that in Access 97 and following the opening of a database, it's possible to compact the opened database using menu options Tools/Database Utilities/Compact Database *without* needing to identify the database to be compacted and the new database name. Could someone advise how to...

Thanks ghudson for the response. I actually inherited this database via a number of "owners" back I believe to the original Access product. Assuming that I replace autonumber with a custom numbering system, can I seek some advice on code that would replace the autonumber system without losing...

Folks, For my sins, I maintain a club database running under Access 97. I have some problems with the autonumber used to create new records and link all existing records. Occasionally, a new record is not created but appended to an existing lower level record. I've resolved this in the past by...