Recent content by adambedford

Never mind. Answered my own question now. It was as simple as [Enddate] < [StartDate] and an If statement

I have a form that has a field called StartDate and a field called EndDate. How to I validate that the value entered in EndDate is after that of StartDate? Thanks

perfect, thanks!

Hi, I have this code: DoCmd.SelectObject acTable, , True DoCmd.RunCommand acCmdWindowHide DoCmd.SelectObject acTable, , True DoCmd.SelectObject acForm, Me.Name to show and hide the Access database window/navigation pane... Is there a way to incorporate both pieces of code into one...

I am still getting error messages. Could someone point out where I'm going wrong? Private Sub Form_Current() Dim strImgFrame As Variant Dim strImgPath As Variant Dim strErrMsg As Variant Dim paramstring1 As String Dim paramstring2 As String Dim paramstring3 As String Dim LoopCount...

Is there a way of validating the value of a text box to ensure the date is a Saturday and if it isnt, to bring up an error message. Alternatively, is there a way of making all the days apart from saturday not-clickable in an ActiveX calendar control? Thanks

Hi, Thanks...its coming together now! I get another error now though and I think its because I am trying to set the property of a variable in the same way as a control. For example, can I have "Variable.Visible = True"? I know I can have "ControlName.Visible = True", but that is different...

I have tried something...but I get the error "Can't Assign to Array". Why do I get this? Here is the code I've written - there are three arrays, one for each type of control (ImageFrame, ImagePath, ErrorMessage) The form OnCurrent is meant to loop through the array until it reaches 6, but...

Hi, I still havent had much luck with this... I tried ajetrumpets example, but I think I must have gone wrong somewhere becuase one time it didn't do anything and the second time it made Access crash. I currently have a bookings table and a customers table and a query that combines field...

Perfect, thanks!! I won't bother with the the st, nd, th, rd...like you said, it's really not woth it! Thanks very much for the help.

Thanks, thats excellent! Is there a way it can be formatted to read "25th April 2009"...so in long date format?

I have a villa booking database and am trying to produce a report to document what villas where rented when. How would I go about producing a report that has 52 squares across (one for each week of the year) and that if the property was booked that week it gets filled a certain colour and if...

Is there a way to calculate the date of the upcoming saturday. For example, if I opened my report on Thrusday 23rd, it would say Saturday 25th automatically in a label. Thanks

I can't get my head around how to get certain snippets of code to work with more than one control. Im thinking I might need a complete restructuring of the code...but I don't know how! Firstly there is this code that runs when the form starts up that checks for relative paths and also checks...

Perfect, thanks!