Zac Harvey
Last Activity: Jun 11 '12, 08:43 AM
Joined: Mar 31 '11
Location: Manchester, UK
-
Ahh I didn't check the record source of yours. Thanks, I'll take a look. Other than that though it should all be the same as I exported the module and query and checked my relationships were the same. -
Ok I took a look around at the changes you've made and after making sense of what you'd done I implimented it in my origional db. There were a couple of minor problems which I sorted:
- When attempting to delete the medical record it came up with Error 2046: The command 'DeleteRecord' isn't available now. So I got rid of the delete command and used a delete action query instead. This solved the problem.
- Also a warning box was coming
Leave a comment:
- When attempting to delete the medical record it came up with Error 2046: The command 'DeleteRecord' isn't available now. So I got rid of the delete command and used a delete action query instead. This solved the problem.
-
Thanks a lot dsatino. I'll take a look in the morning (GMT) I don't have access on my home PC.Leave a comment:
-
Form showing up blank
Hi all
Having had such great help from you guys in the past I'm hoping that someone could shed some light on this issue I've been unable to solve.
I have diluted my database down to the objects nescessary to establish the problem which I believe is a relationship/key issue. For your information though, the relationship should be one-to-one.
From the StudentInfo form you can open up the MedicalForm for... -
No problem, I get it. Much appreciated as always Neo.Leave a comment:
-
Thanks for replying Neo, Hope you enjoyed the extended weekend. Sorry about the seperate posts above, I will bear this in mind in future posts.
I have taken your advice and changed the action to 'Cancel = True'.
The date function in question can be found under Forms > frmBookings if you still intended on taking a look.
Also I have realised another major problem with this date business. Because I usea pop-up...Leave a comment:
-
On my booking form I have a field which records the date for which a room is being booked and it is a mandatory field. I simply wanted to ensure that the user could not enter a date which preceeded the date on which it was being entered i.e. Date()
Now one thing to point out is that whenever I try and include Date() in an If function it removes the brackets then when it checks it says it cannot find the date field. So I've tried putting...Leave a comment:
-
Well the reason for that Is that I supplied my datbase in the previous thread and therefore thought it would be easier for someone to just look at that rather than me posting the code etc. But nevermind, I will do that now. Makes sense since you've moved it to a new thread anyway.Leave a comment:
-
Okay, no problem. I wasn't assuming you'd look. I didn't want you to inspect the code or anything just have a little try of it and see what you thought. But it's no worry. Thanks again Neo and Smiley.Leave a comment:
-
Date Validation
Ok, so my other little problem. I can't seem to get a working validation on the BookingDate field of frmBookings. I've tried everything immaginable and even though a lot of them worked they also came up with extra message boxes which I hadn't set. So not quite sure what to do with that. Any ideas?
** Edit **
This new question was split from Time Interval Overlapping (MS Access 2003).Last edited by NeoPa; Apr 20 '11, 09:29 PM. Reason: Added link to originating thread. Please ask only one question per thread. -
Ok, so first problem is on my form which is used to ammend booking details after they have been made. There is a search facility on the form allowing the user to find bookings records easily. However when they enter a search string that doesn't exist the form is returned completely blank and can't be closed. I will attatch it so you can actually try it for yourself rather than show you by pictures.
[*EDIT*] I have solved the above problem....Leave a comment:
-
Thanks a lot guys, your help has been most appreciated. I shall give mention to the website and yourselves for all the help. I'm almost there, but I've still a few glitches to iron out. I'm hoping you can still find the time to take a look at these. They will follow on from this post.Leave a comment:
-
Ok here's my revised code. It seems to do the job. I know my code is likely not the best writen and ordered but as I mentioned origionaly I am still pretty new to Access programming.
...Code:'If form is dirty, before going to new record check current Private Sub cmdSave_Click() If Me.Dirty Then Dim strWhere As String, strMsg As String With Me strWhere = "(([StartTime]<#%S#)Leave a comment:
-
Oops, my mistake.
Run-time error "3021":
No current recordLeave a comment:
-
Ah.. maybe not. Cos that would defeat the point right? As you are using the move methods to actually make the count? Thats what I understand from your annotations Smiley.Leave a comment:
-
Aha, this possibly seems to answer my question regarding the error.
http://allenbrowne.com/ser-29.html - Point 3
So the Move methods should come after the if statement? (If rsDao.RecordCou nt = 0 Then)Leave a comment:
-
Another question: Is the following piece of code meant to be returning all the overlapping bookings in the msg? Because it doesn't seem to be doing so.
...Code:Do While Not rsDao.EOF 'Do until we reach the eof, (End Of File) strMsg = strMsg & vbNewLine & "%D between [%S] and [%E] by '%B'" strMsg = Replace(strMsg, "%D", Format(rsDao!BookingDate,Leave a comment:
-
lol Smiley... "Booked for SEX by SEXMACHINE"? :P I'll have you know that we will not tollerate behavior like that in our workplace.
So I have just tried it out, and the there seems to be a slight problem. It works great if there is actually an overlap, but it wont save a record that doesnt have an overlap? I've attatched a img of the error and emboldened below the highlited code in debug.
...Code:'Move to
Leave a comment:
-
hmm I see, might not be worth the time tbh then. I'm hoping to wrap this up asap. But see what you think anyway. Much appreciated....Leave a comment:
-
Oh and another thought, I did a little testing and it gave me the idea to show all room bookings for the room that the user is trying to book on that day.
E.g. If the Large Traning Room had already been booked on a day between 9:00-12:00 and 14:00-16:00. The user tried to book for 11:00-15:00. Message box displays "This room has already been booked between 9:00-12:00 and 14:00-16:00. Is this possible? I'm gona go see if I can make...Leave a comment:
No activity results to display
Leave a comment: