Search results

Hi All, I have a query which I want to run as many times as there are unique values in a field within a table in the same database. My query is set to look at a field on a form, but I would like to run this macro for all unique values in the table of which there are approximately 2,000! My...

Hi all, I have a query which has a field in it which returns a staff members name. I need a separate field which based on who it is that is named, will return either a specific text such as "New Sale" or a blank result if it is a different member of staff that is not listed in the criteria...

Hi all, Is it possible, just like you would do on a mail merge in Word, to have a report that is predominantly text, but that has inserts which refers to the results of a query. For example, a query may return the result of a persons name and address, and I would need this to form part of...

Hi all, Here is what I want to do, I just need a code to help me do it! Close an open and active access database (DB1) Open another database (DB2) Close DB2 Open DB1 It sounds simple enough but I just cant work out how to do it! Many thanks in advance

Hi all, Last year I developed an access module that allowed me to open, refresh connections, save and close an excel file. I need to do the same again, with almost identical projects / workbooks, so thought it would be a simple case of copying and pasting the old access file, renaming it and...

Hi Everyone, I am a "copy and paste" with a bit of tinkering VBA user and have pinched a very useful piece of code to help with a program I have designed but I am hitting a snag that I really hope someone can help with. The below code allows me to open and excel document, refresh the...