Search results

hi guys, thanks for the info. i figured it was some syntax thing. i used "GoTo" to pull my "Next ctl" out of the condition clause and everything worked with the existing logic. thanks for the help

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

thanks bob! worked perfectly. thanks for demystifying the BeforeUpdate event for me.

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

thanks for the responses. this code actually is for a report that runs on the "details section" OnFormat event. therefore, i do not have the option of using the "OnLoad" or "OnCurrent" events.

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

do you have to use a System DSN that points to the workgroup (.mdw) file? i tried that and i'm still having problems but i wonder if i'm on the right path?

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 rural, thanks a bunch. as soon as i changed to variant everything worked. many thanks.

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

hi DB7, thanks so much for the help. that worked perfectly. thanks again.

hi fofa, i tried WHERE D LIKE'*" & Me.txtKeyword & "*'" but still receiving the same 3021 error which occurs when trying to when navigating to the first record using the .MoveFirst() method. it doesn't appear to be returning any records because the .RecordCount property = -1, however...

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 Tim, thanks for the response. i was thinking about trying your second solution and downloading the lookup tables from the BE locally to the FE and then basing the combo boxes on local tables in the FE. how would i go about doing this from within the FE? i was thinking about using a make...

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