Search results

Lotus Notes Automation Code CutAndPaste, Type mismatch is when you are trying to put one type of value into a place where Access is expecting a different type. For example, putting a string value into an integer field causes error 13, type mismatch. I would bet that this is the line causing...

Rob, you were pretty close, try this... strFilter = "[Claims] = 'Settled' Or [Claims] = 'Both' " Always use brackets around fields, if not for any other reason than to avoid confusion. Anytime you use multiple criterian in code or in this case filters, you will need to restate the field...

Hello all, I need to print a screen from another application through Access VBA. At first I thought this would be a piece of cake - at first. Here's the problem, I can't get the automated application to do a simple printscreen. Ok, so I read the screen into a string variable thinking I can...

I have several databases that I send email via Lotus Notes. I use a loop and send reports to one person at a time. Problem is, if I have the same reports going to multiple people, I have to send multiple emails. I have been trying to add multiple people onto the send to line during my loop...

Go to Internet Explorer... Tools - Internet Options - Programs tab - Select Lotus Notes as the email program. This will allow your sendObject to work. However if you are sending 200 items you should put it into a loop. I do this with several databases and it works very well. Let me know...

Here is some code to work with, I built this in Access VBA, but you should be able to use it.... Dim arrWavArray(1000) As String Dim iCounter As Integer Dim varFile As Variant Dim fsoFileSearch As Object Dim strRndmFile As String 'find all the files indicated...

What about using a SQL statement to create your table... DoCmd.RunSQL "CREATE TABLE tblORDERS(Order varChar)" And then using another SQL statement to populate.... DoCmd.RunSQL "INSERT INTO tblORDERS ( [Order] ) SELECT OldTable.Order FROM OldTable;" It looks like you are on the right track...

The way to do this is to read in all the wav files in the directory in question into an array using a loop. Next use the randomize function in access to generate a random number between 0 and the count of wav files. Use the random number generated by the randomize function as the array index...

Not exactly sure what you want to do. In order for a module to return a function you need to declare it in the function line. For example: Function TEST()as integer '...your code 'place at end of code TEST = 9 end function This function will return 9. In the criteria section of your...