Search results

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

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

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

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

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

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

Sorry ahead of time if my terminology is not correct. I have one table: SOW's I have a bunch of columns in that table, two main columns: SOW_Num - long integer Customer - text There are several (even duplicate) SOW_NUM for one customer On my form I have a combo box for Customer I have a list...

I have one table. I have a combo box to select a company name. Once the company name is selected, I want a listbox to be updated with only the column information pertaining to that company. For example, I choose a company called ABC and the list box shows all the SOW's for ABC. Here is the...