How to get Position of a Form (Access 97)

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 forma.top + 

Any ideas would be appreciated.

3.Getting mouse position to move form

Hello,

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
simple!)?

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
already?

TIA,

Neil.

4.converting form '97 to 2000: getting error

Hello,
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?

Thanks,
Nico

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....