Percentage usage? Query just selecting booked slots and then work out %'s on a report
oh ok. I think i sorta understand you on that, I will start working on that asap. Thanx. How far are you witht the project?
Finished the database when i get can my greater than a week less than 2 months for a booking validation to work :|, and then still loads to do for the write up.
When documenting our form designs are we meant to show the object names of everything on the form? Seems pretty useless showing the names of every single label on my forms when none of their captions ever change.
cany some1 clearly explain to me how to do usage statistics thing please???
if any1 has done it, can i see it please??
like irfran said can any help in that area in great detail please. That seems to be the hardest part of this project and help would be much appreciated. Thanx guys :-)
In access how do you customise a standard error message?
p.s dont take A2
can any one please tel me the coding for the show this weeks bookings function extremely confused thank u
come up with how to make it show this weeks startin from today but how do i make it start from saturday?
Right, I've done all the practical work, all the codes etc etc, finished the actual program...now I'm stuck on the testing. I don't have a clue what to write as I've never done this before. I've printed screenshots of my program running and bookings being made etc etc and Validation checks but I don't know what to write for my actual testing and Evaluation.
ANY help will be appreciated (I could also help people who are stuck on the code also)
I am trying to create a query to display all morning slots for mondays, all afternoon slots for mondays etc. all my date formats are dd/mm/yyyy, and dont contain weekday names. Can anybody give me any advice on how to select slots from certain days? i know how to select the slot that i want, but not the day. I understand that you have to use the numeric values for the weekdays, but i have no idea about what to add to my query to do this, and where to add it. i have read through the whole thread but cannot suss it out. Any help would be very much appreciated!!!
Many Thanks, Christina xx
i'm doing the village hall coursework in microsoft access and i have two questions.
1)In the monthly slot usage statistics when i need to calculate the percentage of say monday mornings booked i will need to know how many mondays there are in that particular month. So do i need some code to work out how many mondays there are or do i just pretend that there will always be 5?
2) It says that there will be 2 copies of the bill printed. My bill is a report so what do i need to do to let the user print 2 coppies by just clicking a button?
After analysing the date function on this forum the function ">=DateAdd("d",7,Date()) And <=DateAdd("m",1,Date())"..Thos e it work and were will this code be entered? Would it be in a DATE table or as a querie..am so lost
Wow, i just happened to search for Village Hall CPT3 via Google to see how everyone else is doing with their pieces and looks like this years specification has been causing afew issues. For me though, it hasnt been that taxing, the only complicated and well repetitive issue was actually trolling through all the testing aspects of the code. Such as producing form drafts to help in the actual examination.