Search results

Everythng seems working fine except that the UpdateDbFE.cmd file is not removed after the version update. It still sits at the location where the mde file is.

Got it but in this case, users may also see other objects (forms, tables etc.) in the database on top of the start up form. When the form is put in the database start up option, only this form shows up when users open the database and that is what I want.

Should I run this start up function (after editing the start up form name) in the autoexec marco after running the version check codes?

The autoexec marco works to replace the old mde file but the problem is that the start up from will show up at the same time as the incorrect version message box which would be confusing to the users. Leaving the codes in the load form event does not have this problem. I really want to set a...

Thank you so much for cleaning up the codes. I agree it is better run the codes at startup to check the version and replace the mde file where neccessary. I have now created a sub routine in the module with all the codes in the form so that all codes for the process are in the same module...

Thank you for your quick response and help. I shall wait for the good news on the revised codes.

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

Thank you so much for your comprehensive and informative comments. The orginal code on the cboFind_AfterUpdate sub routine was inherited from someone who created the database. The codes for filtering work great and it seems to speed up the employee searching process but I can't tell the degree...

Thank you for your suggestion. It would be great to use lighter codes. However, the filter option does not work. The purpose of the Find box is to pick the employee from cboFind in the main form and return the respective record of that employee in the subform. EmpID is the linked field between...

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

It ended up that there are some other conflicting codes on the button which forbid it from acting properly. I have debugged the codes. Thanks everyone for the response.

Those are just my typos on the thread. I am sure the wordings are correct when I use those codes in the database.

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

No. You are right. I want to disable some controls including text boxes and a check box based on the BYOD/Personal check box. Changing that check box to Y/N dropdown combo box would get around it. Thanks again for your help and quick response.

Thank you so much for your advice. It works great with conditional formatting although it does not apply to check box. I might have to consider changing the check box to text box with dropdown options of "Yes" and "No".

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

boblarson, thanks again for your guidance. I have done some reading on the web and been able to make the XML work to display custom ribbon on forms and reports. The only weird thing I encountered is that some buttons only display when I open the database by holding down the Shift key. If the...

I tried to create custom Ribbon but can only make it shows up on the Ribbon dropdown list but the Ribbon itself does not show up. I could live with as is under Add-Ins but the Home tab still shows up on user's PC when they open the database. Is there a way to hide the default Home tab?