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...

Morning all, this is just a shameless bump as I'm still having problems. Thanks

I have tried the suggestions from the document in this thread: http://www.access-programmers.co.uk/forums/showthread.php?t=161713 But the issue remains - combobox generates the list straightaway but clicking in the list makes Access hang/freeze for approx. 1 minute and then displays the...

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...

Thanks Rabbie. Found another alternative actually: rs.FindFirst "[Surname]='" & Replace(Me!Searchbox, "'", "''") & "'" But I've implemented yours as it is slightly shorter code and makes more sense to me :D

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...