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 Chris Miller 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. StormcrowRahl

    Record primary key into variable

    Well, I appreciate AceMan1's sage like response but I find it rather unhelpful. I am NOT a programmer, nor am I looking to become one. I am simply trying to complete a project and looking for some help in area's where the answer is eluding me. I appreciate the beginner's 101 on relational...
  2. StormcrowRahl

    Record primary key into variable

    I need to get the primary key for a record and place it into a variable to pass to a form. I am thinking that I should either create a module to do this when the form opens or just add the code into the Form.Open section of the form code. I just don't know how to not only find the record via...
  3. StormcrowRahl

    Records added from form into a recordset

    Okay, I get using the CurrentUser() function to pass that information into the report, but I can't seem to find anything on how to define or even use the SessionID. Any help would be great.
  4. StormcrowRahl

    Records added from form into a recordset

    I'm also wondering if this is possible if two users are entering data via the same form at the same time. Is it possible to create seperate recordsets for each user? So that when each user is done, and they print the report, it will show only the records that they added.
  5. StormcrowRahl

    Records added from form into a recordset

    Sorry for not being more clear. I'm wanting to trap all the records inputed via a form into a recordset. I want to do this because I want to generate a report with only the records the user entered during the current session. So when the user exits the form, the recordset is cleared. Is this...
  6. StormcrowRahl

    Records added from form into a recordset

    Is it possible to group all records entered into a recordset or would it be easier to just create a seperate table and do an update query afterward?
  7. StormcrowRahl

    IIF help

    I need help writing an IIF statement that will evaluate a calculated control(which calculates the sum of a column), to cause a page break when the sum is equal to 20.
  8. StormcrowRahl

    Control output to report based on subtotal

    I need to cause a page break when a group subtotal is equal to or not exceeding 20. Setup: a parameter query is run with user input, which is where the report gets its information. Now, I can subtotal the specific column(#ofdocuments) in the report without any problem. But I need the report to...
  9. StormcrowRahl

    Control Report Output based on subtotal

    I need to cause a page break when a group subtotal is equal to or not exceeding 20. Setup: a parameter query is run with user input, which is where the report gets its information. Now, I can subtotal the specific column(#ofdocuments) in the report without any problem. But I need the report to...

Part and Inventory Search

Back
Top