Search results

Hi all. I am not very good with VBA coding and manage to get around most of what I need using wizards and converted macros. However, I have come unstuck slightly with what I am trying to do. I have a form with an unbound field [searchuser]. I then use the following code to open the main form...

Hello everyone! I think I am asking the impossible, but can't think why it can't be done! Here's the dilema: I am working with an unbound form to search a Mobile Register. On the form I have an unbound combo box which looks up User details from a table (LKP_User). When I select a user, I...

Hi All, I am trying to remember how on earth I did this a few years ago - I want to use a combo box to select the current month. Currently, the recordsource comes from a query, but I would also like to add a field at the end (or beginning) of the query recordset (?) I vaguely remember that I...

Hi all, I am looking to export a query (into Excel) and include a field value as part of the filename. Example of what I am trying to achieve: DoCmd.TransferSpreadsheet acExport, 8, "TEMP_SupplierItems", "C:/Data Downloads/EXP_SupplierItems_" & SuppName & ".xls", True, "" DoCmd.Close...