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 biv343 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. alanna101207

    Setting the default value's on an unbound log in form (Savng user inf

    Just want to know if anybody knows a good thread, or idea that tackles this issue. I have a simple Log-in form...ie... UserID and ProgramID. It is 2 combo boxes that the first one you enter the user name, then the 2nd combo drops down and displays the active programs for that user. Once...
  2. alanna101207

    Command button on Main form that starts a new record on sub

    I have a main form with a sub form that is set to single form. I have a command button on the main form that I would like to use to start a new record on the sub. I don't want the command button on the subform for appearance reasons. I have tried the following: DoCmd.GoToRecord , "SubForm"...
  3. alanna101207

    Multi Criteria DLookUp As a Control Source

    Can somebody please tell me where I am going wrong here. I use the following as a Control Source for a text box on a form: =DLookUp("WeighIn","tbl_Week","ProgramID =" & [txt_ProgramID] & " AND WeekNumber =" & DMin("WeekNumber","tbl_Week","ProgramID =" &...
  4. alanna101207

    Getting a prompt using IIf statement

    I am not sure what I am doing wrong here. I have a query that is based on another query. I use this IIF statement: FlexUsed: IIf([SumOfPoints Sum]>[DailyPoints],[SumOfPoints Sum]-[DailyPoints],0) I get the results I am looking for, however, I get a pop-up prompt to enter a parameter value for...
  5. alanna101207

    Using INSERT INTO to enter a set list of records into a Join Table

    I don't know if this is the proper way to approach this, but with my limited knowledge of access, this is all I can think of. This is very detailed, so please bare with me. I have 2 tabels "tbl_Charges" and "tbl_Rates" with "ChargeID" and "RateID" being the primary keys. The "tbl_Charges" has a...

Part and Inventory Search

Back
Top