Search results

Thanks Paul - tried, tested and SORTED!!! Very fast response and I'm very grateful...... Roger ...

I hope this is the right place to post this question: TextBox1 is Rich Text:- I want to replace my String ("Evidence required of this please" ) in this code 1) following which works fine, with a variable (textToPaste) as in code 2) which doesn't work. 1) TextBox1 = "<div><font...

Thanks Beco - I will divide the firstnames into 5 groups A-E etc. and put a command to bring up a copy of the report with those choices only listed... Best wishes... Roger

Can anyone help with this? I have a report with a lot of names. I can order them alphabetically but there is a lot of scrolling or clicking to get to the name (with the info.) that I want. Is there a method of inputting say a letter to jump to the first name in the report with that letter?

pr2 - I'll tell you what I get:- SUCCESS!!!!! Thank you so much, and such a fast response. I have wracked my brains for the past 4 days on this and as much as I dislike seeking help, I'm glad you were there... Many, many thanks, Roger ...

Can someone rescue me! - 4 days of trying everything and everywhere but defeated at last. Me.RecordSource = "select * from [tblLVRStatements] where [tblLVRStatements]![clientID] = " & clientIDVar & "ORDER BY [tblLVRStatements]![NumberStatement]" Above is just one of my many attempts! not to...

Got it Now!!!! field Is Null produces the result... Thanks JBB...

Thanks for reply JBB but I am trying to get the value (empty value) of the field to which the frame containing the option group is linked. I can quiz the table for values 1, 2 and 3 ok and get the names of these people but the people whose option group field is empty I cannot seem to get. I...

Hi All, I have an simple option group (3 options 1,2 and3!!) I am building a query where I need to display records whose option group field in the table is empty. I have tried: field = Int(0) field = "" field = null isempty(field) do not work - what am I missing?

Your glass was very nice! I will have my glass now! Yes Olympic time is not a good idea - queues around the block at Heathrow and mouth watering prices (unless, of course, you are on the Olympic Committee GravyTrain ( how I am getting into capitalising even everyday words! - sorry -...

A nice town Bury. If you are ever not 'riding through our nice town' then stop by for a meal with us. woodsideboss@gmail.com I'm going to open a bottle now to celebrate YOUR success! All best, Roger...

THANK YOU, THANK YOU THANK YOU!!!!! You have saved me from an early death! How incredible it is, in the times in which we live, that people like you are prepared to spend time and thought to help struggling mortals like me... God bless you Paul... Roger ....

Paul; here is the debug print out - sorry to take up so much of your time - greatly appreciated though.. Roger SELECT BusinessName FROM tblLVR WHERE UserID = '' & passUserID Message is "Too few parameters, expected 1" The UserID is a Number field (not AutoNumber), the BusinessName is a text...

Message now "Too few parameters, expected 2" - I called- Text1 = fieldValue("tblLVR", "BusinessName", 8) Brain cramp here as well, in Bucketfulls!

Thanks again Paul; It fails to find the tblName table (passed to the function, as are the other 2 parameters). Should this be put in as a variable name and if so, How!? At least I don't get the error in the statement message now, just this not finding these passed items (which do exist!)...

Thanks for speedy response Paul; Still floundering here! Errors in the SQL statement. (Lots I suspect!) Can you help? Private Sub cmdTry_Click() Text1 = fieldValue("tblLVR", "BusinessName", 8) Exit Sub Public Function fieldValue(tblName As String, fldName As String, passUserID As Long) Dim...

I can't find this anywhere. I have a function which I want to return the value of a field. Public Function fieldValue(tblName As String, fldName As String) Dim drs As Recordset Set db = CurrentDb Set drs = db.OpenRecordset(tblName) fieldValue = drs.Fields(fldName).Value drs.Close Set drs =...

Thanks so much Galaxiom; very much appreciated...

"Data type mismatch in criteria expression" Error 3464 I get this on the <DoCmd.OpenForm "frmWrittenStatements"> in my code. How on earth are any criteria attached to this? The form exists. Can anyone help?

Well this site is magical! - after spending 7 hours on this I seem to have sorted the problem. Instead of setting the source in the properties window I passed it to the textbox control as txt.controlsource = controlsourcename. I thought I had tried that but brain overworked I think....