I can't make it (Creating sub-report) work using the report design wizard . I got this essage..."You have chosen fields from record sources which the wizard can't connect".
Anyway here are my SQL's which i want to be reported in just one page.
SQL 1
Select DISTINCT CompletionYear, COUNT(*)
From Student
Where CompletionYear in ('2004','2005', '2006','2007')
Group By CompletionYear;
...
Jacko7289
Last Activity: Jan 17 '08, 12:56 AM
Joined: Dec 18 '06
Location:
-
How to make a one report which calls multiple SQL querries
Hi,
It's me again :-)
Just wondering if its possible to create one report using the output of two or more SQL Querries.
Currently i've got two SQL querries. one generates the total number of graduate students for the year (SQLGrad) and the other number of graduate students per course per year (SQLGradcourse) . Now, what i want to happen (if possible) is that once i clicked the report button it will generate in just one page... -
Jacko7289 started a topic How to create a button which closes the current form and then opens a new formin AccessHow to create a button which closes the current form and then opens a new form
Hi,
I've got a form (SearchForm1) which searches the student number using the surname, given name, date of birth. Once the student number is shown i want the user to click a button which will close the search form (SearchForm1) and then open the survey form (SurveyForm1).
In short i want a button which closes the current form (permanently) and opens another form at the same time.
Any suggetions is very much appreciated.
... -
Jacko7289 started a topic How to populate list of Combo box 2 after selecting from a list from combo box 1in AccessHow to populate list of Combo box 2 after selecting from a list from combo box 1
Good Day,
My form has two combo boxes where the list of second combo box is dependent on the data chosen from the first combo box. This is how the table (source of data) looks like...
Table 1: PROD
Prod (PK)
Prod_Desc
Table 2: PROD_CAT
Prod (FK)
Prod_Cat
Prod_Cat_Desc
....the tables has one to many relationship...
Anyway, The first combo box fetches... -
Suggestion still unsuccesfull.Leave a comment:
-
Ouch...Did what's suggested but unfortunately nothing shows up on the new text box or the table column itself.Leave a comment:
-
Load lookup value in form to table
Happy New Year good folks,
Need your expertise on this matter.
I've got an ORDER Table which is populated with data from ORDER Form. In my form, a text box looks up for a value (Base cost) in SPECS table. But this lookup value (Base cost) is not saved or loaded unto the ORDER table.
Is there a way to have this value loaded to my ORDER table?
Thanks -
My apologies for being unclear...anywa y, Its about my order form. This form includes a series of check box for every item and a corresponding text box for the item's price. What i basically want is that when a user selects the item (check the check box) a corresponding amount (hardcoded not from table or any other objects) will be shown on the item price text box and if the user deselects (uncheck the check box) the item price text box should show...Leave a comment:
-
Conditional update on a text box after onclick command from a Clickbox
How can i make a code if i want the following...
1.0 OnClick event, another text box will be updated with value (lets say "thescripts " If the existing value on that text box is zero (0) but if the text box has any value or content it will simply set it to zero(0).
No activity results to display
Leave a comment: