Search results

Thank you so much for all your help dbDamo. Once I put your code at the top, and removed the cancel as integer, it worked exactly as expected. Now I can add my other bits and pieces for make it a custom job. :p:D:)

Hi There isn't really a save button. There is an exit button, which has a pile of code against it. I'm re-working someone elses DB, and there are no save buttons throughout the entire thing. I'm guessing they would be useful.

No - I'll give that a go.

Yes - with your code. I guess I must have something else that is making it close.

Hi DBDamo The 'Please fill the details field' comes up as expected, but as soon as I click the OK button, the form closes with no warnings at at all. It doesn't focus back to the field.

Hi Everyone Thanks for all of the suggestions - they all work, but no matter what I do, once the 'warning' appears and I press the 'OK' button, it just closes out of the form. I would like it to go back to the empty field - I understand this is to do with the setfocus feature.

I'm back again! I have three mandatory fields. I have some code against the Before_Update part of the form, and while the msgboxes are appearing, when I click on the OK, rather than making the user go back to complete the field, the form closes. Can someone tell me what I'm doing wrong? I...

Thanks vbaInet. After a bit of mucking around, I did get it to go with the help of the skeleton you posted. I ended up with:

Hi vbaInet I'm not sure how to do an inner Block.

Hi I'm hoping someone can help me with this. I'm doing some additions to a database at work that someone else made, and it's mostly going well. What I'm stuck with is code to get one of three forms to open depending on the field values in two other fields. Here's the code I have so far...

Thanks Poppa Smurf! That did the trick - it wasn't as difficult as I thought it would be. :)

Hi I've been working with Access 2003 for a while, but am not so good on the code side of things. This is the code I want to alter: Private Sub cmdEdit_Click() Dim stDocName As String Dim strFilter As String Dim stLinkCriteria As String stDocName = "frm_Results" strFilter = "Number= '" &...