Search results

Hi Db attached. If you open Rpt68AQuote you'll see a column headed TARGET (a control is in red) it is all the unbound controls in this column that I have issues with. I've run a compact and repair and compiled with no issues. Thanks

I've been through every control and every report section and there is no code that sets the values of these controls. I don't understand it :confused:. The controls are showing as unbound. I've opened the report directly without calling it from a form so that rules out code on a form setting the...

Hi Thanks for the reply. I'm not going mad after all. That's what I thought but by report shows values for the unbound fields which have no control source or iif statement against them. I'm even more confused now. Where else could they be picking up the values from? It's not on my query. Thanks

Hi All I have a report with a number of unbound controls which show a default value. The report loads fine and displays the correct values as it should. However I need to change the values on some of the controls but for the life of me can't find / remember where I set the the default values...

Thanks for the feedback. A few things to remember if anyone wants to do this. 1. You need to turn on the references to MS Outlook Object Library from within a module. 2. Win2PDF is a chargeable PDF writer. Costs £21 per person for a single user but I think it's worth it.

Hi Thanks all. I managed to piece it all together. The code below need cleaned up but it work if anyone needs it in future. Private Sub cmdcomplete_Click() On Error GoTo Err_cmdcomplete_Click Dim stDocName As String Dim stQuoteID As String Dim stFileName As String Dim...

Hi I'm not the best on VBA. I assume the object name required in the Docmd.OutputTo can be a variable that picks up the QuoteID number from the form. However I'm not sure how to write the code that outputs the report to Win2Pdf. Can you help? Many thanks

Hi I'm using 2003 Ta

Hi All I've just installed Win2Pdf which is excellent for creating and e-mailing PDFs. However what I want to do now is automatically save the PDF with the name of the on screen QuoteId and attach to an email. Currently Win2Pdf requires the user to save the PDF and I want to avoid this. Any...

Nope. I'm taking the easy option, leave what's working alone. But will remember for future. Cheers

Just seen vbaInet's answer. This is definately a better way.

Hi I had a similiar problem a few weeks ago and couldn't find an answer for this either. This is not elegant but my work around was to create a duplicate query with the criteria field left blank. I then put code on the command button that runs the query like Dim stDocName As String if...

Hi Excellent thanks for your help.

Hi All I have a linked foxpro table in my db I need to query. In the Foxpro system there is a text field where users put in a date so no validation to ensure that the user has put the date in the correct format (I can't change the foxpro system). I therefore need to run an exceptions query to...

Hi Hoping someone can help with this problem. I have the following code on frmpricing when the record is saved. For Each Ctl In Me.Controls If Ctl.Tag = "QuoteLine" Then If Ctl.Value > 0 Then iProductID = DLookup("[ProductID]", "tblpricelist", "[FormName] = '" & Ctl.Name & "'")...

Sorry just re-read my post. Meant to say I don't ever use macros. If they work for you then go for :)

Don't ever use macros but try this. On the on click event of your cmdbutton put the code DoCmd.GoToRecord , , acNewRec me.PartsNumber = Forms!FrmParts!PartsNumber me.RevisionNumber = Forms!FrmParts!RevisionNumber me.CustomerNumber = Forms!FrmParts!CustomerNumber this will set the fields in...

Hi Trevor Thanks for your reply. I can see how that could work but not sure how the field me.NoofTimes would be incremented on the form. Are you saying this would count the number of qty fields with value > 0? The fields on the form are unbound so I couldn't count the form's records...

Hi All I've been trying to figure out this problem for a few days now and getting no where fast. I have an unbound form used for pricing products and services. The form shows sell price, qty, margin etc and the user enters the qty if selling that product. I want to take this data...

Hi cbrighton It worked perfectly. I've been tearing my hair out for nearly 2 days on this so very much appreciated. Thanks