Search results

Hi all I have a like statement in my VBA that is not returning all the possible results. There are 3 segments AMS, AMS Red & AMS Blue but the code below is only returning values for AMS. Any help really appreciated! Set rst = dbs.OpenRecordset("SELECT tblSummaryValues.MonthEndDate, " _...

Hi all I have inherited an Access 2000 database and now everyone in the office is on access 2013 I had to convert the old database to 2013. Everything seems to be working as expected but I have an issue with people using it that are not assigned to the user-level security tables in the old...

Hi Guys, I am hoping someone can look at the code below and tell my why I am getting this error? I have added and the respective ) to the code and now I am getting this error. Thanks for your help.

[SOLVED]Application.ScreenUpdating... Hi all, I have inherited a Access database that exports data to Excel. It uses a combination of sql and VBA to produce the reports in Excel. I want to try and speed up some of the exports as they are quite large and can take a while to complete. I have...

Hi all, I just changed jobs at work and my new role is to provide my team with reports from Access. The database has various data streams imported to it and combined in Access to provide and overall position. I am new to Access and VBA, though I have a little bit of experience with creating...