Recent content by Blackelise

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?