Hi I am not an advanced user of access but i know my way around a little and learning more as i go. Thanks to Microsofts Newsgroups. My latest problem is....

Hi I have a field called "Carer Availability". This field is a combo box and displays either "Has a carer" (Value = 1) or "Has No Carer" (Value = 2). ...

Hi In my client table i have a field called suburb. This field looks up the suburb table to get its values. In the Suburb table i have a suburb field and...

Hi On my reports form I have a command button that when you click it, it loads a reportform on the criteria in my combo boxed. I have pasted the code...

Hi I am wondering if you can put the folllowing code into the control source of a field. =if(-0,0,-) What i am wanting i if the Persons average is lower...

I have form with Bowlers ID, Bowlers, Name and Avg Points field. On a sub form it shows all the tournaments the bowler has competed in and at the bottom...

I have a Date field that is updated when a record is changed and works good. What i need is when staff save the form i need a pop up box for staff to enter...

I have a continous form that has three fields, ITEMS, AMOUNT, PAID BY The only two options available in the PAID BY field are CASH and EFTPOS. In the footer...

My company i work for runs a market day once a month. People have to ring up and register with the business and then they are registered for the market...

Hi I have my main form (Active Clients) and on it i have various subforms. I have a save button that when clicks it refereshs a list box and disableds...

Hi Currently I have a form where staff members can search for clients. It shows Surname, First and Phone. It also has the client ID and Active Status of...

Hi On the side of my form i have a list box and when you click on the client names it brings there details up. Only problem i have is that if two people have...

Hi I have a form that displays a picture from a file. and changes to suit the dvd title i am viewing. Some of my dvds i dont have a picture and wish no...

Hi I have a client form that has a list box down the side. When you select a name in the list box it updates the fields to show that clients details. What i...

Hi I currently have a search textbox and that on exit of the field is updates my list to what was typed in the field. This is what i have at the...

I have a form where i have made all fields Locked and have set enabled to No. So that staff can only search clients and view there data, without mistakenly...

Hi All on my main page to my database i have a command button that opens a second form based on a staff member selected in the combo box. Currently if they...

Hi Query No 2 On my clients for i have a search box which filters a list box below it, according to text entered. What i want the list box to show is active...

Hi I have a tick box on the clients form that gets ticked if they cease using our service. What i require is that once they click the save command button...

Hi I have a form with a Tab control on it with various sub forms on each tab. Each page of the Tab box has been enable set to no. So that users can view...