Hi,
Am struggling a little bit with this today.Some help would be gratefully Welcome
I have a table Salonmanagerdet ail which has the following fields
Mananger_Id Pk Autonumber
Stylist_Id Number
SM_Dates Date/time
SM_Phrase Text
This information is entered via a form Salonmanagerdet ail & allows the salon receptionist to enter details of when a stylist is Salon...
glamster7
Last Activity: Oct 27 '09, 10:57 AM
Joined: May 10 '07
Location:
-
If its possibly could I have a copy of this as well. email addy is Email address removed per site rules! -
Thanks for your input Nic --- thing is we have all the forms done & everything is working well (ok not all of it but most). The Salon Manager & filling in the correct amount of boxes based on the appointment duration are the last two real functional things we want to include before we let this db "go live"
I have found it hard to explain how it all works (my supervisor has done some of this work) . Think I'll have...Leave a comment:
-
Just recalled why we were thinking of going down the "Salon Manager " in each slot route. This was because at a later date we were thinking of using background colours to indicate progress of an appointment i.e green-arrived, amber - in Salon & red - completed...Leave a comment:
-
Hi Nic --- storing "Salon Manager in the view bookings subform was just the way I was thinking of doing it. Am open to any way of showing a stylist as "Salon Manager" - giving the column a different background would work (I could also later adapt/use that to include stylists "On holiday"
As for the grid for a variable number of employees. some additional information --- we know the maximum size of a group...Leave a comment:
-
Cheers for the reply Nic,
I'll see if I can explain this better. The form stylistmanagerd etail allows a member of staff to enter the dates a stylist is assigned as Salon Manager. This data is then stored in the table Salonmanagerdet ail. A stylist may be Salon Mamager more than once in hte acemic year. I have a query SalonMan which pulls out all the Stylists with SM_Date = todays date. for these vaules I wish to populate my view...Leave a comment:
-
just bumping this as i'd like to solve this soonLeave a comment:
-
Modules
Am looking to create a module or make this part of my ShowDetails module (Code posted in another thread) If it needs reposting let me know.
What I need is to create a module of some code in a module that looks at the Booking_Appoint _Duration in the bookings table & then fills the correct number of appointment slots with the show details data in the view bookings sub form.
E.g
If Booking_Apoint_ Duration... -
Was looking at expanding the statement at line 10 of the code & was looking at trying something like below. I am not sure if this would work -- I think I also need to declare SM_Dates etc.
If IsNull(BookingN umber) Then
If SM_Dates = date Then
ShowDetails = "SALON MANAGER"
End If
Exit Function
End If
Any help would be appreciated as this is one of...Leave a comment:
-
Form/Query/Module Problem
Ok folks its Friday & I'm feeling a bit thick (also not very well).
I have a form Salonmanagerdet ail wich allows the user to enter the following details Stylist_Id,Styl ist_Name,Group_ Name & SM_Dates. SM_Dates are the dates a stylist is designated Salon Manager for (This happens every x weeks).
This data is stored in the table Salonmanagerdet ail. Users can view this data via the View Stylist form which is a... -
Have been trying to figure this out -- I'm thinking that perhaps it may be possible to add some code to this function which shows the details of the bookings on the view bookings sub form. I think I would also have to declare the field Salonmanagerdet ail.SM_Dates as well
...Code:Option Compare Database Function ShowDetails(BookingNumber) On Error GoTo err_tag Dim cSQL As String, DEBUGTrueorFalse As Boolean
Leave a comment:
-
Using Information in Query & Table to populate a form
Ok
I hope I can explain this properly. I am designing a hairdressing booking system database in a college environment. The thing I'm trying to do at the momemnt I'm a little lost with
I have a form which allows the receptionist to enter a Stylist_Id, Stylist_Name,Gr oup_Name & SM_Date (this being the date the student is Salon Manager). This data is then stored in the Salonmanager table.
What I am looking... -
Ok Scott thought I'd best let you know what we've done. after talking to my supervisor & manager we are going down the route of using the link you gave me to Allene Brownes Findasutype procedure -they like the functionality of that.
The reason behind that is knowing the department thats using this database it covers all options of search criteria & filters they may decide they need in the future. Have it in & its working...Leave a comment:
-
Ok Scott - forgot the caps lock was so my apologies there - had it on for some data entry on something. Am looking at another job at the moment but will let ya know how i go...Leave a comment:
-
WHAT ABOUT THE SYNTAX OF THE SELECT STATEMENT SCOTT - ANY THING NEED CHANGING IN THAT...Leave a comment:
-
...Code:Private Sub Command53_Click() 'Dim strClientIdNo As String 'Dim strSearch As String Dim MySQL As String If IsNull(Me![Text54]) Or (Me![Text54]) = "" Then MsgBox "Please enter a value!", vbOKOnly, "Invalid Search Criterion!" Me![Text54].SetFocus Exit Sub End If MySQL = "Select [ClientLeave a comment:
-
cheers Scott will give this a go later...Leave a comment:
-
Ok have just had a go at this .Have the following code
...Code:Dim MySQL As String If IsNull(Me![Text54]) Or (Me![Text54]) = "" Then MsgBox "Please enter a value!", vbOKOnly, "Invalid Search Criterion!" Me![Text54].SetFocus Exit Sub End If MySQL = "Select [Client Details].Client_Surname Where [Client_Surname] =" & Me.[Text54]Leave a comment:
-
Cheers Scott
Will have a look at that later -- am currently looking at something but will get back to this...Leave a comment:
-
Thanks for your help - although having had a quick look at them they are maybe a bit to complex for what we need. I did manage to change my code to search for client surname & that was ok except it only picked up the first record. If I could adapt that to pick up all of the records with that surname it would probably do the jobLeave a comment:
No activity results to display
Leave a comment: