Search results for query: *

G'day again we solved it! For some (unknown reason to us) "Microsoft DAO 3.6 object library" was not loaded. We found this omission in the "tools" "references" dropdown when in the microsoft visual basic window. however, there was also a further problem. If...

G'day The code below causes a compile problem on two out of 5 pc's we have running access2000. Private Sub opencusfile() Dim objdb As Database Dim objrs As Recordset Set objdb = CurrentDb() Set objrs = objdb.OpenRecordset("select * from customers", dbOpenDynaset) Do While Not...

When a pivot table form is created from an access table the name "Pivot Table1" is allocated to the table name regardless of what table the data originates from. Can anyone tell me how to find the 'real' name of the table?

I have a database that is obviously too big, as I could not remember the name of the table I used to populate a pivot table form. Whe I looked at the form, all I could find was the name "Pivot Table1" in Pivot Table Options located by right mouse button clicking in the body of the...

A number of us have Access97 installed running Windows NT. We link tables using Oracle 7.3 ver 2.5. As far as we can tell we all have identical setups with identical aliases to the databases we are linking to etc. When we initially link the table we always tick the 'remember password' box...

A number of us have Access97 installed running Windows NT. We link tables using Oracle 7.3 ver 2.5. As far as we can tell we all have identical setups with identical aliases to the databases we are linking to etc. When we initially link the table we always tick the 'remember password' box...