Search results

Hi there, I got the subject runtime error on and off when I run the following module in Access. This error only appears when there is already a Excel worksheet opened on my computer but this is not a regular incidence, meaning that I don't always get this error even with the existence of another...

I am investigating on the possibility of setting up an approval process for our employee intake procedure by using MS Access and Outlook. The idea is for the requester to open an intake form in Access and fill in the new employee's information and send an Outlook email to the manager for...

I am considering the possibility of revamping the employee onboarding & off-boarding process for our organisation to make it more efficient. Current State: We use InfoPath forms in SharePoint Servers 2010 to handle onboarding/employee change/off-boarding requests submitted by the related...

I am looking into an automated solution to run organisation charts from MS Access. There are a number of free and paid applications in the market but many of them require modification of the existing table structures in our employee database, such as adding org chart box ID, Parent ID...

Hi there, We keep a backend and a master frontend of a database on a network drive and distributed a .mde version of the frontend to the users who save a copy of it on their hard drive. There is a separate version table on the frontend and backend of the database for version comparsion...

I have an employee input form containing a "Find" combo box for user to search employee records in the embedded sub form. The VBA coding as follows: Private Sub cboFind_AfterUpdate() 'Purpose: Find employee indicated in drop-down box On Error GoTo Error_cboFind_AfterUpdate Dim rst As Recordset...

I have a continuous form in a database showing employee information on each from and want to enable a command button only when a particular check box is ticked. However, the following codes do not have any effect on the button neither under the Form_Open nor Form_Current event. The button is...

Hi there, I have a continuous subform recording the information of various wireless products for an employee embedded in an employee main form. Please see screen shot enclosed. There is a check box "BYOD/Personal" on the subform. I want to hide a number fields when this check box on...

Hi there, I want to be able to connect dynamic web data such as live gold price, exchange rates from the relevant web pages to a table in Access 2010. I have searched the forum without finding any related answers. I understood that this can be done in Excel by using "Get External Data from...

I have created a custom tab in 2010 for a specific report in XML. Some buttons in the tab do not display when the form is open but when I open the database by holding down the Shift key, all buttons show up. Below is the XML for the custom tab - only the Exit button is displayed but not the...

I have a combo box with employee names on a main form, which is used to search employee records on the sub form. It works well in Access 2000 but some Methods used in 2000 are no longer valid in Access 2007-2010 after I migrated the database to 2007. For example, the "If Not .NoMatch" method is...

Hi there, We have an Access 2000 backend database resides in a network server drive while users connect to the backend tables with a mde file on their computers. All users have Access 2010 and the mde file was converted from the 2000 frontend with Access 2010. The database have been running...

After upgraded to 2010 from 2003, I was unable to modify customer menu and tool bars on database created in older Access version. I searched the web and found a possible solution to use customerized ribbons at http://msdn.microsoft.com/en-us/library/office/bb224579(v=office.12).aspx but am...

I have a table which captures the monthly headcount by resource type & by department, layout as follows: DeptID Internal External GR Month MonthNum Year TSS 7 0 0 Sep 11 2011 CS 115 33 20 Sep 11 2011 DTI...

I have a form which provides users the feature to select names on the employee list box (linked to the employees table) on the left and move them to the manager list box (linked to the managers table) on the right. Status of some employees are active and some inactive. I want to be able to...

The following codes work fine - it allows users to choose OK to allow change on the form field and reject change by choosing Cancel. Private Sub ContStartDate_Dirty(Cancel As Integer) Dim strMsg As String Dim intchoice As Integer strMsg = "XYZ"...

I have an employee input form which contains an unbound Employee Find text box. It allows users to find an employee and show the employee details on the subform. EmpID (an autonumber) is the master/child link field. It works fine except that we I add a new record, it gives me an error "You...

I have an employee table updated through an input form and want to track any changes made by users. I expect to store this info in a log table including what change has been made on what field, by who and the date/time when that happens. I could append this info to the log table when the...

I have to run the following codes in the After Update Event for a number of form fields and can not figure out what varible type to declare in the user defined sub routine. The procedure is the same except that the field name should be a variable. Private Sub ContractorType_AfterUpdate() Dim...

I want to make sure that users of a form need to perform an action first before changing on some selected fields on the form. My thought is to fire up a message when either of those fields has changed. I can not use the OnDirty event on those fields since I only want the message to appear once...