Search results

Hi all. I created a db for someone in work, so closed it down so they couldn't edit it. Evidently, they have googled how to open it holding down shift. They have changed something and now I can't get the File/Edit/Tools menu back. I need to change the form that is loaded on startup. How do...

Hi. I have a form that pulls back info from an sql database -a picture, name, etc. I setup a combobox that lists all the surnames and the user can find the user in that list and clikc and it loads. However, it takes ages to load the record and often hangs the program. But if I use...

Hi all. in Access 2003 I have a linked View from a sql database, which I then use on a form. I have made changes to the View but these are not replicated on the Access view. Is there a way of automatically relinking the View on Form Load/Open? VBA code would be best but suppose I could use a...

hi all. I have a searchbox which pulls from a sql database a list of surnames, when clicked, it then populates the forms below. It works fine except on names that have an apostrophe, such as O'Connor I then get this message "Access error syntax error (missing operator) in expression" Here is...