Recent content by mguidry5

Hey there, I have a combo box called cboParameter on a form. It's row source has several columns which will display on txt boxes with their control sources set to cboParameter.Column(2) etc... My problem is this: I have a Private Sub in the form that is called on the afterupdate event of...

Howdy all, Some background: I need a solution for tracking environmental compliance at a chemical plant. The solution will be used by 4 or five employees that all have Access XP installed, with the possibilty that remote users (Divisional Management) may want to look in and see how we're...

Thanks, Ace. I'll continue to troubleshoot this one. If and when I find the problem/fix, I'll post back. Thanks again, Mike

PHV, I suppose I could have. I fixed the issue by creating a new database with only the required libraries referenced, and then importing all of my database objects from the old to the new. That fixed it in my database, but I'm still getting this error on other client computers on my...

Hey guys (and gals), I'm using some code to send emails with the cdosys.dll, and it works fine in one db that I have. The code uses late binding in case the user doesn't have the cdo reference enabled (and checks to see if cdoex.dll is used instead). Here's the code I'm using: Private Sub...

Thanks for the link, Remou. Unfortunately, it hasn't helped. I did have a few "superfluous" references checked, but leaving them out and recompiling didn't help. The funny thing is that this code was working on my machine (running Access 2003 w/ databases compatible w/ 2000), but not running...

Yes I have...no missing references.

Howdy all, When I run the code below, or any procedure using the "Fullpath" method, I get an error saying "Method 'Fullpath' of Object 'Reference' failed." Dim ref As Access.Reference ' Enumerate through References collection. For Each ref In Access.References ' Check IsBroken...

Howdy all, When I run the code provided above by Remou, or any procedure using the "Fullpath" method, I get an error saying "Method 'Fullpath' of Object 'Reference' failed." I'm assuming this is a dll issue. Can anyone tell me which dll might be the culprit, and if there is an elegant fix to...

Thanks, PWISE! That did the trick! [thumbsup2]

Howdy, I'm trying to use the CDO sendmail method that I found in a FAQ here, but I have some computers that are sure to not have the CDOsys reference enabled on their machines. If I use late binding to set this reference, I get errors when and if the reference is already set. I use this to...

Thanks, guys. Randy - I smell what you're steppin' in, but I'm still curious as to why my mousedown event interupts the selection of an item from the combo box.

Hey there, I'm trying to resize a combo box with a mousedown event. The combo box has two columns, VendorID and VendorName. The VendorID is an autonumber, and therefore meaningless to the user. The autonumber is bound, so I'm using an unbound text box to hold the vendor name. What I'd like...

Duane, I'm trying your solution, and i'm getting a message when I click my command button that says "Item not found in this selection." It doesn't bring me into VBA and show we what line the error occurs on, but if I comment out the line CurrentDb.QueryDefs("qrySHAREbyLocation").SQL = strSQL...

howdy, I've got a report called rptSummary with two OLE pie charts on it. I'm opening the report from a form called [COLOR=blue]frmAdminTools. I've got some code on the report's On Open event that grabs some parameters from [COLOR=blue]frmAdminTools and makes a query string. I'm trying to...