Replies

in the forms properties set the cycle property to current record instead of all records

thanks your suggestion worked like a charm
thanks so much for your help

if you are storing the calculated value in a table
set the field properties to no duplicates
KTK

set your hard drives as not shared

it may be looking at the usb adapter as a com port. when you installed the adapter it should have given you the com port number (com1, com2)
so if you already have one serial port filled more than likely the new adapter serial port would be listed as com 2 but this is all quessing
but maybe worth a try
HTH

i have ME on my computer a p62 300 with 80 meg memory and 98 on my other computer a pentium 133 with 32 meg memory they are networked so i can run spider on the 98 machine
It runs twice as fast on the 98 as it does on the Me machine

try column 0 and column 1
instead of 1 and 2
HTH

you might could try this i’m using access 2000
but it might work in 97 i don’t really know but i thought it might help
Set objXLBook = objXLApp.Workbooks.Open(“k:crewharareoffice.xls”, vbMaximizedFocus)
HTH

have you tried setting the enter key behavior to new line in field instead of default
HTH

have you tried doing the calculation in the report instead of the query
hth

when you close the maintenance form you should know which form the database is going back to
i do in my databases also they had several comboboxes to refresh requering the entire form will refresh all at once not just one
please excuse the “whateverform” but i didn’t know the name of the form and simply used this as a filler for the code
sorry

try placing in the on open of the “fLaborCost” form
not the hello form
HTH

in one of my databases i have a separate form to key in the numbers then a second form shows the data i use this code to stop the blank screen you talked about

Private Sub Form_Open(Cancel As Integer)
Dim rst As DAO.Recordset
On Error GoTo err
Set rst = Me.RecordsetClone
With rst
rst.FindFirst “FORMS![OPENING FORM]![TEXTbox]'” = Me![data form textbox] & “‘”

If .NoMatch Then

DoCmd.Close acForm, “OPENING FORM”
GoTo something
Else

End If
End With
Set rst = Nothing
DoCmd.Close acForm, “OPENING FORM”

err:
DoCmd.Close acForm, “data form”
MsgBox “There is no such record”
something:
DoCmd.Close acForm, “OPENING FORM”
End Sub
HTH

Have you tried the sr1 patch for access 2000
it cured the same problem for me
HTH
JerryC

you could try putting this on the on close event of the “Applications Maintenance” form
forms![whatever form your going to].requery
that should do it for you
HTH
JerryC