Recent content by Ashank4vba

I'll have to test <my excel application object name here>.Application.DisplayAlerts = False..hopefully this will work..thanks

Thanks Zack and glenn...Didnt realize that the 'Application' object would be different for MS Access and Excel...was happily assuming that VBA objects behaved the same way everywhere..Thanks. Hmm...is there a way that I can permanently set this DisplayAlerts setting to False (maybe from within...

From within MS Access.

Thanks Glenn. However, there seems to be no property called "DisplayAlerts" for the Application object and I get a similar error when I include it in my code. Any other suggestions? Thanks.

Hello, I have a bunch of excel files within a folder of which some are corrupted. The corrupted excel files don't open. I get an error message of the format: <file name here> cannot be accessed. The file may be read-only or you may be trying to access a read-only location. Or , the server the...

Hey Skip, Yes, all workbooks contain many pictures in them. Thats what I am trying to do. I'm trying to read all the data from the 'Inspection Form' Worksheet into an Access table for further processing. However, currently it takes anywhere between 1.5 - 2.5 minutes to process a single excel...

Thanks Skip. I cant think of any other option otherwise. The worksheets contain lots of pictures in them and hence are quite big. I just want to work on their data and thats in the 'Inspection form' worksheet (with no pics in the sheet). So I am thinking of making new workbooks with just the...

Hello, Please help. I have around 800 workbooks in a directory. All of them have a worksheet called 'Inspection Form'. I want to copy just this worksheet to a new workbook and save the workbook. I would like to save each new worksheet to a new workbook separately. I can do this manually but I...

Do we need a connection to just delete a link?

Hello, I have this access database with a couple of tables and queries. For some reason, that I cant exactly pinpoint, sometimes the joins in the queries vanish and access adds 'Expr' aliases for some output fields in those queries. I think I had 'Track Name AutoCorrect Info' unchecked at...

Thanks Roy..I don't have the software or expertise for the other solutions though... Thats a very good idea mhcruella...I will follow it :)..Thanks a lot

Hello, Please advise regarding this situation. There is a back-end Oracle database from which I am planning to save data into an Access database for around 30 considerably big tables (~100,000 records each). The total size of the access database comes to 1.99 GB. I have to save this data...

Hello, Is there a way to create and save a query in an Access database using vba? Also, which is the best way to automatically run a function from access every evening around 7 PM? Form timer? Thanks a lot for your help. -cheers Arvind

<option button name here>.Value works -4146 means that it is not selected! 1 is selected.

Hello, I am trying to load from pictures/images from an excel file into an access table called 'inspection_temp' using the function below. I have 2 fields in that table - Pic_Num(text) and Pic (OLE Object). For each pic in the excel sheet, I am trying a add a new record in the table and copy...