Search results

Hi Gina, As I mentioned the version of windows that I want to check in is the windows 7 64 BIT, MS Office Access 2013 64 BIT. What you have mentioned is not being the case, as I am checking for the 64 BIT, and in the meantime, nevertheless gave a try with yours, does not come...

Hi All, Good morning to everyone, I am here to post an issue which I worked a bit and killed a time in trying solving the problem, yet have no joy till now. I am trying to work on with my tool, which is the launcher for the main application, have got 2 main applications, one for 32 and...

Hi Gina, Yes it worked in that way, putting a specification on it's own, the options text qualifier and the separator came in really handy. Thanks, Antonio Manoj

Hi All, Good morning to all, I am facing an issue while working on VBA Access. I am trying to load a csv file by coding, which is DoCmd.TransferText acImportDelim, "", "tblTempPayments", newFilename, False One field which I have declared as Text, some rows for the fields are numeric...

Hi All, Please be noted I have developed an application using VBA Access, I have got 2 versions and, one for 32 BIT and the other for 64 BIT. Both versions work successfully, and I have got no issues. I have written a separate MACRO / CODE, to open the application on it's own, what...

Hi JHB, Thanks for your reply, you know, I was not able to view it, until you mentioned it that there is something. But I enforced a delay, by calling the sleep method. Finally I was able to witness, with the clearer and lengthier view. unfortunately this is not what I want, a...

'this is my progress bar, coding I am able to see the code is working 'when I put a bullet point 'issue is the progress bar is not visualizing Option Compare Database Option Explicit Public Sub ProgressMeter100() Dim MyDB As DAO.Database, MyTable As DAO.Recordset Dim Count As Long...

Hi Eugin, The code works in saving towards files in the workstation, I am v.happy to say that, I from nowhere (the click events were not working - I was able to debug and go forth strength by strength in, rectifying all the issues and make it a success. one thing I want to mention is about...

I am having the same issue, can someone save me, the code goes through without throwing any error, but the save dialog window does not prompt. Other comments were useful, but not at this instance, as I am trying to save, but not to file pick and load.

Hi Eugin, Many thanks in all of your updates, would you please help me in saving excel files, into the workstation. (after comparing 2 tables) The reason I ask is because, the methodology which I had applied in the 32 BIT, does not like for the 64 BIT applications. Thanks, Antonio

Hi Eugin, Thanks for your instant reply, have a little questions on what you have answered, in going forward in accomplishing the task. Please note that first of all this works in the creator workstation being Windows 7 x32 | MS ACCESS x32 SP3, and in answering your question, Excel does not...

Hi Eugene, Commencing from the below, I have to mention that the code is breaking at the point when it reaches this stage, had been mentioned in bold for your easier reference 'xlBook.Close' Set xlApp = CreateObject("Excel.Application") Set xlBook = xlApp.Workbooks.Open(filename) Set...

as per to the above mentioned steps you have mentioned, I was able to do one after the other, I would say half joy only, please see points as below mentioned. 1. Go to the First computer and compile the file as an ACCDE, then give a copy. answer : I was able to open it as an accdb, and then...

thanks very much my friend, was out of office, sorry for the late reply, will go through it.

Hi Guys, G'day guys, I have prepared an ACCDB file in MS Access 2007, and when I tired to save it as MDB for the Access 2000 saving format, it is saving as an MDB, however it is is giving an error as 'You cannot create a xxxxxxxxxxxxxxxxx ADE or MDE file from a database saved in 2000 format'...

Many thanks for the input, learning from GURU's like you fill in the gap analysis.

Thanks Eugin, Your inputs came in really handy, and on your reply at the below section ---------------------------------------------------------------------------------------------- Or 1. Go to the First computer and compile the file as an ACCDE, then give a copy. 2. Save the file as an...

Hi All, G'day to you all, I would like to know, and get confirmed in asking, do I need to have MS Access installed, in order to open an ACCDE file. Why I have this eye catching concern is, in my view I see, that there is no need, as I see ACCDE as an exe file. Thanks, Antonio

Hi, the tip above did not helped me, can someone gimme a hand in overcoming this issue. Thanks, Antonio

Hi Shutzy, Thanks for the response, am gonna convert this as an ACCDR, and see whether this would work regardless of the OS platform, and the MS Office version. Fingers crossed. Thanks, Antonio