Search results for query: *

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...

Thanks for that guys! I am just experimenting with: SaveSettings and GetSettings. I will let you know the results when finished If you want to be a bear: Be a Grizzly!

HI there. I would like to store the name of a table that was last accessed by the user, so that when he restarts access, it can be displayed. I know I have seen this done somewhere before, and I believe it was used by storing it in the Windows registry. I am sure there is more than one way to...

I have a range of data on one sheet ("Data_Table_With_Heads") which gets copied to a second sheet at Z1. I then want to take this copied range, name it "Filtered_Data" and display it in a listbox, but it is only displaying the first column. What am I doing wrong here? This is the code thats...

Cracked it! A bit lengthy way to get round it in the end but it seems to work ok. It allows the user to enter a string which could occur any where in either column C or column D. A multiselect listbox displays the values for each cell containing the string. The user selects those he wants to...

OK, but how do I apply an auto filter to only those items selected in a listbox? If you want to be a bear: Be a Grizzly!