Search results

Hi All, I have given an ACCESS ADP Project, which gets committed in SQL Server tables. However, I don't see the connection string nor a provider in the code. But, when I run the code putting a debug point, and open the immediate window I add the '?CurrentProject.Connection.ConnectionString'...

Hi All, I am not able to save a file after processing, I am not able to see the dialog window being opened, to enter a name for the file to be saved. I am getting an error, error is attached, and am pasting the code for the section below. The code which breaks, is mentioned in red...

Hi Gina, I have resolved the issue, by doing nothing in the coding nor adding a library. How I resolved is, by simply installing the service pack 2 for the MS Office suite 2010. Gina - By the way, is there a way, I could mention or change status RESOLVED. BY the way, I will open...

Hi Gina, Tried xlsx, and resulted the same 1004 error, the code breaks in the same place where I have mentioned in red font. Thanks, Antonio

HI Gina, Original code was as you mentioned, yes the below, which still works fine for ms office 2007, and able to accept xlsm files. .ConnectionString = "Data Source='" & filename & "'; " & "Extended Properties='Excel 8.0;HDR=Yes;IMEX=1' The problem arose, when I started to work in...

Hi Gina, Provider=Microsoft.ACE.OLEDB.12.0;Data Source=c:\myFolder\myExcel2007file.xlsm; Extended Properties="Excel 12.0 Macro;HDR=YES"; resulted the same. But Many many thanks Gina, on your continuous help, and am sure, getting close in resolving this. Thanks, Antonio

Hi Gina, ACCDB Thanks, Antonio

Hi Gina, I have removed the multidimension, and it had not given any joy for me, you know what, when I tried to load the xls file, it was successful in loading. the issue it has is loading xlsm files, and just now I tried loading xlsx files, that would not load either. It does seem...

Hi Gina, Will do, can you help me, take a backup, cause I reckon the backup is not equal to copy paste of the access file. Thanks, Antonio

Hi Gina, Tried and the results are the same, do I have to uncheck repair, and then check again to see the errors. I have done both the ways errors are the same. Thanks, Antonio

Hi Gina, Which files are you asking for, please see attached for the libraries checked in. Thanks, Antonio

Hi All, Please see the error image too attached, file name - 1004.PNG, let me know how to show this error as a screenshot, so that I need not have to put in as an attachment, Thanks, Antonio

Hi Gina, Explanation below, please note that this code is working well, in the 32 bit, and yet it was well working for the 64 bit, when the creator was MS office 2013, now I have changed to Ms office 2010 for the 64 BIT, and the code is breaking in the font that I have mentioned in red...

Hi Mark, How can I place a screenshot, am trying to paste the error message. Thanks, Antonio

Option Compare Database Option Explicit Public Sub XlfileImportTestNew() Dim rs As New ADODB.Recordset Dim conn As New ADODB.Connection Dim cmd As New ADODB.Command Dim filename As String Dim rsIn As DAO.Recordset Dim db As Database Dim xlApp As Excel.Application Dim xlBook As Excel.Workbook...

Hi All, The code is breaking when it is trying to open the code, above mentioned in the title. x64 ms office suite, the same code works for the x32. Note : code had been tweaked well and truly, with the change that required, declare ptrsafe for the x64. Please shoot in all your...

Hi VbaInet, The message box works for the beside mentioned, MsgBox Shell("cmd /k " & strCommandLine, vbMaximizedFocus), but not for the below MsgBox Shell("cmd /k " & strCommandLine, vbMaximizedFocus), when I put In the code, it is giving an error for the second parameter, which is...

Hi Gina, The Ptrsafe, does not seem like working, the MSDN came in handy for my future reference, not at this moment. Please shoot in your findings. Thanks, Antonio

Hi vba, It returns a process id I guess, I tried twice the times in running the code, and both the times it returned with some numbers under the message boxes. First time it was 1516, and the second time it was 536. However, both the times, before popping up with the messages, it...

Hi Gina, Very wise information, valuable information, now I get the point that even after installing the windows 32 BIT, there is a way of finding it, whether you could do a install of 64 BIT, provided you format it, by going through the regedit. However this is not what I currently...