Recent content by MelonFuel

Heres the full code im using Private Sub btnprint_Click() If Nz(Me.ODType, "") <> "" Then Docmd.RunMacro Me.ODType End Sub

Hi Pat This is the code i have now. If NZ(Me.ODTyper,"") <>"" then DoCmd.RunMacro Me.ODTyper But it gives me a parameter on every report if there a way to remove it. Thanks MelonFuel

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

Nothing is highlighted it says that there is something wrong with the .text part

Hi John Big Booty The code has an error saying invalid use of property? This is the code i have been given to work on by pere de chipstick. Dim intModelID as Long Dim intSerialNo as String intModelID = NZ(Me.ODtyper,0) if intModelID = 0 then MsgBox "You must enter a model type"...

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

hahah oh yeah :) thats what long days do to you :( will this is where im up to so far. I'm trying to write an Append query that looks at data on subform Partschedule and populates the table that's part of the RecordSource for subform FrmQueue then refresh FrmQueue so that it shows the data...

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

Just some quick questions:- - Will this code go on the subform in a textbox. - About the [Checkboxes] i don't understand is that a general name for all of them on the subform or ??? - Will this code add only the ones that are selected. - Will this code add the prices to the total. Thanks...

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

My Code now. On Main Form - =[qryTX4740 subform].[Form]![Dsum] On Subform - =DSum("TX4740Qty","qryTX4740","[TX4740Description]<>'Basic'") Basically the code partly works it removes Basic out of the quantity total which is what i want but when i enter the data further down it adds that up and...

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