Search results

When I first attempted playing with this stuff I ended up locking myself out of access and had to load the software allover again. Now I realize if I make a copy of the system MDW file I can always get back to square one without having reload. I seem to have got to the place where I can set up...

I don't know it this will help but I couldn't get my macros and code to work in 2002 from 97 till I downloaded two critical updates from the microsoft website.

I have been fumbling with setting up user Security and have the following questions on multiuser security. When I set my self up as Admin and remove the default Admin login I still don't seem to have absoulute authority on existing databases. I think its because the owner is still Admin ,but as...

Thanks Jon I think this has me on the right track . I can select the last records with this method. I think these two querys will give me the results I need.

I read up a little on the top property . If I use the first field which is the unique hardware # Ie widjet#1 and the date field will it return the last instance of this particular piece of equipment having a record updated?

I think the top function in querys only returns the highest values? The situation I am trying to run a report for is the following. I am tracking the status of hardware. Each piece of hardware has a unique name which is in one of the fields. The status of the hardware or history goes into a...

How many recordsets can you have open at once? I wish to make a report by opening a a recordset and use a list to look to the last instance of an item in the recordset then move it to a temporary table or recordset where I can run a report on it. I think I can open a a snapshot recordset and...