Search results

My digging around has found that these menus created in A2003 do work in A2007 on wards. However it seems that one can not longer use the same method in A7 onward. The solution that I came across says to use A2003 to create the menus and then import them into A2007+. Whilst this may work it...

Add me to list of those who would like to know!

Format(...) does the trick! Thanks again for helping me out.

Thanks both for your advice. I'll implement the suggestion and report back. Cheers guys.

I have the following line of code; DoCmd.OpenReport "SalesList", acViewPreview, , "Taxpoint between #" & Me.FromDate & "# and #" & Me.ToDate & "#", acNormal Background to the problem: The controls on the form I use to collect the user input for the dates - FromDate & ToDate - display the date...

Got it!!!! The problem was quite simply that one needs to have dbOpenDynaset defined in OpenRecordSet. I don't know why as it's not shown in any examples I've seen...anyway solved my problem. Dim rs As DAO.Recordset Dim db As DAO.Database Dim CustPayTerms, strSearchName As...

@lagbolt - thanks made the changes you suggest. I have correct the typo - rst. for rs. - however I now get "3251 operation is not supported for this type of object"

I am trying to implement recordsets but keep getting this error at run time and I can't see why! The code is: Dim rs As DAO.Recordset Dim strSearchName As String Set rs = CurrentDb.OpenRecordset("tblCustAddress") strSearchName = Str(Me.EstOrd_CustName) If rs.RecordCount <> 0 Then...

Thank you both. @pbaldy I do seem to owe you an apology! When I implemented your autofil for use upon user selection when I moved back and forward the correct information was displayed much to my surprize! Access clearly reruns the combobox control source each time a record is displayed. one...

Thanks pbaldy. 'Autofil' looks neat but it would only seem to work when the user selects something from a list. I will use this for user data entry on record creation. The issue that I see would be displaying the customer information as the user move through the records not only displaying...

Hi again, I have the following code: CustAddr1 = DLookup("[InvTo_Add1]", "tblCustAddress", "[InvTo_ID] =" & [EstOrd_CustName]) CustAddr2 = DLookup("[InvTo_Add2]", "tblCustAddress", "[InvTo_ID] =" & [EstOrd_CustName]) CustAddr3 = DLookup("[InvTo_Add3]", "tblCustAddress"...

jdraw, thanks works perfectly! Blindingly obvious now!!! Thanks again.

Hi there, Please could someone put me straight here! I just can't get the following to return any reacords... DoCmd.OpenReport "SalesList", acViewPreview, "", "EstOrd_DateJobCompleted between " & Me.FromDate & " and " & Me.ToDate, , acNormal No errors are displayed, just a blank report...

Thanks Bob. looks the same as mine coding wise. To help me better understand I added a new text box on yours in the header, changed the code, it worked. 'Played' a bit more all worked fine, so I understood the mechanics... Still could not see what was wrong with mine so I deleted the text box...

Thanks. I have tried as suggested but I still get a runtime error ‘You can't assign a value to this object', debug still highlights 'Me.ReportType = Me.OpenArgs' regardless of which event I use. any thoughts?

Thanks. But what I had omitted was that the value for ReportTitle will be based on a flag which will change as the Form (an order entry form) changes its status as progresses. So depending on the status when the user clicks the print button the value passed via OpenArgs will have its value set -...

Hi, I am seeking to write a value to a field on the report that has been passed from a form using OpenArgs. The value is received by the report but I cannot get the report to display it. Details: I have a text box in report design, it is called ReportType. ReportType does not exist on the...

Hi vbaInet, got the nulls with debug and trial & error....work well on the forms. I'm going to give the user three options for printing - Quote, Order & Invoice - and then push the title through from the selection along with a filter. Might need help with openargs on docmd.openreport though...

Hi again, head somewhere sort again.... I wish to have the title of a report (and simular on a form) that is based on the value of a three date fields held on the report/supporting table. So I have a Quote/Order/Invoice report. I have three date fields; QuoteDate, AcceptedDate &...

What a neat bit of code....and guess what it told me...? ;)