Recent content by dhunter

I really appreciate the help. I tried and same as before, pop box asking for parmeter value. If I type in the customer in the parameter value pop up it brings up the report correctly, I don't understand why I keep getting the pop up box.

Customer is the field i want the report to be sorted by, the second customer = custchoice is the actual customer i want to it filter. i tried... DoCmd.OpenReport "rpt_Customer", acViewReport, "Customer = " & CustChoice, acNormal but then the report was blank, however i didn't get a pop-up...

Now instead of displaying "CustChoice enter a value" parmeter value box says "Adims enter a vale" (adims is the name of the customer so that's correct) but it still shouldn't be asking for a parmeter value. << scratches head

From a form I am allowing a user to choose a customer in a combo box. Users press button Make Report and it should open the report with correct customer. However when you press the button it asks for CustChoice parameter value (even though when code is stopped and you hover over CustChoice it's...

I have a text box on a subform where a user can enter a hyperlink to another application (called sales logix that is what the slx stands for below.) However when I click on the link it doesn't do anything. In the properties tab the "Is Hyperlink" is set to yes. Here is two different formats for...

Ok the error was because the sow_num box was empty but when this code runs it deletes 0 records from the table. it should delete at least one!??

Error: Run-time 3075 Syntax error (missing operator) in query expression 'SOW_Num = AND ALL_CUST_ID = 133' DoCmd.RunSQL "DELETE * FROM tbl_ALL_SOW WHERE SOW_Num = " & Me!sbfrm_New_SOW.Form!SOW_Num & "" & _ "AND tbl_ALL_SOW.ALL_CUST_ID= " & Me.ALL_CUST_ID & ";" ALL_CUST_ID is on...

Yes! You're a genius!! I for some reason had an invisible txt field bound to the customer table and I had some code that made whatever the user choose input into that txt field. After I got rid of that all my problems were solved!!! Thanks!!!!!!!!

I figured out why it was overwriting the first customer. I have the "Data Entry?" on the main form set to No, so that customers do not get duplicated. I could run a delete query to delete the duplicated customer but the new customer gets written to the table automatially so I would have to run a...

I even tried naming the specific fields and not deleting the Cust_Id and it still does it?!?

Thanks for looking at it. Still not working. The first customer in the tbl_customers is being replaced with the name of the deleted customer. I need to find out why this is happening. I used this: DoCmd.RunSQL "DELETE * FROM tbl_ALL_SOW WHERE SOW_Num = " & Me!sbfrm_New_SOW.Form!SOW_Num & " ;"...

I have a frm_New_SOW (Mainform) with a sbfrm_New_SOW. User selects a customer(from customer table) on the main form and fills out information on the subform for that customer (this gets put into tbl_ALL_SOW.) Forms are linked by a customer id. Customers can have multiple SOW's. I would like to...

Thanks for your help!

If a user chooses no on a msg box prompt I want the focus to go back to the control that the user was updating. I don't get any errors but the focus doesn't get set back to the control. Both controls are on a subform and i have tried the DoCmd.GotoControl to setfocus on the subform before...

I have a form that updates records in a table. I use an sql query to open a Recordset and I use Recordset.Update to update the fields in the table (when user presses the save btn). I use a generic btn to close the form. When I use this btn it automatically saves a duplicate entry into the...