Recent content by sunnywink

Hi Shelby, Thanks for your advice. Do you know which are the specific patches which will restore the numbering in print preview format? Does it come with installation disk for Access 2000? The rest of us do not see this problem when converting to 2000 from Access 2000.

Hi all, One of our colleagues recently upgraded from Access 97 version to Access 2000 version. The numbers in queries and reports in the database disappear when we are in print preview, and is also gone when queries are actually printed out. The numbers are present when we run the queries...

Hi all, One of our colleagues recently upgraded from Access 97 version to Access 2000 version. The numbers in queries and reports in the database disappear when we are in print preview, and is also gone when queries are actually printed out. The numbers are present when we run the queries...

Thanks for your advices. Hi Titan, The syptoms which you mention are exactly what we see too. Is there a way we can ascertain if the error is coming from network instability? We do not have administration rights to server allocation and it would be better if we are able to pinpoint to the...

Hi Is there a way to determine if it is an unstable network that is causing the corruption? Movements of the server is controlled by the administrator. We have no access or idea to the process of switching. Do you have ideas on any don'ts or do's in doing a switch of server to ensure the...

Hi all, Thanks for the advice. We did switch server recently, it is changed to another server with larger disk space by our administrator. Could it be the reason? Our file size is maintained at about 4MB and did not grow by large amount recently. We are using a number of Memo fields. In...

Thanks Megan for the advice, you have been very helpful.

Hi, We are currently using Access 2000 database with 5 users over network. It has been working fine for many years until recently where corruption occurs 2 or 3 times a day. The error messages ranges from "Database is in an unrecognized format. The database does not exist" to jet...

Dear all, I am tasked to convert Access 2000 database to SQL Server. ( Access 2000 database in front end application and SQL Server database in Back end application) SQL Server is new to me and would appreciate some advice. I have been reading up some information on the web and is confused...

Hi all, When Access reports is exported, the drawing objects eg. rectangles and lines disappear. Only the text is exported. Do anyone has idea how the drawing objects can be exported as they are in Access reports? Many Thanks in advance.

thanks for your help. I will try out your suggestion. The users will be new to Access and it's best not to alert them.

Hi Thanks for your reply. However is there a way to trigger the macro from the Access program itself? This is because the program will be sent to users aboard and we are unable to access to their task scheduler. Can the Access program recognise the computer system time? or do you know of...

Hi all, I am tasked to set up a Macro to send out reports at the end of the day. Does anyone has idea if the Access program (97 Version) can recognise the system time, and trigger the Macro to send automatically at a specified time? Any help will be appreciated. Thanks.

Hi all, I would like to instill user and group accounts such that only certain users can edit the table. Do I need to have to be an administrator to set up the accounts? I tried to do that but was prompt with a message that the object or database is read-only. We are sharing the database on...

Hi all, I am tasked to set up a database. We would like users to be able to edit in Forms view. However, is there a way where users would not be able to edit data in the Table view too? The users are new to the Access program and the data in the table form may be messed up accidentally...