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

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

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

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

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

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

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

Howdy, I'm trying to set the value of an unbound field on an unbound form to a count of values returned in a query. A buddy of mine gave me the following code to use: Function RecordCount(ByVal queryname As String) As Long Dim db As Database Dim rs As Recordset Set db =...

Howdy, How can I make this number (2.97, which represents just under 3 days) into a time value in the format of h:nn:ss? TIA MJG

I've created a hyperlink in a word document. It works fine while I have the document open. It looks like this: R:\Regulatory Compliance and HS&E\Environmental\Regulation Records\Air\NCIN MACT (40 CFR 63 Subpart EEE)\Recordkeeping\Monthly Review Forms.xls. The problem is, when I save the...

Howdy, None of the threads I've found seem to answer this quite like I need it. I'm trying to populate tblFindingCause.IncidentID and tblFindingCause.Cause via a listbox (lstCauses) from a form. There is a static field on the form (txtIncidentID) that will be used to pass the incident ID to...

Howdy, I'm trying to have a form close when a user chooses "Cancel" from a MsgBox. The MsgBox is triggered by an "On Exit" event from a control that receives focus upon form load. If the control value is null upon attempt to leave it, the MsgBox gives the option to go back and enter a value...

Is there a date picker control that can be used on a continuous form?

Howdy all, Is there a way to customize the DTpicker object to allow the user to select a date AND time from the same object? I've never used it in a production environment, but just playing with DTpicker it appears that you can choose long date, short date, OR time (but not long/short date AND...

I'm trying to use an if statement to determine whether a form opens to acFormReadOnly or to acFormEdit. The part that compares the CurrentUser to the ParentUser works fine. It's the date part I can't figure. I want the form to be editable only where the usernames match and the RecordDate is...

I'm opening a form from a switchboard and I'm using the acFormReadOnly argument so the users can't edit info in the form...so I thought. This form has a date field that is populated by an active x calendar object. The calendar is hidden until the user clicks in the date field (which is a combo...

Hiya, I've developed a small database that will be used daily with the potential for four users to be in the database at once. I have a custom workgroup created and users will only be able to access the database from a shortcut that specifies the workgroup. The database has not yet been...

I'm opening a form with the acFormAdd and acDialog properties from a switchboard. My mainform has a subform on it, or it used to at least. Now it just won't show up. There aren't any loading or opening or on current events happening, so I don't know why this subform won't open. Any known or...