Search results

Thanks for the reply. I already took a look at the overall problem again and it was definitely the overhead in calculating using a function within a query. Funnily this is something I have read about numerous times but for some reasons blindly thought I would be different and not hit the same...

I am using the following function which basically queries a table to find out when a record was moved from being in one status, to a new status. The status' are there to monitor work flow through the system. My function is: Function DaysInStatus(IncidentTyping As Integer, HSE As Integer) As...

I have created a custom shortcut menu for my pivot charts so that only the drilldown/drill out/expand/collapse menus are available when viewing a pivot. This menu works fine when I open up a form directly as a pivot chart. However I have then placed this pivot chart as a subform on my main form...

Thanks for the quick reply DCrake. I assume this is the standard way for returning a record count and there isn't anything overly drastic I should be changing apart from freeing up some resource by cutting out a few of the set statements. I expect due to the shear volume of the counts I...

I populate around 45 textboxes on a form to display various counts of records within my database across multiple tables. I use the basic framework in my submit button of: 'Counting actions required to close in current month and current fiscal year Me.txtActionsReqClose =...

Hi all, I am having trouble with connecting to my companies LDAP to retrieve userinfo. I can return basic information from my local area using the following connection settings: Set oRoot = GetObject("ldap://rootDSE") 'work in the default domain sDomain = oRoot.Get("defaultNamingContext") Set...

Endre thank you for the suggestion. It is funny I actually use vba already to change the recordsource with a SQL string in my other charts but I did not realise I can just create the table behind the pivot chart in the same way (dont ask why I think my brain needs to be kick started...

All, Basically I am trying to change my pivot chart a bit more dynamically. I have a sub form with a query recordsource which contains all the fields I would require to create TWO pivot charts. The sub form opens as pivot chart view and ofcourse is placed as a control on my main form. I am...

Solved the problem: In order to use sql with DAP dropdown/combo boxes simply create your string as you normally would, for example: SELECT tblEventCats.NCEventID, tblEventCats.[NCEventCat] & " - " & [NCEventSubCat] AS NCType2 FROM tblEventCats Then paste this in to the ListRowSource field...

Thank you for the info guys after a couple of hiccups I have got it working now. I decided to create a table. CategoryID EventCat - The main category names EventSubCat - The sub category potential errors I realised I can easily combine the fields in most of my row sources by modifying the...

I have yet to see this but I would like to be using it in the near future on one of my forms. I basically want to categorise my combo box/drop down menu in the following manner: Documents -Missing information -Late -Errors -Incorrect version Equipment -Faulty -Breakdown etc etc Thanks, Chris

More information to add: If I fill I select options for both of the combo boxes i.e. department cost incurred by and cost type. I do not get any errors. If I delete the selected value from the combo boxes and click save (to validate the form again). I do not get any errors. So this only...

Ok I have got the validation part working ok however this error still keeps occuring at the end of the procedure. If I step through the code the error crops up within the save button on click event within the generic error handler after running through all of the before update event. I...

I have posted this on another forum with no luck. --- Well I created my first try at form validation through using the before update event. However I am now having issues. I am validating a subform on my main form. The validation code is held within the subform. I have 2 comboboxes and 2 text...

I use a custom login system within access 2003. I have the form currently matching the username and password supplied against a table. I want to then retrieve and store other information within this table such as the GroupID and AccessID which I will then use to lock down buttons and forms from...

I am using the following code to open up a new window within my data access page: Dim vServerfilter Dim vLocation vLocation = "CorrectiveAction.htm?serverfilter=" vServerfilter = chr(34) & "CorrectiveID=" & MSODSC.CurrentSection.HTMLContainer.children("NCC_ID").value & chr(34) vLocation =...

Hi all, I basically want to save a record as soon as the data access page loads FULLY. I can get the page to save perfectly fine using the following code: <script language=vbscript event=onload for=window> call hi </script> <SCRIPT language=vbscript> Sub hi() msgbox "just to delay"...