Recent content by dabruins

I'm sorry to say Frink, no, I haven't come up with a solution for this. If you happen to find something on this I would be very happy to hear about it.

I found that you have to set the lock type of the recordset. rst.LockType = adLockOptimistic This works now. Hope this helps someone else?

It seems that all of the rows added to the recordset are returned in the listbox however they are all Null values????

I have a text file that contains record information that i would like to display within a listbox on a form. I've written code to parse out the data within the file. In order to display the parsed data within the listbox I thought I should construct an ADODB.Recordset with the appropriate...

I am having problems getting proper focus on controls in forms that I open via a selection from a treeview. When the frontend of my access database opens I default to opening a main menu form containing a treeview whose nodes are created from a table in the database. The node info includes an...

I am having problems getting proper focus on controls in forms that I open via a selection from a treeview. When the frontend of my access database opens I default to opening a main menu form containing a treeview whose nodes are created from a table in the database. The node info includes an...

Hi Remou. Thanks for the reply. This should work if I handle the error that will occur when looking through the other emails that will not have this property set upon them. Actually, though I am dealing with other problems related to this issue, I have gotten it to work ok using the method I...

The subject line could be changed by the user prior to sending it. I could "require" that they not do so but I would like to avoid it if possible. This is why I was hoping that outlook might assign an ID when a new message is created that I could check for in the sent items folder. Basically...

Hi Remou. Thanks for sharing this bit of code. I can now see how to get a handle on the sent items but how can I be sure that the first item in the list is the message that I composed and the user may or may not have sent? If they didn't send it the first item in the sent folder will not be...

I have an Access form in which, based upon some info provided by the user, I compose an email that contains selected attachments, displaying the email to the user as an outlook message. At this point the user may send the email or not. What I want to know is if they have (or have not) sent the...

Hi Crowley. I finally tracked this down late last friday. It turns out my version of msjet40.dll (9025) is incompatible with my version of the mysql ODBC driver. I reverted to an earlier version (8186) and now things are working as intended. I have set up my app to bypass the jet datbase...

I've been tearing hair out over this one the past few days. I have created a report that uses an SQL Pass-Through Query to a MySQL backend database as its recordsource. If I run the query as it is (simply double-click on it), it returns the records from MySQL as expected in a datasheet view...

Hi Remou. Your suggestions works great! I did have to set the Default Headings values in the strNewList string before looping through the columns and rows but it works perfectly. I guess you have to reset the entire rowsource value for the listbox or perform string replacement if possible on...

I have a Value List type listbox (lstdeliverables) that contains three columns. The third column contains a "Quantity" value. I would like to allow the user to select any number of the rows in the listbox and update its quantity value for the row using a value from a textbox (txtNewQuantity)...

Hi ChanceD2. Concerning option 1 my code given above does just that; prompt the user for the dept and job number. If it finds a match in the database then it opens the jobsetup form otherwise it informs the user it could not and the focus remain on the findform. As for option 2 I cannot...