Search results for query: *

Thanks Remou. That works fine without having to use the ALT key. How do I use AutoKeys and how would it work? Thanks

Hi...I have a database where various applications/documents can be opened by clicking on the command button. What I want to do is have the option to be able to open the application/document by pressing the ALT key + a letter. For example, I have a command button to open Excel application by...

Yes changes can be made to other databases. I've eventually managed to sort the table in this database as well. After a few goes at doing a compact and repair database I was abale to copy the linked table as local and rename this copied table. Don't know what went wrong but got there in the...

The reason I was trying to copy the linked table is because I want to make changes to the table and as changes can't be made to a linked table my plan was to copy the linked table and then delete the linked table afterwards. I tried compact and repair but still have problem. I keep getting...

I'll try that. But I even deleted the database that the table was linked from to try and copy it as a local table but still no joy.

I get 'inavlid argument' message everytime I try to do anything to any of the tables. Even the ones that are not linked.

No - perhaps I'm not explaining it properly. I want to make changes to the linked table such as make a mandotory field to a non mandatory field but as the table is linked it will not let me do that and save the changes to the table. What I want to do is somehow unlink this table and the only...

Hi I don't want to delete the table. I still need to use the table but becuase it is linked at the moment I can not make any changes to the table. I get message saying changes can't be made to a linked table. That is why I want to unlink it and use as a local table. Hence I tried copy and...

Hi...I have a table which is linked with a table to another database which is a different version. This is no longer required as all users are on the same version now. I tried to copy and paste the table selecting local data and structure but I keep getting an error 'Invalid argument'. I'm not...

Thanks Remou...that works well as well. I also tried this code to open microsoft outlook, it works but a message is displayed "are you sure you want to open......" before Outlook opens. What I'm trying to do is have a access form as a front end on my desktop so that I can open applciations and...

Thanks...works well...you're a star!

Hi... I'm trying to use a command button to open a excel file saved on a local directory. I can get it to open the Excel application with this code: Private Sub xlapp_Click() Dim stAppName As String stAppName = "C:\Program Files\Microsoft Office\OFFICE11\excel.exe" Call...