Access/excel

Resolved · Medium Priority · Version 2003

Fri 11 Jul 2008, 16:12 Delegate Hanan said...

Hanan has attended:
Access VBA course

Access/excel

how to export fields into excel and to update automatically

Fri 1 Aug 2008, 10:38 Trainer Stephen said...

RE: access/excel

Hi Hanan

To assist with your requirement will most likely involve some dedicated time with a relevant trainer having access to your spreadsheet.

Naturally this will be consultative work and therefore billable.
If you wish to discuss this in more detail please do let us know.

Regards

Stephen

Training courses

	98.7 % recommend us
	More live stats...

Training information:

Active questions
Advanced/consultancy questions
Today's questions
Unanswered questions
Popular forum topics

Access tip:

Choosing data types in Access

Not sure which data type to use for your Access fields? Here are some guidelines to help you choose a data type to assign to a field.

- The Text data type can accept up to 255 characters. For information that will be recorded in paragraphs, use Memo.

- Also use Text for numbers that aren't going to be used in calculations, e.g. phone numbers.

- Use the Currency data type for monetary amounts.

- Use Date/Time for dates.

- Most other numbers can use the Number data type, but the Field Size property may have to be altered.

- For fields that have only two alternatives (yes, no) use Yes/No data type. If there is likely to be a third entry option (e.g. maybe or don't know) use Text instead.

View all Access hints and tips