Search results

That is fab Thanks

I would more often than not want to set the 1st Date & the 2nd Date to be the Start & the End of the previous month. Is this possible?

I am using a calendar function which contains the same code as this thread in the dbx.zip download. What I would like to do is automatically make the calendar open on the previous month (i.e so if it gets opened now, I want it to show July) Is this possible? Regards Carly

That works a treat - Thanks

Sorry I lied, the message only seems to happen the once, if you change the dates whilst still in the form and they are still wrong the message doesn't appear again

This works fine now, but as i'm a novice I don't understand why. what is booFlag?

But I want it to show a message box and then set the focus on the incorrect date, like the example: Private Sub Detail_MouseMove(Button As Integer, Shift As Integer, X As Single, Y As Single) If Me.txt2ndDate <= Me.txt1stDate Then MsgBox ("You have entered an invalid 2nd date")...

I have got this to work by using the following code: Private Sub Detail_MouseMove(Button As Integer, Shift As Integer, X As Single, Y As Single) If Me.txt2ndDate < Me.txt1stDate Then MsgBox ("You have entered an invalid 2nd date") Me.txt2ndDate.SetFocus End If End Sub...

This is the actual code I am using: Private Sub txt2ndDate_AfterUpdate() If Me.txt2ndDate < Me.txt1stDate Then MsgBox ("Must Enter Date which is after 1st Date") End If

I have a form which has 2 dates fields ([txt1stDate] & [txt2ndDate] which are populated by me picking a date out of a calendar pop up. What I would like to do is have a message box pop up if the [txt2ndDate] is before [txt1stDate]. I have tried me.txt2ndDate.value < me.txt1stDate.value...

Thanks that works exactly how I wanted it to Cheers Carly

I have got a 20+ page report which is sorted on Cost Centre and I would like to start a new page when it gets to a different Cost Centre. I noticed the following on another post: Open report in design view and right click in the detail area. Select 'Sorting ang grouping'. Group header = YES...

I have got a form with 3 fields that need something entering into them. What I want to do is when the form in closed check whether the 3rd field has been changed, If it hasn't I want it to force them to enter a value. Is there a way this can be done? Regards Carly

I have a form which updates a table but some of the textboxes have Dlookup functions in them and these do not update. For example, I enter the Cost Centre and a Part Number. This then looks up the part number in another table and enters the description and UOM automatically. But... When I...

I knew that was going to be the answer I would get. But even though I know that I shouldn't do it, is there no way that it can be done?

Is there any way in which I can protect certain columns in a table? I am opening a table and I want the end user to amend the last column but I don't want them to amend any of the other columns. (They need to see these columns for reference). Regards Carly

I think this now works but just to be awkward, it there anything I can put into the code to put the form back to normal straight away, for testing purposes as now when I go back in to test it the button is always invisible. i.e. Like a option, click OK to put it back to it's original state (all...

When I add these codes the button1 is always invisible when I open the form, I never get a chance to click the button first. Do I copy exactly what you have typed other than changing button1 for my button name?

I assume with this example that the user would have to be closing the form the same amount of times, but I will never know how many times they would want to. They may finish Stage 1 to Stage 7 in one day - 1 week, but the next week they may need 2 days to do the same job. This is why I need it...

I don't want the change to be permanent as when they get to stage 7 for example I want all the fields to be visible again for them to start the whole process again.