468,544 Members | 1,746 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,544 developers. It's quick & easy.

Form Filtering.

Hi Folks,

I have a form frm.viewbookings which shows in the header the labels Stylist1 through to Stylist 7 with the stylist names underneath them. In total for the set of data I have there are 14stylists. Ok behind all this we have 2 tables tmp_bookingsGrid & tmp_clientGrid.

Also in order to populate the form we run several queries in order to populate these tables with the required data & show the following in the detail section of the form Client_Id_No, Booking_Client_Name, Booking_Client _Address, Booking_Contact_No & Booking_Appoint_Type.

In the form footer we have our command buttons.

The form currently shows all the bookings for a particular date. what I would like to be able to do is show only the bookings for Stylists 1 to 7 on the form & then click on a button & show the next 7 stylists with the bookings for these 7 stylists.

I'm not quite sure how to go about this. If ya need anymore details (code etc)let me know. also instead of nothing showing if there is no appointments at a certain time I would like a blank row to appear in that slot/slots that is/are missing
May 25 '07 #1
5 1412
MMcCarthy
14,534 Expert Mod 8TB
Have a look at the following tutorial.

Example Filtering on a Form
May 26 '07 #2
puppydogbuddy
1,923 Expert 1GB
You should also take a look at this 3rd party tool which costs less than $20:

It is a form builder that enables you to select the features (including filtering) you want on the form and will build the form for you.

http://www.aadconsulting.com/smtfrmplus.html
May 26 '07 #3
Cheers for your help. Now have the form filtering nicely to show the records I want. Any idea how I would put in a blank row for the appointment times that have no bookings.

Eg On the filtered form showing the 1st 7 stylists I have appointments at 1.30pm,2.00pm,3.00pm,3.30pm,4.00pm &4.30pm. I need to put in a blank row for 2.30pm.

Any ideas or articles/tutorials you can point me to would be great
May 29 '07 #4
MMcCarthy
14,534 Expert Mod 8TB
Cheers for your help. Now have the form filtering nicely to show the records I want. Any idea how I would put in a blank row for the appointment times that have no bookings.

Eg On the filtered form showing the 1st 7 stylists I have appointments at 1.30pm,2.00pm,3.00pm,3.30pm,4.00pm &4.30pm. I need to put in a blank row for 2.30pm.

Any ideas or articles/tutorials you can point me to would be great
You will need to create a table of all the available times. Then left join that table to the table/query behind the subform so that all times show on the subform.
May 29 '07 #5
Thanks I'll try that
May 29 '07 #6

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

1 post views Thread by Robert Neville | last post: by
reply views Thread by CSDunn | last post: by
reply views Thread by Lyn | last post: by
1 post views Thread by UniDue | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.