Form

Resolved · High Priority · Version 2003

Form

James has attended:
Access Introduction course
Access Intermediate course

by - delegate James [2 posts] (2008 Aug 4 Mon, 16:40) Reply

At work i have a form that frequently throws up an "invalid command" error and that forms text will turn to japanese.

Version	Date	Location	Places available	Book	Next place rate:
Access Intermediate 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2003	2008 Dec 9 Tue	Bloomsbury	0	FULL
2002/XP	2008 Dec 11 Thu	Tooting	0	FULL
2003	2008 Dec 18 Thu	Bloomsbury	2	book now	£215	£215
2003	2008 Dec 23 Tue	Bayswater	8	book now	£182	£207
2002/XP	2008 Dec 24 Wed	Tooting	0	FULL
2003	2009 Jan 6 Tue	Southwark	5	book now	£198	£215
Full Schedule: See all 51 Access Intermediate course dates. Bookings currently available until 24th November 2009.

RE: Form

by - trainer Amanda diamond contributer [1252 posts] (2008 Aug 5 Tue, 14:46) Reply

Hello James

Thank you for your question and welcome to the forum.

Please note that we are not able to provide technical support or assistance in relation to files used in the workplace via the forum.

We can provide information or advice relating to topics covered in the training courses you have attended with us, therefore if you have any questions that relate directly to your training within the next 12 months we would be happy to help.

Amanda

· Do You Have Trouble Understanding Databases? Consider a One-on-One Access Course
· How Reorganising Your Data Can Take Your Business to the Next Level
· Quick Access Database Courses: A 10 Step Lesson in Encrypting and Decrypting an Access Database
· Microsoft Access Beginners' Training: Getting to Grips with Databases
· The Benefits of Certified Microsoft Training in Access

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

Access tip:

Random sampling

Data is th key to a good database, therefore checking is essential.

A good way of checking data is by random sampling. You can do this in a query, by typing the follow:
1) In the Field box create a RandonID field eg. Randon Id: Rnd(fieldname])

2) sort the field
3)Right click and chage the properties for To value to be the number of randon records you want to see.

4) Change the set to Show row for Randon ID to be False, add all the other fields you want to see and the run the query.

View all Access hints and tips

Rate this page: