Search results

Hi Please see the attached image of my error message. I am trying to write a new ID to a table in SQL Server. The ID has been generated by my VBA and I can verify that it is not duplicating another existing ID Any ID why I might be getting this error? Thanks, Mark

Hi, How do I populate 2 columns to the listbox with the AddItem function? This is what I have been doing. I know that it prob has something to do with the list item but I haven't been able to crack it. lstProjects.AddItem (rs.Fields("ProjectID")) lstProjects.AddItem...

Thanks Your help is much appreciated! Mark

Hi, I have a table called Strategic Programmes which has 2 columns "ProgNo" (unique ID) and "ProgName" I need to connect to SQL Server from Access using connection and recordset objects to find the next highest "ProgNo" What is the SQL query I need to execute to find the next highest ID...

Thanks You're a life saver! Mark

Hi, I was trying to change the form that appeared on Load by going to Tools>Startup and changing the settings there. However now I have lost most my my menu bar i.e. Edit, View, Tools etc. I only have File, Window and Help. :eek: How do I retrieve the menu bar in its original state? Thanks...