Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

access

ResolvedVersion 2003

Arabella has attended:
Access Introduction course
Access Intermediate course
Access Advanced course

Access

I am building a table but I'm not sure why the following is happening

The fields are

First Name
Sur Name
Day
Date
Project Name
Project Code
Hours

all but hours are look up tables

I put in say 100 enters

There are 9 entres which have Thursday 13th and 9 entres which have Friday 14th

I save, come out and go back into the table to find these entres have moved from their position and now sit in a group of entres for someone else or they are at the bottom of the table?

What can I do to prevent this?

Thanks

RE: Access

Hello Arabella,

I would like to just confim a couple of things before I look into this. Are you entering the data directly in to the table or via a form, and if by form does the form have the table as source directly or is it via a query on the table?

Regards,
Mark

Access tip:

Hiding Multiple Table columns

If you want to hide non-adjacent Access table columns. In Datasheet view, open the table that contains the columns you want to hide.

On the Format menu, click Unhide Columns.
In the Unhide Columns dialog box, clear the check box next to the name of each column you want to hide.
Click Close.

This method makes having to use the Hide Columns command repeatedly unnecessary

View all Access hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.12 secs.