Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. boredpilot

    Unbound Form Picture (is that possible)

    Hi, is it possible to have an unbound picture for the Forms background. Oh and im using an embedded picture since the chap im emailing this too wont know how to link the picture. I cannot find an option to make a forms picture unbound so that it would be on all the forms. Many thanks in...
  2. boredpilot

    Part Date mm/yy problem

    Thanks for the reply but I dont understand what you are suggesting (Im a little dim) All I need is for the date field in the form to just except mm/yy from the user. Is this something which is easy to do. What I did have set up but is causing me problems for one query was a list box with the...
  3. boredpilot

    Part Date mm/yy problem

    Hello everyone I need to be able to force a form that I have to just ask for mm/yy for the date information. Any ideas how I set that up. I cannot have it as 2 text list boxes as I need to run a query to find all advertisments that clients have placed from this month through to eg 2010. Then...
  4. boredpilot

    Access relationship issue

    I did originaly think about having a auto number but then I realised since each machine has its own unique code that would surfice. Having it this way so a tech can only put in the machine code once stops any potential errors of the same machine code appearing, (This is mostly licence and...
  5. boredpilot

    Access relationship issue

    PHV, Big thankyou ive twigged that in the second table it doesnt want to be set to no duplicates. Thankyou for steering me the right way
  6. boredpilot

    Access relationship issue

    Thanks for the reply, INDEX if thats the index you find in the design view of tables then both the machines table and the service table have both Company Number as INDEXED Yes (No duplicates)
  7. boredpilot

    Access relationship issue

    Just realised the picture is very small would have edited first post but cannot find edit button this should be bigger As the detail isnt fab the machine name in table 2 is the last entry, exactly the same as in table one bar its not the primary key Thanks again Neil
  8. boredpilot

    Access relationship issue

    OK been pulling my hair out for 3 hours so now time to ask for help. Im setting up a simple database for a company with many machines, each machine has a uniqe number so is the primary key. Im trying to create a second table so I can keep a record of machine repairs, etc since there can be...

Part and Inventory Search

Back
Top