Recent content by mrharvey

Thanks, That is a good starting point. Michael

Hello All: Has anyone noticed ANY issues or problems associated with using OFFICE/ACCESS 2000 concurrently with Yahoo Messenger? We have one group (Accounting) that uses an Access2000 Db (58 meg; max of 6 users) that has serious daily corruption issues. I compact/repair this Db every...

Hey Spider: Access is just trying to tell you that the field [Stock Out] exists in more than one table in the SQL join. All you should need to do is to qualify it by referencing the appropriate table. For example: tblInventory.[Stock Out]. Michael

Hi Steve, If I correctly understand the problem, you should be able to use the "New" keyword to create a new instance of a form, then set the RecordSource property of that newly instantiated form object to the parsed SQL statement of your choosing. Good Luck! Regards, Michael

"Doc" is correct, the proper terminology is called "page-locking" and in Access 97, it is most definitely in 2k chunks. However, Access 2000 DOES PROVIDE TRUE ROW (record) LOCKING! The easy solution is to upgrade to Access 2000/Jet 4.0! Here is a intermin work-around: if possible, re-design the...

You're welcome, I'm glad I could help.

Hi Treason: After re-reading your requirements and further consideration, I realized that a cross-tab query will not be the solution you need. You need a little VBA-weenie-programming. Here is my layout and propsed solution: tbl - Emps: [Emp_ID], [Emp_Name], [Address] tbl - EmpJobs: [Emp_ID]...

Hi Treason, Have you consider creating a cross-tab query on table2, linking to table1 (via EmpID)? Michael

I have inherited maintenance and support duties for several large production Access 2000 databases. Most of the daily corruption issues have been solved by eliminating the cross-reference table links amongst each Db and placing the critical tables into separate back-end databases thus, lessening...