Search results

  1. L

    truncate combo box text

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

    truncate combo box text

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

    Not in list for combo box

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

    validating input box values

    thanks thanks a lot Brian i will try it out.
  5. L

    Table structure help

    grateful thanks for you're time and help.
  6. L

    validating input box values

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

    Table structure help

    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?
  8. L

    Displaying Error Codes in the immediate window

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

    Displaying Error Codes in the immediate window

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

    Chaging datasheet layout

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

    Table relationships

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

    Table structure help

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

    Table structure help

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

    from Excel to Access

    table design thanks Pat for your suggestion and time thanks.
  15. L

    from Excel to Access

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

    from Excel to Access

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

    Make table or update query

    thanks thanks guys for all your help appreciate the suggestions.
  18. L

    Make table or update query

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

    Make table or update query

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

    Existing Database Redesign

    thanks Len and Gambit thanks for you help. :cool:
Back
Top Bottom