Search results for query: *

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...

No there are only two forms that I am working with. The first (Find Form) only prompts the user to provide a job number and dept name. The only other control on this form is a command button (Findbutton), that when pressed, uses the job number and dept to find a corresponding jobsetup record...

I have a form (FindForm) that I use to retrieve a record in a MySQL database and then open a second unbound form (MainForm) displaying numerous fields from the record. In the following code I am able to open the form successfully and things seem to work ok but the user may choose to return to...

Hey AceMan. Yeah I now see the difference. Looks like I was testing against the control itself and not it's value on my first attempt. This is essentially what I have done on the second go round and now works just fine. Thanks.

I tried that traingamer but it lead to more problems due to other circumstances. I have since found that setting the control value to an instantiated variable allows me to perform comparisons on it and does seem to fix the problem as shown below. Dim ctl As Control Dim blnCtlVal As Boolean For...

I am experiencing an error 458 "Variable uses an automation type not supported in Visual Basic" when opening a form. In the Form_Activate sub I call another sub setHOSfields() that enables/disables some check boxes on the form based upon the value of a related checkbox. This is where the error...