Search results

Hi gemma-the-husky, Yes, everything is sorted now. Thanks again.

Hi All, @MajP: thank you for the advice and the updates to the database application. I will apply them to my database. @ gemma-the-husky: thank you for the advice.

Hi Everyone, Thank you for the quick responses. Referring to Post 3, I was going to update the References, under the VBA Editor, but when I clicked on Tools > References, a pop-up dialog box appeared called Blank Password with the message enter Password (this has never happened to me before...

Hi Everyone, I am using Microsoft Access 2010 software. I would like to change the background picture in every form of my database using vba code ((programmatically). I found this vba code example http://access.mvps.org/access/api/api0043.htm and the code has be adapted slightly as follows...

Hi Everyone, Thank you for the help. I will spend some time to implement these changes and if I have any more issues, I will post back later. Thanks again.

Hi Everyone, Thank you for the feedback and the help. I have attached a sample database. The switchboard contains the command buttons which are giving me trouble. @ MajP: I was trying to implement the code which you provided, but I am getting an error for the Me.txtForeColor as it is showing...

Hi Doc Man, I did save my database form and the colours still revert back to the original colours (I also saved the colour change in the sample database, and when I reopened the form, the colour reverted back to the original colour).

Hi, On a follow-up note, I found this sample database by Stephen Lebans which changes the backcolor of the command buttons: http://www.lebans.com/cmdbutton.htm. It works fine, as a colour picker pops-up and I can change the colour of the command buttons. The only problem occurs when I close the...

Hi Colin, Thank you for the information and advice.

Hi Everyone, I appreciate all of your help. I have a standard module called modTextColorChange which allows the user to change the colour of the text labels. I just make my changes to the colour code (i.e. decimal color code) in the module and run the module to update the chosen color in the...

Thank you for the feedback and the answers

I forgot to mention that the Microsoft Access navigation ribbon is disabled so that users cannot use it (the users can only use the customized navigation controls on the Switchboard).

Hello Everyone, Thank you for your responses. I have developed a Microsoft Access 2010 application which uses a switchboard with some command buttons on it e.g. Enter Here, Contact Us, Address Book. If the user clicks on the Enter Here command button, it opens a navigation form which has a main...

Hello Everyone, I am using Microsoft Access 2010 software. How do you change the color of the command buttons (fore color/back color) and the navigation tabs of a navigation menu in an entire database on a fly (i.e. automatically)? Thank you in advance.

Hello Colin, Thank you for your prompt response. I figured the problem was due to the Navigation form setup. Thanks again.

Hello All, I have setup a Microsoft Access 2010 database with a Switch Board form which has a link to a navigation form which contains all of my forms. The SwitchBoard has a label containing some text; some command buttons and a combo-box which contains the different Language options (English...

Hi Arnelgp, Thank you for the help. It is now working the final code is below: - If MsgBox(strMessage, vbYesNo + vbQuestion) = vbYes Then DoCmd.OpenForm "frmAgencyTypesF", _ DataMode:=acFormAdd, _ Windowmode:=acDialog, _ OpenArgs:=NewData '...

I am getting this error when I add a new item which is not in the list to a combo box:- If MsgBox(strMessage, vbYesNo + vbQuestion) = vbYes Then DoCmd.OpenForm "frmAgencyTypesF", _ DataMode:=acFormAdd, _ Windowmode:=acDialog, _ OpenArgs:=NewData...

Thank you for the feedback. I will avoid using the MVLs.

Hi Everyone, I am working on a MS Access 2013 database. I have a field called "Manual" which contain some values 1,2,3,7, Is it possible for a user to populate this 'Manual" field with different groups of multivalue lists at the same time e.g. the user can choose 1 and 7 or 1,2 or 1,3...