Quick Links ▼

Bookmark page

Printable version

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

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

	98.1 % recommend us
	More live stats...

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

Training information:

Access

Resolved · Medium Priority · Version 2002/XP

Reply Wed 22 Oct 2008, 11:12Delegate Amanda said...

Amanda has attended:
Excel Advanced course
Access Advanced course

Access

Hi,

When trying to set up a new database the forms do not hold information from tables although they are set up to do so and they were previously working - only current record being entered then it disappears, data is still in tables - have checked all properties and they are consistant with forms which work. Any ideas as to why the forms aren't holding the data?

many thanks,

Amanda

For upcoming training course dates see: Pricing & availability

Reply Wed 29 Oct 2008, 21:08Delegate Mark said...

RE: Access

Hi Amanda,

Can I first suggest you check the source is still correct in the form properties. Even if it is there, I would suggest to try to re-click it in from the drop down. More than once I have found re-selecting the exact same named source does help even though it doesn't appear it could. This can happen due for some unexplained reasons, possibly that whilst the name of the source is still remembered the computer or sever memory address information can get corrupted.

Good luck. If it doesn't work then we can investigate further.

Regards, Mark (Delegate)

Reply Fri 31 Oct 2008, 11:03Delegate Amanda said...

RE: Access

Thanks Mark, I'll give your suggestions a go!

Amanda

Access articles

· Reasons to Consider Microsoft Access Training
· How To Understand Access As A Relational Database
· How Do Cross Tabs And Pivot Tables Differ In Microsoft Access?
· Take an Access Course to Learn About Relational Databases
· Find Microsoft Access Templates For Any Task

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

Access tip:

Hide Access Tables

One method of stopping your Access tables appearing in Database window, is to rename the table(s) with the prefix usys.

This converts the table into a system object, which cannot be viewed in the Database window.

You can show system objects in the Database window by the following:

Step 1: On the Tools menu, click Options.
Step 2: Click the View tab.
Under Show, select the System Objects check box.
Click OK.

View all Access hints and tips