Search results

Thanks for the reply, Pat. I tried what you suggested but in Access 97, it seems like the Linked Table manager can only refresh linked tables. I'm not sure if I overlooked something. Is this contrary to what you can do with your linked table manager...

Does anyone know if there is any way to modify the path to a linked table? Like, if i move the linked table to another directory(ie i moved the database), how can i update this in my database that uses this linked table? Is there a way w/o deleting the table and creating another linked...

I'm coding in Access 97 and having some difficulty deleting all records from a table without actually deleting the table itself. I'm using the code: db.tabledefs("name").delete . Is there another function that will delete all the records ? Someone showed me on a macro that there is a command...

Hey everyone, I'm coding VBA in Excel 97 and I"m trying to run a specific procedure in a module in Access 97. However, I can't seem to code this properly. I"m trying to use the DAO library and Access libraries but they don't seem to work. Does anyone have any suggestions?? Thanks in...

Hey access gurus, I'm working with access 97, and in my report I have to highlight the numbers in a particular field in my records in which there has been a drop of 50% from the previous record in that same field. Is there an easy way to do this thru the report or do I have to create...