Forms and Reports

[shariefoo]

Good morning All,

Anyways here is my problem. I want to create a flexiable form.

Meaning that i want the user to enter the values in a form and then transfer these data to a query and then send it to a report.

Example, i have a table with users full name, fone numbers, DOBs, etc..etc..etc.. I want to create a form that lets a user enter a range of dates like Novembe 10, 1990 till december 10, 1990. And i want a report to show me only the users between those 2 dates .

Help please ?

 

[WayneRyan]

shariefoo,

Do a search on this forum for "Search" and "Search and Form".
You will find some examples.

Wayne

 

[Oldsoftboss]

The Northwind sample Db has an example of this.
Dave

 

[Oldsoftboss]

Cant help myself
Dave

 

[shariefoo]

Oldsoftboss my friend
Thank you 100 times

Man you are truly a king among men..

 

[Oldsoftboss]

And a further extension of the previous zip that now allows you to select a particular month

 

[Oldsoftboss]

Then add the ability to sort by either date or surname.
Dave

 

[shariefoo]

Ok one more Question.

I have a check Box where it lets you to select some feilds like name, age, grade etc..etc..etc..

anyways i want it when a name check box is selected the report prints only the name.

another example is if a user selects name and age check boxes only these 2 feilds will be shown in the report.

Thanx

 

[Oldsoftboss]

I might consider this a work in progress. This example now sorts the "report by month" into a sort order for the days of the month ie:

All the birthdays that are on the 1st, then the 2nd etc - ignoring the year.

(A97 not tested)

Have a Db somewhere that does exactly what you want. Will pick it to bits and repost soon.

Dave

 

[Oldsoftboss]

All I have done is in the Report_Open Event is

If Forms!YourFormName.YourCheckBoxName1 = -1 then
me.labelname1.visible = true
else
me.labelname1.visible = false
end if

If Forms!YourFormName.YourCheckBoxName2 = -1 then
me.labelname2.visible = true
else
me.labelname2.visible = false
end if

repeated the above for each checkbox

Dave

 

[Oldsoftboss]

The next installment to the work in progress.

When you run out of room on your form, use a tab control......

But hide the tabs and give it the look of an Access wizard......

This example automatically selects "Next Month" when you select Report by Month (Usually what you want) and also uses a report in portrait view rather than Landscape if contact details are not required.

Dave