Search results

  1. Brutal

    same data in 2 tables

    Hi This will be an easy one. I have 2 tables one called production and another called associated When I created this database 2 years ago I managed to reference a column from production to Associated i.e a field called kit number that was in production also showed the same data in associated. I...
  2. Brutal

    Listbox and subforms

    I am sure that this question has been answered a thousand times but after 4 hours of searching the forum I couldn't find/understand the answer to my question. I have a form with a combo box, when you select an item (company departments) in the combo box it propigates a list box (department...
  3. Brutal

    File Names

    I have part numbers in my database and if there are photographs in the image directory with the same number then a photograph is displayed ie P/N abc123 = abc123.jpg. This I have set up and works great - HOWEVER - if the part number in the database is abc/123 the filename cannot contain "/" so...
  4. Brutal

    Main Window

    Howdy I am so close to finishing my project and am just making good those little anoying bits. What I would like is when a user double click the database Icon it opens my splashscreen ONLY not the surrounding Access program window, You know the one with file, edit toolbar etc. can I do this...
  5. Brutal

    Lookup List

    Hello I have a table with part numbers in it, I would like to have a field in a form that a user can type in, as he does so matching partnumbers will appear in a list in another field. Eg user types abc list shows abcdef, abcdfg, abcd12 etc. the list is to be non editable but if the user...
  6. Brutal

    Auto Update

    Hello There is a field in my table called "complete" and is a controled by a yes no radio buttons i.e when a user click a radio button the field gets a 1 or 2 put into it. What I would like to do is when that field is changed is to have a date field to automatically get todays date entered in to...
  7. Brutal

    Suffix to data

    Hello I have an address database and each record starts with a customer code, the problem is that more than one address can exist for only one code. I need to add some data to the end of each customer code to identify the address ie aaa001, john doe, 1 street. aaa001, john doe, 99 road. to...
  8. Brutal

    Association in Tables

    Hello I have an existing database that controls some production work and each job has a unique job number, but sometimes before somebody can start work on a particular job listed in the database a previous job has to be completed first. I would like to associate ie job no. 5 as a sub job of job...
Back
Top Bottom