Recent content by barretc

Hey, I am trying to code a button which, upon clicking it, copies the information currently in the form into notepad. So far I have successfully coded a way to put it into an email. I was just wondering if the above solution would look something like this, or would it be completely different...

I can send you a report of this form.

Thanks, and to clarify, i'd be using 4 text boxes instead of 3 right?

Private Sub Command235_Click() Dim strToWhom As String Dim strMsgBody As String Dim strSubject As String strSubject = "Your Subject goes here!" strToWhom = "email@email.com" strMsgBody = "Account No: " & Account_No & Chr(10) & _ "Date: " & Date & Chr(10) & " " & "Customer Name: " &...

Hey, I've been looking at this website (http://learning.north.londonmet.ac.uk/ib212/week7/validation.htm) and i'm trying to find an input mask that lets a user enter in an I.P. address like the IP settings in Network Connection > Properties > TCP/IP > Properties. E.g. a user enters 19216802...

Sorry CEH, I don't think I was clear enough. The reports that are sent aren't formatted very well. I am trying to send a "snapshot", but of the actual Form. Thanks for the suggestions nonetheless.

Thank you both for your help. However, if I may ask valheru, could you please comment on the code? If you could, it would help me incorporate your code with what I already have. Again, thanks.

You are talking about a data access page, where your users can enter data? "These can be created in a matter of minutes, and then published on your existing web server" http://databases.about.com/od/tutorials/ss/dataaccess.htm This will explain it better than I can. HTH

Customer support reps enter data in the form off site, and if it's an issue dealing with the company i'm working for, the csr needs to get those details to me. I found another way to do it, but thanks in regards to the suggestion. The reports however aren't very well formatted in the email...

Hey, I'm trying to get the output of checkboxes to be output as Yes (Ticked) or No (Unticked). As you know there are 0 and -1 (People are going to read this data so I want it to be meaningful). I was going along the lines of: IIF check_box = -1, "yes", "no" I checked the Access help page...

Hi, So far I know there is a wizard for being able to create a button that sends a Form Report. What I really want to do though is when the user clicks the button on the form, just the form is sent/attached to the email, effectively giving the viewer/receiver a screenshot of the Form in...

Thanks again RG.

Thanks RG, I'm also looking to predefine the size of a text box. I.e. I want a text box to contain maximum 2 characters. After 2 characters a user won't be able to enter in any more. Thanks.

Hey, I am creating a form and one of the fields are 'Area Code'. Input will be along the lines of 02 and 03, but whenever I do this it deletes the 0, just leaving a 2. How do I make access leave the 0 in the field? Thanks.