How to get Position of a Form (Access 97)

MS Office Access


  • 1. check for records satisfying a criteria
    this should be simple (but, obviously, not yet in my vocabulary of code) I simply want to check if a table [Table1] with fields [Field1,2,3...] contains a record where [Field1] = Var1, AND [Field2] = Var2... A simple Y/N responce is all that is required. thanks in advance, mark
  • 2. Referencing a subform control on a tab control
    In Access 2003, I have a linked bound subform on a Tab. I want to set some control properties in that subform if the user clicks the tab for that form. So far, every bit of attempted syntax hasn't worked. Can someone PLEASE tell me how to do that? (Specifically, I want to set the Enabled property of certain controls on the subform.) Thanks!
  • 3. How tell if multi-select listbox row is selected?
    In a multi-select listbox, how can I detect if the user is clicking on an already selected row? I need to take some action if the row is being selected but not if it is being unselected. Thanks.
  • 4. Updating Fields
    I have the following code: Private Sub Envelopes_AfterUpdate() If Envelopes = "Yes" And ShipTo = "Family" Then EnvelopeStreet = ShipToStreet EnvelopeCityStateZip = ShipToCityStateZip Else EnvelopeStreet = "" EnvelopeCityStateZip = "" End If End Sub This is supposed to automatically update the EnvelopeStreet with the ShipToStreet and update the EnvelopeCityStateZip with the ShipToCityStateZip if the field Envelopes is "Yes" and the ShipTo field is "Family". However, this does nothing. What do I have wrong? Thanks so much!

How to get Position of a Form (Access 97)

Postby Niels » Thu, 07 Aug 2003 20:18:32 GMT

Hi forum,
I like to restore the screen if the user restart the 
application. To save the position of a form I am looking 
for a way to get is't position (Top ?, Left ?).

I found code for Access 2000, using the variable .top ...
but how can i get this Information with *ACCESS 97*

Thanks for your help.

Similar Threads:

1.Getting Access 2000 data through Access 97

2.Form position based on another forms position

I would like to have one form(frmb) open up in a certain position based on the position of another open form(frmA).  I have seen this before but never need it until now

For exampl
    frmb.move + 

Any ideas would be appreciated.

3.Getting mouse position to move form


I have a month view control on a form with no border etc. All that is
displayed on the screen is the control. I use this as the generic date
picker for all my date textbox fields. When the user double clicks on a date
textbox, I want this form to open and the top left corner to be where the
mouse pointer is. This leaves me with two questions (the second only being
relevent if the answer is no to the first):

1) Is there an API call that can return the location of the mouse on the
screen (in VB i beleive it is as simple as Screen.x & Screen.y - VBA not so

2) I can use the mouse down event of the text box's to record the mouse
position when a text box is clicked and then move the Month View form to
that position. However, if i use the following for example:

    Forms!frmMonthView.Move frm.WindowLeft + CurX, frm.WindowTop + CurY

frm is the form where the textbox that has been clicked is and CurX and CurY
are the XY values passed into the mose down event. There is a slight snag
here... the X and Y single values are in pixels and the Move function treats
the values as twips. Is there a function that will convert pixels to twips



4.converting form '97 to 2000: getting error

I have a database in '97 format.
I want to upgrade it safely into 2000 format.

I used the command:
tools>database utilities>convert database 
... but something went wrong.

For I have understood, the problem is that tables have many fields (let say 
each table has an average of 150/180 fields) 
and for each field there is a quite long description to give advice to users.

Tables with few fields don't cause any problem. The ones with more than 
100/120 fields make the process crashing.

Now... I Know ADO i'm unconfortable with DAO.
There is anyway to delete fields' description from all table using code?
What I have in mind is creting a blank database in 2000 which has a command 
button that will launch a procedures against 
my '97 database.

Before wasting time... there's a better solution?


5.'97 Database converted to '00 gets Access.Lockfile.9 issues

Converted 5 databases from '97 to '00, without any 
apparent issues.  Multiple users work in the file residing 
on our network at the same time.  

We are now experiencing Access.LockFile.9 issues.  When 
the file locks we receive messages stating the database 
needs to be repaired - but we can't open it to repair it.

We found a repair tool online, and it works temporarily - 
but we need to know what's causing the issue and how to 
fix this.

Any suggestions?

6. Conv Access 97->2000-Gets a method or data member not found error

7. Getting Access filename only in 97

8. Access 97 error with XP, getting upset....

Return to MS Office Access


Who is online

Users browsing this forum: No registered users and 36 guest