Search results

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

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.

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

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

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

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

i have been given the great task of redesigning an existing database that contains nearly 500 records in several tables. The database is in Access 2000 format. The problem is the designer did not normalise the tables before users began entering data. I need to keep all the information as well...

Hi All I have built a form based on two queries, the form does not contain a sub form. In table design I have assigned default values for my fields. Now when I create the form using auto form. Table 1 fields default values appear in the text boxes on the form when I begin to create a record...

Can technical person answer this question? In a one to one relationship is necessary for both tables to contain values, as the other day I had a strange error in access. Example Table A EmID Name Address 1001 J.Brown 123 Palm RD 1002 A.Kay 44 The Avenue 1003...

I have designed a contact database and would like some feed back before I dive in any further. The Plan: I have two main tables, Personnel and Contacts which is a subset of the the Personnel table. The personnel table contains the fields common to both Employees and their contacts. I have...

I have created a contacts database. Table Employees contains records about contacts and employees they are distinguish by a field called type which contains the choice Employee Or Contact. I have a one to one relation which is a subset table called Contact which contains information only common...

Could some one please help. I would like to change the record source of an unbound list box using code. Based on the radio button selected I would like the values in the list box to change. I have been struggling for just over a week and would appreciate anyhelp Lloyd :confused: Thanks for...