Recent content by AlGreko

Hi Is it possible to express a a sharepoint web address as a file path for a database to use to find some source data? Currently the database uses a path (C:\ESD\Temp) to extract a downloaded source database to another folder on the c: drive. Rather than download the zip file, I would like...

Hi I'm really new to using the modules and VBA in access so would appreciate some really step by step guidance. I have used a TransferSpreadsheet macro to import data from spreadsheet. However it does not go as far as I would like. The database will be used by others, and I would like...

Thanks for the reply Mihail, but could you tell me where/how to use that expression in the query design, I pasted it in but it says the expression has the wrong number of arguments. I'm new to this

Thanks for the reply. Sorry if it was not clear, that was just an example, they are not actually called Name1, Name2 etc. There are several fields with text and numbers, all with different titles. I would like to make several tables from several different queries, and eventually join these...

Hi, I was wondering if someone could provide some help. I have a make-table query based on fields from another query. I would also like this new table to include a new number field which starts at 101 and counts up for each entry. So currently looks like this: Name1, Name2, Name3 A, B, C...