Search results

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

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

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

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

Hi Everyone, I am using Microsoft Access 2013. There is a combo-box in a split-form called "FollowUp" and it contains two values: - "Follow-up 1" and "Follow-up 2". I will like to apply conditional formatting on this combo-box, such that if a user selects the value of "Follow-up 1" from the...

Hello Everyone, I am using Microsoft Access 2013. I am trying to calculate percentages over a period of time in a microsoft access query.

Hi All, I am using MS Access 2010. I am working out each member of staffs working hours for the month in a MS Access query. [WorkDate] [TimeIn] [TimeOut] minus a 1 hour lunch. I would like to display the total hours worked for the month in a hours : minutes format. I tried this...

When the user opens the Orders form he can manually update the 2 controls:- CustomerFirstName (textbox), CustomerLastName (textbox) and he can also select one of the options of the following 3 combo box controls:- CustomerCountry (combo box), TrainerName (combo box), SportsCentreName (combo...

Hello, I have created a frmOrders which contains two subforms - fsubOrderDetails and fsubOrderLink. If I advance forward in the form - frmOrders - from one customer to the next customer, the form do not show the specific order details which relate to the specific customer. Can you assist me...

I am requesting your assistance for some help with my Microsoft Access database relationship structure. I am working for a project for a mining company which has mine sites worldwide. One of the areas of business is insurance, and this insurance is provided to the various mining operations. The...

I reworked my database to place all of the contacts in one table called the "Clients" Table (I was using the approach described by Allen Browne's model http://allenbrowne.com/AppHuman.html). I am experiencing a problem with an invoice report, where I tried different approaches to include the...

I have to prepare invoice statements to send to my clients. I have managed to generate the invoices as a report. However, I want to add two types of mailing addresses to this invoice report: "From" mailing address (my company's mailing address) and a "To" mailing address (the recipient's...

I am new to Microsoft Access and it has been quite a learning experience. I hope to improve my knowledge over time.

I have created a database in microsoft access 2010 to show invoices for different customers in different countries. In doing so, I created using a two subforms in a main form. I have used the "country name" to link the subforms to the main form. When I enter new records into the subforms for a...