Search results

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

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

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

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

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