Recent content by MaryC

The delay code works fine, but It didn't fix my problem Thanks - I will try another work around eeeek!:)

I want to set the code for an OnCurrent procedure to delay for 1 second, allowing controls to get data from subforms 1st then run the procedure to calculate on those controls. Access 2007 is too slow on getting the totals from the subforms with a lot of records:confused: .

I am using visual basic code to set values from 2 subforms w/totals to the main form using the oncurrent event. When the 1st subform has more than 7 records and a record is created in the 2nd subform, the totals go blank - any less than that number of records in the 1st subform it calculates...

Stand Alone machine Yes - I have machines in the field offices that I have updated and the cahnges were not seen until they did a restart or go through the process of renaming I described earlier. I actuall amde some changes in my motel room, put it on a floppy, transferred it on a field...

Access 2000 in Windows 20000 I am sorry - you did not explain that you tried it. The changes are any kind - from modifying a form as you did, to modifying a report. What is your operating system? The only common factor I have with the problem is that all the Office 2000 users are also on a...

When I edit a database it is not on anyone's computer but my own. The database is not available to other users when I edit them. I edit it on my computer then copy it back to it's location - the network or emailed to field offices. That way I don't have to worry about someone trying to access...

Databases are closed (2) It is not a user problem it is an Access problem - you should try it. Make a simple database and form in 97 close the database, then open it in 2000 don't convert - just open. Then close the database. Change the form in 97 then close the database and open it in 2000...

Databases are closed It is not a user problem it is an Access problem - you should try it. make a simple form in 97 open it in 2000 don't convert - just open. then close the database. change the form in 97 then close the database and open it in 2000. the form will not be changed in 2000, but...

No they are not converting they are opening No they are not converting - they are opening the databases. They are not able to edit objects but are able to use and edit data. We have over 500 machines. The cost would be prohibitive to the company to change all to Office 2000. All the databases...

Object changes yes, they are looking at the same database- it happens on every 97 database with 2000 users - sometimes a restart on the Access 2000 machine will help - sometimes no - the only fix so far is a rename and path change of the database to fake Access out into thinking it is a new...

When I make changes in an Access 97 database my 2000 users do not see the changes made.:confused:

ODBC A lot of times when you convert - the linked table(s) to ODBC must be relinked in order to work. If this is not done you get the ODBC error message.

Number Problems I have had the same problem with linking - check your data - in the cells and fix it or reenter the number. If that doesn't work - I have had trouble with not being able to set the table properties to anything but number even thought there is text in some of the rows -I went to...