Recent content by Chad-M

I would agree with GalaxiomAtHome. It is quite easy to learn VBA and the help system pretty much gives you what you need to make your modules, if not then the internet can always give you what you need. You are right with the Do Until statement so have a go making your own macro. Hint; Sub...

What are you using to convert your reports to pdf's? Im using bullzip which will convert my documents to a .pdf by rewriting a settings file. In the settings file it basicly says what you want to call it where you want to put it etc. Once the setting has been used then it will reset back to...

Try Environ("path") This will give the the entire location so maybe use a left statement

This code will open up your outlook (dont forget to add the refrence) if it is not already running. Im not sure if this will help you or not. Dim bStarted As Boolean Dim oOutlookApp As Outlook.Application Dim oItem As Outlook.MailItem On...

Try this. It will find where the space is between the names and then extract only the last part. sFullName is the variable for the full name. Dim iSpacePos As Integer Dim sFullName As String SepName As String iSpacePos = InStr(sFullName, " ") SepName = Mid$(sFullName, iSpacePos + 1...

Do you mean you need a procedure to run as soon as it opens? If so open the form in design view and (in 2003 i dont have 2007 sorry) there is a square in the top left. Right click it and under the event tab create the procedure On Open. If that helps...