Search results

Perfect thank you, I didn't realise that a list box would contain column 0 as default or that I was setting it to a string value! Thanks for the help guys I learnt more than I thought I would!!!

Hello, I currently have a list box that filters though a list of records on the main form using a text box. I have got the search function working, and the list box filters correctly, the problem I am having is that I need to be able to double click the record and have that record show on the...

SOLVED Instead of deleting sheets withing the workbook, I deleted the workbook and had it create a new one every time, this ensured there was no overlap of data and it could be exported straight away. I also added a portion to open my mail merge document from word: Private Sub...

Thanks for the quick reply... I like the idea of deleting the worksheet so that I can get it reopened, I am attempting to do this by using this code: Dim xlApp As Excel.Application Set xlApp = New Excel.Application With xlApp .Visible = True...

I am currently working on a form that exports a query that changes after a user set filter is applied, and am able to get the filter to apply and the query to export. The problem I am having is that the worksheet that the query is copied into retains all previous data, and if the earlier query...

I will try not to, beginners mistake I guess :) I'm not able to post the link yet but as soon as I have 10 posts I shall come back here and post it :)

SOLVED! I have been able to solve this problem, and for future browsing purposes I will send the link, even though it is not to this website I think it will be valuable to somebody someday! Using this process I was able to create a "dynamic" query, the SQL that decides this is changed...

Ah, if you are on the main form and wish to access the filter form click on the "Filter All" button! It doesn't need to be exported to the mail merge template I have sent you per se, if we could get the filtered sub form to an excel sheet it would be just as useful as an automatic mail merge...

Sorry about the delay, was out of the office most of yesterday! I have attached the database and label template (I used bookmarks for the mail merge, but I get the feeling that this is not the most efficient way of doing it. The form/subform in question is the filterform, due to the nature of...

I am able to do a mail merge, however the filter that I have applied to the subform does not carry over onto the mail merge, so all addresses are sent to mail merge, filtered AND unfiltered!

Hello! I have been searching the internet and racking my brain, but I am fairly new to VB coding so I might just be being really stupid and I am truly sorry if this has been asked and answered before, but I did a search and couldn't find much that related to my problem... I have a form with...