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 Mike Lewis 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. GICodeWarrior

    Searching A table from a Form

    Well you sorta lost me but I think I had a remotly similar problem. Make a query in design view that includes the table you are searching in and put the "variable name" for the field you are trying to match up in the criteria box of the field you are matching it up to. Then make a...
  2. GICodeWarrior

    I have an unbound text box and none of the event functions are working

    I read up and I do not think that the value in the unbound box with the "=Sum([Amount])" control source changing triggers the after update event. Is there any other way to run a macro when that field changes? I tried putting the macro in the after update of the Amount field but the...
  3. GICodeWarrior

    I have an unbound text box and none of the event functions are working

    The box has "=Sum([Amount])" in the control source box. This way it adds up the Ammounts. The problem is that I want to run a macro when this field updates. I have tried everything but the field won't do anything when particular events are triggered. Please help, Code Warrior...
  4. GICodeWarrior

    My form won't show old records that are in the table

    I made sure that the fields are linked correctly, and it is not that it opens to a new record which is what I want it to do but the other records are not accessable(ex. there are 5 records and it says that there is only one at the bottom) Code Warrior Burchfield I write code. See code run. Run...
  5. GICodeWarrior

    My form won't show old records that are in the table

    I have a pretty complex order form. It has basic order info on top with two tab controls on the bottom. One has each the customer and products form. The other has the Products ordered and Payments each on a tab too. I thought that it might be because there is no relationship between the Products...
  6. GICodeWarrior

    How can I loop through records and get the sum of one field?

    I wish to add up all of the Totals in one of my tables. I know literally nothing about VB. Please help, Code Warrior Burchfield I write code. See code run. Run code run.
  7. GICodeWarrior

    How do I limit the values in a combo box using the value from another?

    Thank you so much!!! That was exactly what I needed and it worked perfectly. I never would have been able to figure that out on my own. Thanks again, Code Warrior Burchfield I write code. See code run. Run code run.
  8. GICodeWarrior

    Comment Form

    I am not sure if it workes with linked subforms but if you right click on the ID field on your comment form and select properties, then change the Default value under the field tab by clicking in the Default field box and clicking the"..." then double click the forms folder in the...
  9. GICodeWarrior

    How do I limit the values in a combo box using the value from another

    I can get the values to be limited but they are statically limited(Are limited the same way all the time and do not change when I switch between records or change the value of the combo box that is doing the limiting) I use the query builder in the properties dialog in the Row Source box to get...
  10. GICodeWarrior

    Setting a Password to **** when typing it into Input Box

    If you have a set length for the password you can use the input mask
  11. GICodeWarrior

    How do I limit the values in a combo box using the value from another?

    I can get the values to be limited but they are statically limited(Are limited the same way all the time and do not change when I switch between records or change the value of the combo box that is doing the limiting) I use the query builder in the properties dialog in the Row Source box to get...

Part and Inventory Search

Back
Top