Search results for query: *

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

...use to pass the query to the OLE object. Yes - my query works. Me.OLEUnbound42.Report.RecordSource = "SELECT tblIncidentLocation.Location, Count(*) AS [Count] " & _ "FROM tblIncidents INNER JOIN tblIncidentLocation " & _ "ON tblIncidents.Location = tblIncidentLocation.ID WHERE " &...

RoyVidar, Thanks - that does the trick. Sorry I forgot to say which line the error was on, but you got it. If I don't make a selection in the combo, it gives me a default message that is adequate for my purposes. Thanks again, Mike

Hi, I've got some code that's giving me problems. I'm allowing priviledged users the ability to modify some table content via datasheet forms. The tables are used as combo box data sources throughout the database. I've given them a combo box (cboLists) to select the pick list (table) that...

Okay, now I get it. I've read several posts by Duane Hookum that refer to creating a grouping level on the subreport to the expression "=1", setting it's header to yes, then in the "=1" header properties setting "Repeat Section" to yes, but I didn't get it until just now. Works like a charm.

They are report headers. I'm under the impression that Page headers won't print at all in a subreport.

Howdy, I have a report with several subreports on it. My problem is that sometimes, depending on how much data is in one or more subreports, a subreport will continue onto the next page and leave it's header information behind. I don't see a way to specify grouping of the subreports from the...