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

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

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 All, Thanks for reading my post, I have to first of all mention that I have developed an application using VBA Access, and then converted into an ACCDE file. System resources of the workstaion which did develop the ACCDE. Operating System - Windows 7 / Service Pack 1/ 32 bit Microsoft...

Hi Everyone, Good Morning to everyone, I would like to get an idea whether an ACCDE file would read another ACCDE file. The reason I am asking in regards to the later versions we produce on an application. For instance am going to put an application into production, by now and am sure that...

Hi folks, Good Morning to everyone, would you please help me in prepating an installer for the mdb or the applicatioin that I have created using VBA Access. Basically, what I wanted to do is to create a folder in the name of 'Main' under the C:/ Drive, and copy ceratin excel files into that...

G'day G'day everybody, Please be noted that I am unable to print the progress bar of the syscmd, I have tried checning the progressbar too under the startup. When I put a debug point, it goes to that area and loops through it, by printing it in the immediate window, debug.print. I have even...

Hi folks, Good evening everyone, thank you for reading my post, I would like to ask how am I suppose to change the form name in the forms in VBA access, now see I would not want to change the names by using the coding. Please note that I have got so many forms, however I have worked with the...

Hi Folks, I have a form, which is comprised of a sub form, and some of the text box controls sided with a button, and the event had been written to the button. Now, to give a note on how had the sub form had been created is firstly taking a clone of the ‘Payments’ table and using it as a...

Hi Folks, Please be good enough to help me in the below code, as I am getting to go into the MsgBox, as it should not, after if it should goto End If. If Mid(fileName, InStrRev(fileName, "\") + 1, 5) = "Fixed" Or Mid(fileName, InStrRev(fileName, "\") + 1, 6) <> "Mobile" Then MsgBox...

Hi Folks, Good evening, I am able to get the output as onefile, after being fetching all the necessary data from the access table to the excel sheet I wanted. Bottomline : My requirement had been working fine. But, suddenly I have been asked to save the outcome as 2 files depending on the...

Hi Everyone, Good Afternoon to you, I would like to get some help on one occasion, see now I have got 3 forms, and at the time of running, I want to make one primarily one form to be showing up and the other 2 to be hidden or closed, and the primary form will have 2 buttons, and clickning...

Hi Folks, Good Moning to you all, how would I save the file, to the destination that I want to, in essence at the time of saving the save dilaog window only should open. I am getting other windows, as I am passing the file as .xlt file. Thanks, Antonio

Hi Folks, A very good day to everyone, I am trying to post some coding into the current forum, and would you guys be able to tell me on how am I able to do it as a screenshot which has the Horizontal and Vertical Scroll bars. It makes my colleagues readability v.high. Thanks, Antonio