AQA computing CPT3 Village hall coursework Watch

Swinely
Badges: 2
Rep:
?
#361
Report 12 years ago
#361
Percentage usage? Query just selecting booked slots and then work out %'s on a report
0
quote
reply
manutd2k
Badges: 0
#362
Report 12 years ago
#362
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?
0
quote
reply
Swinely
Badges: 2
Rep:
?
#363
Report 12 years ago
#363
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.
0
quote
reply
m00c0w06
Badges: 0
Rep:
?
#364
Report 12 years ago
#364
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.
0
quote
reply
irfan121
Badges: 0
#365
Report 12 years ago
#365
cany some1 clearly explain to me how to do usage statistics thing please???
if any1 has done it, can i see it please??

Thanx
0
quote
reply
Swinely
Badges: 2
Rep:
?
#366
Report 12 years ago
#366
(Original post by m00c0w06)
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.
Where did you get that idea from??? If we had to i would have probably just thrown my computer out of the window, i don't think this coursework write up could get any more patronising really... that would just about top it off.
0
quote
reply
manutd2k
Badges: 0
#367
Report 12 years ago
#367
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 :-)
0
quote
reply
Alamothih
Badges: 0
Rep:
?
#368
Report 12 years ago
#368
Hey, just finished hte actual system, onto write up. so if ya want any help add me
0
quote
reply
philip67
Badges: 10
Rep:
?
#369
Report 12 years ago
#369
In access how do you customise a standard error message?

p.s dont take A2
0
quote
reply
Daaannniii
Badges: 0
#370
Report 12 years ago
#370
can any one please tel me the coding for the show this weeks bookings function extremely confused thank u
0
quote
reply
Daaannniii
Badges: 0
#371
Report 12 years ago
#371
(Original post by Alamothih)
Hey, just finished hte actual system, onto write up. so if ya want any help add me
heya can u tell me teh coding in vb for the show this weeks bookings
0
quote
reply
Skorn
Badges: 0
#372
Report 12 years ago
#372
If this is against the rules, then please ignore it, but I have been having trouble trying to get my regular bookings to work, so I have simplyfied it a lot. I won't be able to do all that is required, but I decided to cut my losses after working on it for such a long time (3-4 months!). Anyway, I came up with this, but it really doesn't like it:

Code:
Dim i As Integer
    Dim strSQL As String
    Dim dteBookDate As Date
    Dim dteNewBookDate As Date
    dteBookDate = Me.Booking_Date

For i = 1 To 52
    dteNewBookDate = DateAdd("ww", i, dteBookDate)
        strSQL = "INSERT INTO table (tblBooking) VALUES(#"
        strSQL = strSQL & dteNewBookDate & "#);"
    CurrentDb.Execute strSQL
Next i
When I press a button, I want it to book the same day each week for the next 52 weeks, but it doesn't want to work! I am using Microsoft Access btw.
0
quote
reply
Daaannniii
Badges: 0
#373
Report 12 years ago
#373
come up with how to make it show this weeks startin from today but how do i make it start from saturday?
0
quote
reply
Craigy__06
Badges: 0
#374
Report 12 years ago
#374
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)
0
quote
reply
Craigy__06
Badges: 0
#375
Report 12 years ago
#375
(Original post by Daaannniii)
heya can u tell me teh coding in vb for the show this weeks bookings
You mean 'Add Bookings' or the 'Weekly Bookings'?
0
quote
reply
HearTheThunder
Badges: 14
Rep:
?
#376
Report 12 years ago
#376
(Original post by Daaannniii)
heya can u tell me teh coding in vb for the show this weeks bookings
Aren't you practically asking them to do your coursework for you?
0
quote
reply
Rent
Badges: 0
#377
Report 12 years ago
#377
Hi,

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
0
quote
reply
Furniture
Badges: 0
#378
Report 12 years ago
#378
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?
0
quote
reply
manutd2k
Badges: 0
#379
Report 12 years ago
#379
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
0
quote
reply
michaelbenson
Badges: 2
Rep:
?
#380
Report 12 years ago
#380
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.
0
quote
reply
X

Quick Reply

Attached files
Write a reply...
Reply
new posts
Latest
My Feed

See more of what you like on
The Student Room

You can personalise what you see on TSR. Tell us a little about yourself to get started.

Personalise

University open days

  • University of Buckingham
    Psychology Taster Tutorial Undergraduate
    Fri, 14 Dec '18
  • University of Lincoln
    Mini Open Day at the Brayford Campus Undergraduate
    Wed, 19 Dec '18
  • University of East Anglia
    UEA Mini Open Day Undergraduate
    Fri, 4 Jan '19

Were you ever put in isolation at school?

Yes (134)
27.29%
No (357)
72.71%

Watched Threads

View All