Recent content by karcher

Anyone know a way I can look for a file and then run code *only* if that particular file exists? Right now I'm creating a .txt file (using vba) and attaching to an email message in MS Outlook. When you click on the "send mail" button, it prompts the user to enter an ID number and then emails...

I have the following code attached to the "before update" event on my main customer form: Sub Form_BeforeUpdate(Cancel As Integer) Dim Msg, Style, Title, Help, Ctxt, Response, MyString Msg = "Do you want to save changes ?" Style = vbYesNo + vbCritical + vbDefaultButton2 Title = "Data...

I have a text box that accepts a six digit field. I want to display each of the digits in a separate textbox of their own. I've heard of the Split() function but I'm not entirely sure how I'm suppoed to use it, or even if it would work for this. Thanks.

I'm having problems trying to create a piece of code that will close a form in either of two ways depending on what the user does. If the user changes the contents of any of the textboxes, I want the close button to prompt them to save the record. If they choose "yes", then it should save...

I've been using Access for a while now but I'm relatively new to VBA and I've came across a problem that I have no idea how to overcome. I'm trying to print 4 separate reports from the one button, at the one time. But the user has to be able to choose which printer they want the reports to...