Recent content by wabtrainer

Yes thanks for that. I eventually got to the botom of the problem. I have followed the work around suggested at: http://support.microsoft.com/kb/904953/ If you want to be a bear: Be a Grizzly!

Sorry for the delay, yes I can edit it directly in Excel. I struggle to understand why I cannot edit the linked spreadsheet when it is opened as a table? Is there a setting that I have made in error that disables this functionality? If you want to be a bear: Be a Grizzly!

Right I have put a new column in the spreadsheet and linked to it. But, I still cannot make any edits to the table when I open it. I am stumped! Forget any of the other tables or querys, I should at least be able to open a linked spreadsheet and make direct changes to the table when opened, but...

Ok I can give the supplier table a unique key, but how do you give a spreadsheet a unique key? how does access know to make it a key? If you want to be a bear: Be a Grizzly!

Even if I remove the unique key on the supplier table I am still unable to edit the linked spreadsheet. If you want to be a bear: Be a Grizzly!

Yes, The supplier table has a primary key, but the linked table does not. Does this have a bearing? What do I need to do? If you want to be a bear: Be a Grizzly!

Why is it that I cannot edit any of the fields in a table that is created by using the Linked tables.. and linking to a spreadsheet? The spreadsheet is on the same machine and is not opened. If you want to be a bear: Be a Grizzly!

I have a form I am trying to fade in and out. I saw some code somewhere on the net and copied the routine and all seemed to work. At least the form fades out as expected. But the fade does not work for fade in. Just a delay then the form appears. I think I need a fresh pair of eyes on it! Here...

Roy You sir, are a steely eyed missle-man! I should have picked up on the fact. Yes I had a query called test and it was that fact that was causing the problem. Of course CopyObject was wondering which object!!!! A fresh pair of eyes was all thats needed. Serves me right for naming everything...

I have done some testing and laughably the only time I get this error is if I name the table 'Test' or 'test'!!!!! Any other name given seems to work ok. Can any one shed some light on why this is occuring. What a pain. OK so I can now trap this with something like: If err.number = 2501 then...

Thanks for your ideas. I have warnings set to false and there is no table with that name. The code stops at the DoCmd.CopyObject method and reports "Run-time error '2501': The CopyObject action was canceled." Is there any thing else I am missing? If you want to be a bear: Be a Grizzly!

Is there any reason why I am getting this error now when it has worked before???? All I am doing is copying a table in the current database. For example I have Parts table which when altered the user clicks a button to save it with a different name. Heres the code: newname = InputBox("Enter a...

I have text boxes that contain long two or three lines of text. When I do a search for a string (Word or phrase) I only whant to display the first sentence that contains the string. Does anyone know the VBA statement that will meet this requirement? If you want to be a bear: Be a Grizzly!

Ken, Its a good point. As i said earlier, there is always more than one way to skin a cat in this game. As it is, I tried both methods and got them both to work! No real advantage really, I had just seen some application a whilw ago where all user settings were stored in the registry and it...

I am writing just a simple string to the registry using: SaveSetting "Data Tool", "Parts List Name", "Name", GetSelectedList() GetSelectedList() is a function I use to fetch the cuurent value which is a simple string such as "PartsA" Ok I go to the registry and its there. Result!!! But when I...