Search results

I receive spreadsheets from various sources (via email). Once received and opened I use VBA to add a timestamp to the xls file name and then want to save them all to the same folder location on the server using a network address ... for example "X:\central\excel". I run this from a workstation...

I am using Access 365. I have a query which can be used with a large number of tables, each table being named TABLE plus a number. I don’t want to duplicate the query multiple times with a different table name. Is it possible to have an input box which opens when the query is run to ask for the...

I am not very experienced in using VBA (I mostly copy what has been done before). I have an Access365 database which does my accounts and creates a REPORT which is an invoice. Then to email the invoice I click on the email icon in my quick access toolbar and I have a blank email (in OUTLOOK)...

I am using Access 365. I have a report listing transactions, grouped on different offices. Each group starts on a new page via the "force new page before section" property setting for the group header. The group header contains the labels for the headings for the data fields in the detail. The...

I have a text box in a report in Access 2013. The database was in Access 2010 and worked fine, and now I have upgraded to Access 2013. The text box has in it ="Report from "&(Format([startdate]),"dd mmmm yyyy")) & " to " & (Format([enddate]),"dd mmmm yyyy")) the data source is based on a...

I am not an expert with Access, but I have a database of members of a club in Access 2003. To edit a single record I based it on a query which uses a field with the condition Like "*" & [input name and surname] & "*" to find the record to be edited. It works fine. I am now making a new database...