Screen Coordinates

[johndrew]

I am a newbee to Access. I used to use Aston Tates Dbase III Plus and would put the field at given screen coordinates. Can I do that in Access?

For example I just want to see something like Date, Emp, Hours at give screen coordinates and that's all I want the girls to see. They key and it goes into the data base

Thanks for your support

 

[boblarson]

It doesn't quite work that way in Access.

When you open Access there is an Application Window which then allows you to open forms at whatever size you have saved them at or you can use code to maximize, minimize or resize them. You use TWIPS (1440 Twips equals an inch) for the coordinates and the coordinates start at the top left of the area in the Access Application window and then move to the right and down. So the top left is 0,0 and if you moved down 1 inch it would be 1440,0 and two inches to the right would be 1440, 2880.

but you have to use the MoveSize method which you would place each of those TWIP values in the appropriate position for LEFT and TOP.

Hope that helps.

 

[Big Pat]

1. Create a form based on your table.
2. Select just the fields you want "the girls" to see. I would recommend adding other "important" fields too especially the primary key. You can keep it on there, but make it invisible in form view (so you'll only see it in design view)
3. When the fields are on your form, just drag/resize them to where you want them. Access is a good WYSIWYG application in that sense.
4. Save the form.

Now whenever anyone opens the form the fields are positioned as you saved them.. You don't need to re-specify screen coordinates each time.

 

[DCrake]

By heck you are bringing back memories dBase III+ You could get that on a single 3 1/2 inch floppy and still have room for the program.

@ 3,3 SAY "Name:"
@ 3,10 Get Name

Yes you did have to insert the coordinates but in those days it was a DOS screen, not windows.

A little amusing history lesson:
Ashton Tate (now Borland) never really existed (there was no Mr Tate) Bill Ashton thought that the name sounded better. Also its Predecessor dBase II was not an upgrade of dBase I as dBase I never actually existed. He wanted to give the impression that this software was a re release of an earlier version.