Search results for query: *

Many thanks KP

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 Remou Many thanks for your reply.You gave a hint on how I should arrange my menus. I separated them so now I can select menus individually. kp

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

TheAceMan1, AGain thanks for your post. I have tried this code and it works fantastic. I do appreciate all your help. Amazing! Thankyou. KP

Hi the Aceman1 Many thanks for your reply. Ive been interstate here for the week, so only have manged to read your post. I will do as you have suggetsed on Monday and let you know how it goes. Going to the exact dollar is excellent. Many thanks for your help. Noew Ive gotsome work to do. 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 PHV, Many thanks for your reply. Yes the combo box is bound to a text box (currency) on the form. Yes the bound column is to insert the tax amount. I have to go away for a few days, but will get to this on the week end. I do appreciate all the help you guys give. I wish I was more...

Hi PHV, I just designed a form and added it via the sub form. I have it linked using the Child/ Master fields. It works ok. Gives all the info that is entered via a form Basically I have an invoice form and use a sub form to enter some invoicing data. I just used the same design for the...

Hi the Aceman1 According to tax tables it can be either. I have posted a part of the tax tables from the tax department. When we use the PAYG system it does not matter as long as we are in the range. As most will get a refund at the end of the financial year. 450 12.00 452 12.00 454 12.00 456...

Hi TheAceman1 Yes that is correct. The gross Amt is in one field and the amount to be allocated in another field. The table has been constructed as follows: Plus a Primary Key Gross(field) tax(field) $400 $16 $450 $18 $500 $20 The Tables go...

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 Aceman1 Yes these are gross ranges. eg The min gross before tax = $380.00. I have the gross ranges in a table with the appropriate tax range. ie: Gross = $450.00 Tax = $ 20.00 I wanted to be able to select the gross range and then insert the Tax amount into the form so that is...

Hi all, Yes this is a difficult one. The ATO here only provides formuals for tax! No one produces a tax table such as one for MYOB. So I have created a script that enables the tax tables to be inserted into access. So when the gross amount is calculated I wanted the tax amount to be entered via...