Quick Links ▼

Bookmark page

Printable version

Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Access VBA Training and help » MS Access VBA

	98.1 % recommend us
	More live stats...

The UK's most regular
instructor-led training courses.

Training information:

Active questions
Advanced/consultancy questions
Today's questions
Unanswered questions

MS Access VBA

Resolved · Low Priority · Version 2003

Reply Wed 19 Aug 2009, 15:44Delegate Jonathan said...

Jonathan has attended:
Access VBA course

MS Access VBA

How do I export the results of a queury into a specific cell, in a specific worksheet, in a specific excel file. For example:- Cell a6, Worksheet Jonathan, c:documents and settings/jonathan/template file.xls.

Cheers

For upcoming training course dates see: Pricing & availability

Reply Thu 27 Aug 2009, 16:59Trainer Andrew said...

RE: MS Access VBA

Hi Jonathan

Thank you for your question - Stephen will be back from training tomorrow and will get back to you then.

Kind regards,
Andrew

Reply Tue 24 Nov 2009, 14:57Trainer Stephen said...

RE: MS Access VBA

Hi Jonathon

Thank you for your question

First I must apologise for the massive delay in responding to your question. This em my urgent attention was due to an oversight on my part

I am aware that you may already have solved this issue. If you have not please don't hesitate to reply and I will give your problem my urgent attention

Regards

Stephen

Access articles

· Happy Table Relationships In Access 2007
· An Introduction To Queries In Access
· Express Yourself With Microsoft Access
· Learn About Action Queries In Access
· How To Understand Access As A Relational Database

Please browse our web site to find out more about
microsoft access advanced training and other Microsoft training courses.

Access tip:

Prefixed Autonumbering

When using Date Type = Autonumber as a primary key, clients may require autonumbering to be prefixed with a letter.

For example, P001, where P is the prefixed letter

Instructions
Step 1. Create Field Name
Step 2. Set Data Type to Autonumber
Step 3. Within Field Property General tabsheet,
enter Format property as [backslash]P000

View all Access hints and tips