Search results

Thanks, CJ. That is really appreciated. Thanks for your input, Cronk. :-)

Gents, once again, thank you. So, I pretty much just used CJ's code as he had it written and it seems to now be applying the Like as the results are exactly as expected. CJ, would you mind taking a minute to explain how the code you wrote is working and what in my previous code wasn't...

Hi CJ, Cronk Thanks for responding. CJ, the code has always preformed as expected. I have been using it for about 2 years without issue. It groups the data and extracts it to Excel. I will post the rest of the code below to see if that makes more sense. This issue has arisen because I have...

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, " _...

Thanks, Dave. That should be fun :-)

Thanks, Minty. That will help when I get passed the ULS issue. Much appreciated Nik

Update: 40 views and no responses. I'm guessing that Access 2000 is probably a bit old for a support question. I have now asked this question in Mr Excel's Access section. If anyone can point me in the correct direction I'd really appreciate it. Cheers Nik

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...

Thanks for replying. I am new to Access and this is a database that I inherited. From what I can make out, this data is being copied to the 'tblTransactionOpera' table from a linked spreadsheet. A new CustGrp has been added to the data on the spreadsheet and now I am left with the task of...

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.

Quick question... How do I mark this post as solved? Thanks

Thank you all for your input. I went with moving the .visible to the end of the script. It shaved over 2 mins off a 10.30min report and I will be trying the same on some of the larger reports. I was very impressed when I came in this morning and saw all your responses. It is cool to be part of...

Thanks Eugin, I have tried both of those commands but it makes no difference. When Access is exporting the data to Excel I can still see the spreadsheet tabs populating. I was wondering if it was where I am putting the commands. I have tried right at the start and also when the workbook is...

I think I might have posted this question into the wrong board. Please could one of the mods move it to the Modules & VBA section? Thanks

Oh, sorry! I thought my response seemed a little simple. I will leave it to one of the experts next time. Good luck!

Hi TBG, I think you place a ' in front of the line of code you want to ignore. This should cause that step to bypass. Cheers

[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...