Data Entry

M

Marsha

On an old Microsoft database, I could pull a bar from left
to right across. I could have first name & last name
locked in place and then have the rest of the data move.
Made it easier to enter data on a big database. Any ideas?
 
C

Cameo

You were working with Excel (or predecessor). This function is not available
in MS Access.

If your question is regarding an Excel database, the function still exists.
You can look up "Panes" from the Help menu and that should get you started.
What you want to do is "freeze" them. It's kind of hard to describe where
the Panes are located.

Cameo
 
A

Arvin Meyer

Marsha said:
On an old Microsoft database, I could pull a bar from left
to right across. I could have first name & last name
locked in place and then have the rest of the data move.
Made it easier to enter data on a big database. Any ideas?

You can still do this if you use your forms in datasheet view. Once your
form is opened in datasheet view, select the column you want to Freeze, then
go to the Format menu and select Freeze Columns.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access
 
M

Marsha

A MacIntosh Microsoft Works Database was I was using. I
just thought Microsoft would make something comparable for
the PC. Thanks
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top