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!

Register Log in
  • Congratulations strongm 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. quackslikeaduck

    one field on form to update several

    Can I use one field on a form to update 5 different records with 1 single value? or can I create a query that does this and point the 1 field on form to the query? For instance: I want to see one field on the form called "Price". I want the value of whatever is entered into that field to...
  2. quackslikeaduck

    saving forms

    I'm just wondering if after my user fills out a form can it be saved as a file or report automatically in the background maybe on close or something? If possible I'd like each form to have a unique name like maybe PO number or something to distinguish one from another.
  3. quackslikeaduck

    saving forms

    Can anyone help me figure out why when I close my form and it save to the tables it always overwrites the last save which is the first in my table. I believe each should save in a new row. My tables are as such: TblPurchaseOrder (a table holding information on items being ordered)...
  4. quackslikeaduck

    calculate fields

    I have two fields from two different subforms. I would like to have a total (on the main form) of the two fields from the two different subforms. Is there a way that the total (that's located on the main form to update as information has been added to the text boxes in the two different...
  5. quackslikeaduck

    subform columns showing up from left to right when they should be going down

    I created a subform and put in my fields. Text Boxes on forms showing up next to one another (print preview) when I put them in columns one underneath the other?
  6. quackslikeaduck

    Help locked out of form

    I created a form and after adding fields from related tables I was locked out of my forms. I tried to delete the fields but it still renders me locked out. This happened in a form subform scenerion, form scenerio by adding testing then deleting the fields once locked out. My tables are as...
  7. quackslikeaduck

    best way to join - brain block

    I'm trying to make joins of the relationships in my database. However I can't seem to join anything and have it work out. Meaning that I don't see all of the data in the form. I don't mind creating a new form but I honestly don't see anything I can join on. I have 4 tables with several...
  8. quackslikeaduck

    need help normalizing data

    I have an old database that needs to be normalized. It's flat right now. I am hoping someone can help me to figure out how to organize the data. I have 5 fields within the current table QuantityOrdered1, QuantityOrdered2, etc... I know that at some point I will run into problems if I have to...

Part and Inventory Search

Back
Top