Search results

hi all, having trouble with a simple audit trail routine i'm writing. i'm getting a compile error indicating: "Next without For" here's the code. *********************** Dim ctl As Control Dim frm As Form Dim sUser As String sUser = Environ("UserName") Set frm = fForm For Each ctl In...

hi all, i have a couple of simple audit trail fields used to track when a record has been modified and by who. the code uses the Environ("UserName") variable to avoid workgroup security (i.e. CurrentUser property). the code fires on the BeforeUpdate form event on a subform. here's the code...

howdy all, i have a database generating a "run-time error 35602 Key is not unique in collection" when the application tries to close for one of the following reasons: A. perform compact and repair (launched via custom menu) B. closing the application via a "quit" macro this error only...

hi all, is there a way to determine if the chart's recordset is empty? i have bar chart (based upon a separate query datasource) on a report that displays items waiting approval. if there are no items awaiting approval the chart does not appear and there is a big void space in the report...

hi all, i have a main navigation menu that uses a tree structure to launch various objects in my application. i populate the tree structure using the OnLoad event. nodes are hard coded. since i only use the tree structure for navigation to various database objects i do not use recordsets to...

hi all, i've created a public routine to perform some conditional formatting. the objective of the code is to highlight and bold date values if the task has been completed late or is missing a value for the completed date and the due date has passed. when testing the code in the VBE it...

hi all, i'm not sure if this is the correct forum, so i apologize if this is in the wrong place, but here goes anyway. i think this is an MS Access rather than a .NET question but I could be wrong. i'm trying to connect a .NET web form to an MS Access backend that has workgroup security. for...

hi all, i have a navigation form with a treeview control used to launch different database objects such as forms and reports using the OnClick event for the treeview control. i also have a node in the treeview to launch a .pdf document using the FollowHyperlink method. everything was working...

hi all, i have a single table datasource that feeds a bound form with a tabbed control on it to separate the data into a meaningful way for the user. basically the user only has to populate the 2nd tab if the answers for 2 controls on the first tab are "yes". there are more than 2 controls...

howdy folks, i'm having trouble coming up with the correct syntax for a SQL statement that i'm passing to an ADO recordset. i'm trying to use a text box on a form to pass a "keyword search" value to create a ADO recordset using the LIKE function. i then loop through the ADO recordset to...

hi all, not sure if this is the correct forum but here goes. is it possible to have a disconnected ADO recordset populate a combo box in an Access Project (.adp)? i have a Access XP front end piping back to a SQL Server 2k dbase. i'm using a stored procedure to handle my insert, however i...

hi everyone, i have a form that i'm trying to create a button to duplicate the record. i'm using the control wizard which produces the following code: Private Sub DuplicateRecord_Click() On Error GoTo Err_DuplicateRecord_Click DoCmd.DoMenuItem acFormBar, acEditMenu, 8, , acMenuVer70...

Hi everyone, i'm in the process of uploading some data from an Excel spreadsheet into an existing table and i'm getting some screwy things in my PK field. i'm using an autonumber field for my PK and i can get the data to import from Excel but instead of insert the record and creating the next...

Howdy all, i'm putting together an inspection database and i've got a question about proper normalization between the tables. here's the business rules: 1. have a tblArea = corresponds to geographic area of a facility e.g. kitchen, living room,..etc 2. have a tblMajorItems = corresponds to...

Howdy folks, I having a little trouble with a query I was hoping someone could help me with. Basically I have the following SQL statement SELECT tblEClass.EClass, tblCService.CService, Count(*) AS CCount FROM ((tblEList INNER JOIN tblEType ON tblEList.ETypeID = tblEType.ETypeID) INNER JOIN...

Howdy all, I've written a simple little function using the DateAdd system function which i call from query. Here's the logic If (PassFail = "Pass") Then IsNull (FirstRepairDueDate) Else FirstRepairDueDate = DateAdd("d", 5, InspectionDate) End If basically if the PassFail argument is...

Howdy folks, i've been working on an application with a hyperlink text box on one of my forms. it is a bound control to a hyperlink field type. in order to get the for the user to enter the file path i've included some code to call the windows common dialog box. this procedure runs when the...

Hi all, i am trying to create a report based on some dynamic SQL and i'm getting stuck. here's what i've got so far: Public Function CreateDynamicRpt() As ADODB.Recordset Dim cnn As ADODB.Connection Dim rst As ADODB.Recordset Dim sSQL As String Set cnn = New ADODB.Connection Set rst = New...

hi everyone, i'm trying to develop an email tickler for one of my dbases to act as a task manager. basically, i have one table that holds people information (task do-ers). example fields are: A. UserID (PK)

hi everyone, i'm trying to add an "All" criteria to my combo box that i use as a parameter for a query. i've added the "All" selection using a union query. now i can't figure out what SQL to use in my parameter query. i need some kind of conditional statement that basically says if the value...