Recent content by hi there

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.