Recent content by AlexB1

  1. A

    struggling designing my layout.

    no done and dusted now lol, thanks anyway
  2. A

    textbox saving details from a different form

    would it work if i did a calculation in the default value...so that i could use the control source to save the value into a table ??
  3. A

    textbox saving details from a different form

    crackin :D thanks for the fast reply ;)
  4. A

    textbox saving details from a different form

    hoping someone can help me out with a little textbox problem, iv got 2 linked forms, first form is either collecting or displaying customer details depending on conditions. and then using a button to go to a second form to deal with orders. everything is working fine apart from the address...
  5. A

    update query to add total to orders table

    well once its stored in the table it should never need to be calculated again...very rarely will it need to be altered...but there will be a large number of them saved... i thought saving the calculated fields would be easier than having them calculated on multiple forms and reports...but then...
  6. A

    update query to add total to orders table

    would it work using an update query to put a calculated field from another query into a table ? for example: i have an active orders table which needs to include sub total and total. these 2 fields are calculated in another query...but considering this will be heavily used i dont know if it...
  7. A

    showing name instead of ID number

    ok ill do that, im new to access so just trying to experiment with features :P thanks for the help
  8. A

    showing name instead of ID number

    i dont understand why its worked with the customer id but is giving me errors with the quad id...nobody used this before ?
  9. A

    showing name instead of ID number

    sorry, the combo box im meaning is the lookup tab on query properties, display control is set to combo box row source type = table/query row source = customer EXTENDED (a query) i got the idea while looking at the northwind database....
  10. A

    showing name instead of ID number

    iv been using a combo box to show the name of a customer instead of there customer ID in a query...this one has worked fine... however the second time iv done it for there quad name its left the record black....iv checked over what iv done again and again and can find no difference....now im a...
  11. A

    struggling designing my layout.

    my first post so be gentle with me :) Edit: sorry if its a mess. right im trying to design a database for a small business selling quad parts (just doing the parts side for now) because of the nature of the business we dont store any products ourselves, we order from our suppliers by phone...
See more
Back
Top Bottom