Search results

Nope. I don't understand it....as I said I'm not a programmer.....I'll give it a go through and see what the outcome is.....might need some hand holding :o

Thank you That's exactly the sort of thing I was after....you're a star! :D Jo

Yes I have because otherwise I don't know how to circumvent the system error messages. Any suggestions will be gratefully received :) My primary reason for using Access is because I don't have Visual Basic....hence I can use VBA as a substitute. I don't want bound forms and I don't want...

Thanks Thanks for all your help. I think I would rather code the actions....I'm more comfortable with code as it's all in the one place so I can easily find where I have gone wrong. Perhaps I'm mad....I don't know. Anyway I've sorted the original query so thankyou.

I guess so :( If I fix this will my coding be easier or will I have to completely recode the entire application again? I'm not keen on completely recoding just now as I have a Christmas deadline to meet and can iron out the design issues at a later date.

The form is unbound because it references many tables and queries...also because I don't want any data saved to tables unless the user clicks the button. It was the easiest way I could find to do it and it seems to work very well, even if my code is verbose which I'm trying to deal with here...

Getting there OK so I've managed to follow the suggestion above and it's working quite well. However...I get an error that the fields could not be added to the query before I get my custom error message. How can I circumvent the system error message about the query not being able to run...

Oops perhaps more explanation required The form is unbound so the data won't be saved until the button is pressed, hence bad data is not a problem. I'll try making them required in the table and see if that helps. How do I still display the error message if I adopt this solution? Is it just...

Hello :) Does anyone know of a tidier way to write this or is this ok? ElseIf IsNull(Me.txtResponsiblePerson) Then MsgBox "You must complete all relevant fields to continue", vbOKOnly, "Error" ElseIf IsNull(Me.txtEmailAddress) Then MsgBox "You must complete all relevant fields to continue"...

I've got it! I figured this out now :)

Hopefully this is simple but I am quite new to Access... I have a combo box that populates two text boxes on my form. This is working great; however I now want to have the option of entering data into my text box and have the corresponding record show in the combo box. So....cboProgrammeName...

exact code DoCmd.SetWarnings False This works in Access 2002 Jo :)

Tried this and it didn't work Me again! I've added this code directly under Private Sub cboProgrammeName_AfterUpdate() and it's still not working so clearing the screen didn't help. How can I easily unlock the table to use it again without closing the DB? 'clear any data currently on the...

Hi I really hope you guys can help me with this one. I have a form with 2 cascading combo boxes on it. cboProgrammeName feeds cboProjectName and the following text boxes: txtProgrammeManager txtProgrammeID cboProgrammeName gets it's data from QRYProgrammeData (I need to filter the data to...