Search results

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

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...

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

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

Hi, I am looking for a way to ensure the date entered into a field is not in the past. I guess its a validation rule but am not quite sure how to go about it. Any advice? Thanks

I have this code snippet that extracts on the file name from a string. It does this by removing everything left of the first "\" (working from right to left). Dim I As Integer For I = Len(FullName) To 1 Step -1 If Mid(FullName, I, 1) = "\" Then ExtractName =...

I have a snippet of code thats meant to make a new folder within an Images folder which is located in the database workspace, but for some reason (I'm not quite sure why) it doesn't seem to work. Could someone please help me out :) Dim strProjectPath As String Dim strImageFolder As String...

Hi, I have some code to open a browse window and insert the file path & name into a control. Is there a way of using the same code for different instances of the browse i.e. from different buttons with different controls. Essentially, I need there to be 6 sets of button and text controls...

Is it possible to have a query that returns results that match some critera and that doesnt match others? For example, a property rentals database search that matches the results of the "Bedrooms" field but not the "Date" field. So the results are ones that are not marked as booked for the...

How do I activate a word mail merge document in VBA and email it to the correct address. I need to be able to click "confirm" and have it send a confirmation email to the client automatically. I already have the mail merge document, which is based on a query. Any help would be greatly...

Im designing a database booking system for properties. I have a find unmatched query that works with a form and allows you to enter a date and return results that do not have a booking entry for that day. However, how do I get it to take duration of rental into account? i.e. return properties...