Search results for query: *

Hi all, Is it possible to have a drop down list box or combo box so that I can select a colour to fill a text box background? I know I can use conditional formatting to do this but, wanted to know if this is possible Many thanks, KP

Hi I am looking for a way to stop lazy staff from closing a form before they have entered all data I want a message box to appear warning them to fill in this text box(s) and that the form will not close until its done. I have made the form a modal form. In this way the database will be useless...

Hi all, Don't know if this is the correct place for this one. Is it possible to disable custom menus. I don't want some of them accessed by staff. What I have been doing is to remove them from the menu and giving some staff a different front end. But it would be easier to hide or make them...

Hi In a query I have three options to select companies, ie: "C" (Companies) "P" (Private clients) "S" for (Suppliers). On the criteria line how do I just select companies and private clients. I know that I can enter "C" which will select companies etc, but to be able to select both at the same...

Hi all, I would like to be able to have a date that when a certain date is reached, it makes a text box become visible. The reason for this is to be able to put a flag on staff when a renewal of qualifications is due, or is there some other method of doing this? Many thanks KP

Hi all On a form I have a text box which I am able to open a form by this code; "DoCmd.Openform "form42", , , "acctno=" & "'" & Me.AcctNo & "'" The acctno selects an account so all records can be viewed. I would like to be able to use a make table query so that just the records from a Acctno...

Hi all Need some advice with this please. I use a form with a texbox (AcctNo)This text Boxes data has specific code ie: 4-1000. When I dbl click on this text box it opens a other form to show specific data relating to that code. Inititally I set the Data type to long integer and the code used...

Hi I would like to be able to print specific fields on a report by using a check box. On a form I want to select certain text boxes with a check box and for only those selected boxes to print on a report. Could I have some help with this please. KP

HI I need some professional advice on a relationship. I have three tables, broker table staff table and a client table. The staff relationship will be a one to many, as a staff member can have many clients. However a client can have many brokers and a broker can have many clients. For example...

Hi I have another question I have a report which has a group header (Lastname) In this I have a subform (continous) which has members super contributions. There is a total in the form footer which only gives a total when a certain amount is reached ie: SuperT...

Hi Does Access provide a means to put scroll bars on reports. I would find it easier that having to use the record selector at the bottom. KP

Hi, I have a text box (Gross) which is (currency) showing totals. There is also a combo box which holds tax data in currency. What I would like to do is when the tex box(Gross) has focus then the combo box will drop down and match the data in the text box So far I have this; On the 'textbox' (on...

Hi Would appreciate some help with this please. I have a continuous form in which I use a check box via conditional formating to change the background of text boxes. This highlights the record so that the user can see that this record has been edited. I would like to be able to reset all the...

Hi all, I need to be able to make a command button on a main form become invisible from a check box on a sub form. I have tried different option without success. I know how to make a command button invisible ie:button.visible = true/false etc. But to get this to work once the checkbox on the...

Hi all, I have a form which has a sub form inserted. I want a user to be able to input data to just 4 records only. The reason for this is that the sub form provides data for an invoice for extra items. Is needs to be limited because the invoice report has to have a lot of medical data. So that...

Hi all, I have a text box that when it has a certain text in it that other text boxes will change background. I did try this, but not very successful If textbox 1 = "paid" then textbox2.background = 256 ( or other colour) else textbox2.background = 0 end if. How can I get this to...

Hi, i want to be able to open a query by using the 'On dbl Click'event on a form. The command I have used is this: DoCmd.OpenQuery "Accounts_1_StoreOS", , , , "RecordID=" & Me.RecordID As a test If I use:DoCmd.Openform "Accounts_1", , , , "RecordID=" & Me.RecordID it will open a form. Is it...

Hi all, I have 2 append queries which rely on an ID to be inserted into the criteria of the query. I have a command button on a form which uses the on click event to action both of these append queries. However the criteria I need to use is the insertion of an ID in the query. But I need to...

Hi all, I have a continuous form where a field (AmmtRcvd) is the amount received. I also have a chkbox which when checked shows that the amount has been received. I would like to when the chkbox is checked to add up all the Amounts received. Ken

Hi all, I use the code below to preview a report; DoCmd.DoMenuItem acFormBar, acRecordsMenu, 5, , acMenuVer70 DoCmd.DoMenuItem acFormBar, acRecordsMenu, acSaveRecord, , acMenuVer70 Dim strDocName As String Dim strWhere As String strDocName = "Report32" strWhere =...