Search results

You beauty!!! That's perfect. I'll have to try with other users in the morning. I was pulling my hair out all morning. Thanks a lot!! Simon

Haha thanks! Yeah, that's how I noticed the space in the first place, I could see there was two spaces before the "on" :) Email and Msgbox still the same. Debug is still doing exactly the same too I'm afraid. and stName still shows a space "Simon Gibbins " just to confirm my code: stName =...

Thanks for the reply. If I put a debug it returns everything fine. If I run MsgBox stMain it returns only up to and including stName, exactly the same as the Email content. Thanks

Hi everyone. I am hoping someone can shed some light on a problem I am experiencing. I have some code which emails some data from a Table loaded on an open Form. The body of the email is determined from some strings which are getting their data from the fields of the table. stMain = "Please...

THANK YOU!!!!! This has been driving me crazy for days!! I really appreciate your help!!

Hi, This is great. I can get this to work, except my Memo field. I cannot use text fields because they are too small. But even if I put less than 255 characters in a memo field, the email just displays the name of the Table instead of the contents of the Memo field. Can anyone help?? Thanks!!!

Hi I have a save button on a form, when clicked creates an email. I've set it up to include the details from the form in the content of the email. But I have found the text limit of 255 is not enough. So I have changed one of my fields to a Memo field. But when I try and include this in the...

I have a form which is linked to a query with a criteria prompt. On the form is a list box which looks up data from this same query. So when I load the form, I am prompted to enter the criteria parameter twice. If I deassociate the form with the query, my other textbox on the form which is...

That worked a treat! THANK YOU!!

Sorry... ...error highlighted on: FileCopy "C:\FILES\ALLOC.CSV", NewName Runtime error 76: Path not found. wasn't sure if the FileCopy function allowed for a variable string. Cheers

Hi, I want at a click of a button, to copy a file and rename it with Todays date. C:\FILES\ALLOC.csv C:\FILES\ALLOC191109.csv I've got the FILECOPY code working: Private Sub rename_Click() FileCopy "C:\FILES\ALLOC.CSV", "C:\FILES\ALLOC191109.csv" End Sub but I've tried adding the...

yeah i called it FrmZoom

ahhh...done. It doesn't seem to like: DoCmd.OpenForm FrmZoom comes up with: Run-Time Error: '2424' The Action or method requires a Form Name argument.

cheers thanks again, i'm not sure what you mean by startup module? do you mean create a new blank module called 'MyPK, MyString' ?

thank you very good point!:D can i use the expression builder to form some code for this?

Hi Everyone Is there a way you can have a text box pop up when you hover the mouse over a record in a list? the text box would contain the data in a field from that record. cheers