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 derfloh 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. ammujr

    Incrementing using a recordset.

    Hi guys, thanks for helping me. But I am little confused. I have a form the user uses to add a record. So when the form is loaded, I want the counter table present value in the field and to then to increment the counter. Then I want the user to fill out the form with the rest of the...
  2. ammujr

    Incrementing using a recordset.

    I have 2 tables one that is called Counter table: 1 row 1 column that has a numeric value in it. The second table is called and EC my purchase order number/information in it. Here is what I am trying to do (if it is possible) So the user will push the add record button and the purchase...
  3. ammujr

    Combining multiple records as single string

    Rod, I was wondering if i could see the code that you created for DISI question. Thank you Jill ammujr@yahoo.com
  4. ammujr

    Error can't save record

    Hi, I have two tables that are you linked by the Column "Sales Order No". One table is called "Sales Order Info" and the second is "Survey". Everytime a customer returns the survey attached with the sales order, I wanted to input the survey information. I linked...
  5. ammujr

    Update sub form!

    Hi, My question also has to deal with the subform. I have a form(sales order) which includes a subform called line item. On my form I have a command button that is "add new record". The PK is a field called SalesOrderNum and it is a fk in my subform table. so when i update I want to...
  6. ammujr

    Calculations within a report

    HI, I have a question along the same line. I have a table whicb updated by a form. I am trying to create a Quality Survey. So the survey has a rating system from 1-5(one the worst 5 the best) and 5 categories to rate. I was wondering if I did a query in access, could i get the average...
  7. ammujr

    I Need Help

    THANK YOU!!!!
  8. ammujr

    I Need Help

    Hi, Thank for the help. But when Remove the parameter query and insert what the new code in the expression build. I still get "mismatched in criteria expression" for an error. Private Sub Command55_Click() On Error GoTo Err_Command55_Click Dim strWHere As String strWHere =...
  9. ammujr

    generate report from form record

    HI, I Followed the thread you had written for aaronjonmartin, but when I press the button I get an Error. My field SO NO is a text variable Error: Data Type Miss matched in critertia expression. this is my code: Private Sub Command54_Click() On Error GoTo Err_Command54_Click Dim...
  10. ammujr

    Forcing a field in a report

    ammujr (MIS) Nov 18, 2003 Hi, I was wondering if I could force a field in a report. Let me explain, I have a report that is based off a query( Product survey letter). The query is set to ask me which sales order number, it then inserts the the relevant information into the letter for the...
  11. ammujr

    I Need Help

    Hi, I was wondering if I could force a field in a report. Let me explain, I have a report that is based off a query( Product survey letter). The query is set to ask me which sales order number, it then inserts the the relevant information into the letter for the customers (like there name...

Part and Inventory Search

Back
Top