Search results for query: *

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

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

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

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

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

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

THANK YOU!!!!

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 =...

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

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

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