Search results

combo box Auto expanding thanks guys for your help and suggestions. for some reason i could not get the column suggest to work. I changed the code slightly anyway. But do you guys know how to stop a combo box expanding. i set autoexpand to false it still expands though.

hi all :confused: I would like to limit the text entered within a combo box to a value no more than 10 characters then automatically truncate the values if the number of characters is greater than 10. I have placed code on the not in list event of a combo box this is an extract If...

Hi I placed the following code in the not in list event i would like to stop a problem. Currently on my form the user enters text in the field then decides no then don't want to save this text and clicks on the cancel button on my form. The message would you like to add the text to the combo...

thanks thanks a lot Brian i will try it out.

grateful thanks for you're time and help.

I would like to force users to enter only numbers in an input box and display an error message if users enter characters is this possible using the input box, if not what is the best way to achieve this.

max date I have tried this in the qbe but i always get all the records when i select max on the date field. What am i doing wrong?

thanks Much appreciated. Do you know of an instance when the debug number would not be printed. I placed this code on a form using a undo event and the error message was shown on screen saying this "The command or action 'Undo' isn't available now." No error number was printed can you help.

I would like to output an error code to the immediate window, however the following code does not work what am I doing wrong. I placed the following code in the on error event but nothing is output to the immediate window. Debug.Print "DataErr = "; DataErr

Hi Guys and girls I have a form that I open up in datasheet view. This form is used in several areas in my database. I would like to open the form in datasheet view, and hide the column displaying the primary key which is column 1 using code. If possible i would like to automatically move...

I would really appreciate some clarification, I always seem to have problems identifying relationships between tables. I always hear the term direct and indirect relationships. How do you know when a relationship should be direct or when it should be indirect. Could someone please explain in...

thank Thanks guys for both your help on this subject. My head is no longer boiling.

For those that have helped me in the pass THANKS, this forum has taught be a lot. I have 3 tables, now one contains the software price. The software price will change from time to time. How i have the table structures currently means that the sites that have received this software have the...

table design thanks Pat for your suggestion and time thanks.

table question Pat thanks for your reply i only didn't understand the last sentence. I have two tables currently with no data customer and dealer. In the dealer tbl i have an autonumber as the primary key, and i am about to create an append query to update the dealer details in this table...

Ideas please. I need to convert an excel sheet so called database into an access database. I have succesfully imported the data into access into one table. What is the best way to split the data up into the correct tables. For example the current table also contains calculated fileds, blank...

thanks thanks guys for all your help appreciate the suggestions.

Table mod Some of the columns i will just delete. I will also be adding new fields, and moving some columns to completely new tables, because they are contained in the wrong table. What would you do? To fix a database that was really designed incorrectly.

I am reconstructing an existing database. There are some columns that I no longer need. Is it better to use a make table query to create a new table and then establish referential integrity? Or should i create the structure and establish referitial intergirty first then copy the existing...

thanks Len and Gambit thanks for you help. :cool: