Search results

Hi How can i get vba to do this. When i click a button on the main form the vba code will execute and get the value from the combobox ie TE4700 and locate the macro with the same name ie TE4700 with reports in then it will run the macro and print off the reports. Thanks MelonFuel

Hi Im in a spot of bother. What i need to be able to do is write vba to find the value inside the comboxbox and then either:- 1. Run a macro with the same value that is in the combobox Or 2. Run a set of reports and print them off but are linked to the combobox value. The combobox name is...

Hi Hoping someone can help me out What I’m trying to do is when the user enter a value into the W.O.N No: (red outline box E.G. 12345/67) ,then the user selects a type (Green outline box E.G. 4900) The vba code in the button needs to bring over the value in the text box W.O.N No: (red outline...

Hi I have created an Append Query. the table tblQueue is the field where it keeps the data. I have made a query from the tblQueue and that is now on the main form as a subform. The subform isn't linked to anything via master and child. There is a drop down list on a another subform that i...

Hi I need some more help about a new database. Ill do my best to explain it. The database keeps information about route cards. Is there a way to assign a button to a specific TQP Number or the type field E.G. TQP Number - TQP 4.44/44/44 Type - ZZ4444 Is there a way where if i click on...

Hi Just some quick questions how could i add an email function to the code on another button on the report. Private Sub CreatePDF_Click() Dim strFileName As String Dim strDocName As String strFileName = "G:\Word Documents\ORDERS\" & Me.OrderID & ".pdf" strDocName = Me.Name...

Hello Guys Im trying to get access add up the checkboxes that have been ticked but not add the checkbox i want it to add up what has been ticked not the number of checkboxes ticked. All the fields apart from the total are on a subform. There will be 4 fields involved. - Checkboxes - Quantity...

Hello Guys. Ill try and explain this the best i can. If you don't understand I'm sorry just ask for more details. Well. My situation is this. As of now i have a around 30 different reports each named liked this:- TQP9_1_8_CheckThat4700 How can i print off the selected reports. The report...

Hi guys hoping anyone can help me with any ideas they may have on helping me achieve the mammoth task. Have a button that can be pressed and all order in that table above will go to the table below. Another button that is on each line when the order has been sent down that can be pressed and...

Hi Guys I need some help :) I'm need some code either nested IF or IIF formula to add up the values if a check box has been ticked. I may have 1 item or 20 items and the formula needs to add them up aswell. I really don't know if this is possible but this is what my colleague wants. I'm sorry...

Hi Guys Need Some guidance here. I know this has been posted before but the ones ive tried haven't seemed to of worked for me. I tried using macros to save a .pdf and output to file but thats not what im after. Basically what I'm after is a button that you user can press on the report and it...