|
|
Sub Form by
Andrew C
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....
|
August 17th, 2004 11:59 AM
by AlCamp
|
1 |
77 |
|
|
Fields to be Filled in by
Andrew C
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). ...
|
|
7 |
130 |
|
|
Display Field by
Andrew C
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...
|
|
3 |
70 |
|
|
Picture Report by
Andrew C
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...
|
|
2 |
53 |
|
|
IF Function by
Andrew C
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...
|
|
7 |
77 |
|
|
Update Avg Field by
Andrew C
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...
|
|
1 |
131 |
|
|
Updated By by
Andrew C
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...
|
|
1 |
111 |
|
|
Sum to get total by
Andrew C
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...
|
|
2 |
67 |
|
|
No Duplicates by
Andrew C
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...
|
|
2 |
98 |
|
|
Required Fields on Subforms by
Andrew C
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...
|
|
1 |
138 |
|
|
Searching by
Andrew C
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...
|
|
2 |
150 |
|
|
List Box by
Andrew C
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...
|
|
6 |
140 |
|
|
Pictures by
Andrew C
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...
|
|
1 |
87 |
|
|
Filtering a List Box by
Andrew C
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...
|
|
8 |
97 |
|
|
Search Box by
Andrew C
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...
|
|
2 |
61 |
|
|
Enable Fields by
Andrew C
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...
|
|
3 |
79 |
|
|
Slection Needed by
Andrew C
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...
|
February 25th, 2007 12:46 PM
by Andrew C
|
2 |
43 |
|
|
List Updates by
Andrew C
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...
|
February 25th, 2007 02:08 PM
by SteveS
|
1 |
50 |
|
|
Changing Values by
Andrew C
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...
|
February 25th, 2007 02:05 PM
by Daniel
|
1 |
51 |
|
|
Edit Form by
Andrew C
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...
|
|
1 |
91 |