Search results

It works like a chime. Thank you so much for your help. Now I have another problem. After migrating to 2007, the customer menu bar on the Start Up Form does not show up. I can't find it under Options/Current Database/Shortcut Menu Bar dropdown but I see it under the Add-Ins top menu though...

Thanks for the response but I don't see there is a feature in the form wizard to add codes to filter records on the sub form by selecting a respective ID on the main form. The subform wizard only helps will adding the sub form and identifying the Master/Child link field. Can you be more specific...

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

Hi Ari, I have set up the UsysRibbons table and entered the name of the ribbon and XML codes from a customer ribbon I created and export in Access to the default .exportedUI file. I can see and select the ribbon name from the form but I can not make it to work. The question is how to load...

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

Thank you for the suggestion but how can we display the month & year as column headers as shown on my report format. This is how the end users want to see. I don't think this can be achieved with Access reports. I have now created a module to export data to Excel based on criteria selected by...

Thank you for your comments. I did not follow some of the Access good practices because this is just a sample table. I have now rename the fields and add an Autonumber primary key to the table. For simplicity purposes, I only include 3 DeptIDs and 2 month's data. The sample report with matching...

I use 2003.

I have enclosed a sample db with a table with resource count by month & year. Any help you may provide would be much appreciated. The required report is included in my previous attachment. Thanks

Thanks for your comments but I I did try to use Grouping/Sorting to run Access report but can not achieve what I want. If you open the table & the report in my enclosed image, you will see what I mean. The issue is I can not make the Month as column header and the other fields as row header.

Can you elaborate on how a union query can help in my case?

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

Thanks for your comments. I know there are other options by using continuous form but I am unsure if it worth the effort since highlighting inactive employees is a nice to have feature. I prefer sticking to the list box version. BTW, I can not open the link from Stephan Lebans. Can you please...

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

I know if should be something simple. Thanks for your enlightenment. :D

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 got it now. Thanks for your help. ;)

Thanks for your comments but the table is basically normalized. All fields relate to each employee and do not create repeated groups nor redundant data. I could further normalize the table but without significantly improve the system efficiency. In fact, there are other tables linked to this...

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