Search results

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

Do you know the sql format for updating a table? I know the syntax is different from a select statement but I am not sure how it works. Do you know what the code looks like for the acCmdSaveRecord ? It would be similar but updating.

I have a form that does a dlookup on a bunch of fields from a table. When I edit the information in the fields and save it, the form saves it as a new record. How can I make it so it only updates the field in the table instead of creating a new record? --Newbie

Great that is a big help thanks!! However, its not working with check box values. Still playing around with it but do I have to do something else to it to make it tick or untick a check box based upon the values in the table? they are yes/no check boxes in the table. Thanks again!

i have one table = tbl_All_SOW customer = text sow_num = num description = text price = text billed = yes/no signed = yes/no etc On my form I have two combo boxes. Customer and Sow_num. Once a user has selected a customer the sow combo box only displays the sows for that customer. This...

Not sure which place to post this question so I will do it in both forms and vba! I know pretty much nothing about vba except for playing around so I apologize ahead of time! I have a form based off of one table. I have two main fields in the table. Customer = txt SOW_Num = num On my...