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 Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by alanna101207

  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

    That's it...thank you so much...
  3. alanna101207

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

    This form is 3 forms. The Main(1) form has a subform(2). That subForm has it's own subform(3) on it. The command button to start a new record for (3) is on (2). With the code I showed you I used above, when I click the command button, it starts a new record for (2) and (3). I only want to...
  4. alanna101207

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

    Well, I discovered a problem. Here is the code I used: Me.frm_Daily.SetFocus DoCmd.GoToRecord acActiveDataObject, , acNewRec It works as far as going to the subform and starting a new record, but the problem is that the main form is also going to a new record. Not sure if this makes a...
  5. alanna101207

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

    Thank you. Never thought of it like that...
  6. 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"...
  7. alanna101207

    Multi Criteria DLookUp As a Control Source

    That's it! I sware I tried that and got a syntex error, but I must have put them in the wrong place. Thank you very much.
  8. 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 =" &...
  9. alanna101207

    Getting a prompt using IIf statement

    Awe...I see...geez. "Expression" where I had "Group By" Much thanks.
  10. alanna101207

    Getting a prompt using IIf statement

    Okay, I tried that and am getting the following error: "Cannot have aggregate function in GROUP BY clause
  11. 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...
  12. alanna101207

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

    Thank you. I am going to give it a crack using SELECT since it is multiple records, but I may be back with some help with the quotations on this since I will be using this code from a text boxes after_update event on a form.
  13. 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...
See more

Part and Inventory Search

Back
Top