Search results for query: *

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

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!

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

I have a userform that has a textbox to enter a search string into and two buttons. The string is searching from a range of two columns and the first button displays the entire contents of the cells that contain the entered string. I now want to have the entire sheet shown but filtered for the...

I have a tool in Access which allows me to search a table for a string and display the results in a listbox. I would like to do something similar in Excel, but have little knowledge of spreadsheets. In Access: I use a txtbox and the user enters the text. As each character is added, the listbox...

I have created a custom menu bar. It has a custom help button. and each form has a reference to the cutom .hlp file I created. I have a function which uses the sendkeys to F1 and I have that function selected in the OnAction property in the Custom help button. Every time I try to access my...

I know there is probably an easy answer to this but I am struggling (cant see the wood for the trees!) U have a form open that populates the listbox from a stored query. When I select a row in the listbox I want it to open a new form opened at that selected record. At the moment it jus opens...

Is it possible to convert a number of complex spreadsheets (each with a number of worksheets) with lookups btween these spreadsheets into a better organised Access database without loosing the formulas and lookups? I know its a bit vague, I,m just trying to scope how hard it will be to try and...

I have a database with loads of forms and i have a custom menu with print functions. I want to disable the buttons unless a report is open. At the moment I would have to put: CommandBars("CAT").Controls("File").Controls("&Print...").Enabled = False...

How can I utilise th F1 key from a custom menu? I have tried to use SendKeys but get an error. I am using Access 2000. Cheers If you want to be a bear: Be a Grizzly!

I have an AutoKeys macro that is envoked whaen a user selects a custom help menu, by using SendKeys {F1}. When I convert this 97 databse to 2000 and select the help file, the status bar shows "Setting up wizards...." and nothing happens. When I exit the database I have to use the Task Manafer...

I have created a custom menu bar and asigned a custom button on it that when clicked runs the autokeys macro {F1} which runs a hlp file. This work fine on the first form, but when I move on to another form this same button on the same menu bar displays the default 'Access' hlp file. How can I...

I have a database that starts off maximised on start up with all forms maximising when opening. The problem lies when I carry out an action such as applying a filter. After applying the filter, the form appears maximised but not glued to the database as it was before the action. is there a way...

I have a table with the Primary Key set as an Auto Number. However, as I enter a new tuple, it is using a number already used as a PK in the same table with the effect that I cannot add to my table. The PK is set to index (No Duplicates) oviously as it is the PK, so why is autonumber producing...

I have been using a database to add and update contact details for some time. Today I cannot add new contact details as it gives a warning "The changes you requested to the table were not successful because you would create duplicate values in the index, primary key, or relationship. The...

I dragged the horizontal guide from a slide and cannot seem to get it back! Any ideas????? If you want to be a bear: Be a Grizzly!

I have a main form that I use with two different selectors, one opens the form in read only mode, the other in add mode. The form includes a sub form that I would like to hide when the form is in add mode. The buttons are on the switch board and I would use the Visible = False, but I can not see...