Recent content by oxidus5886

Hi thanks for your help so far guys! The error appears when I click on a particular button, the code for the button is displayed below: Private Sub Command260_Click() If Me.Dirty Then Me.Dirty = False On Error GoTo Err_AddCarNextButton1_Click Dim stDocName As String Dim...

Hi thanks for your reply, I am a complete noob, didnt even know you could do that. I have attached the compacted version of the 2007 database. By the way just as a point of interest, what is it exactly that compact and repair does? Does it affect the code or the data in any way? Thanks...

Hi everyone, Im having a problem with an error on my database as follows: "The table 'Cars' is already opened exclusively by another user, or it is already open through the user interface and cannot be manipulated programmatically." The error appears when I try to move from form "Add Car...

Hi thanks for your input SOS. The issue is what the end result needs to be, I will clarify. The end result is to be a wizard type system using a series of forms one after the other. Each form allows the user to input more information but only for the one record the user has been working on...

Thanks for the help namliam! Ok, have looked up the help for that specific msgbox command, didnt even know you could get specific help by selecting and F1. :D. I got rid of all of the Gotos. I have this and it still doesn't work, could somebody steer me in the right direction again please...

Hi, This is my first post and I am really really new to coding in VB so youll have to bear with me. I am trying to create a form in access which has a close button which closes the form. I have tried to design the form as data entry only, so all record navigation has been removed from the...