Search results

  1. A

    VBA Access Compatability issue

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

    ACCDE file to read another ACCDE

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

    Preparing an Installer

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

    Progress Bar not showing up

    Hi gemma-the-husky / JHB and all, @JHB - yes I have checked the display status bar and still it does not work, before posting the first post itself it had been checked and not working. @gemma-the-husky - No.of records had been 50000, and I have tried the using the SysCmd acSysCmdRemoveMeter...
  5. A

    Progress Bar not showing up

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

    Changing the Form Name in VBA Access

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

    Clear sub form at the time of opening the main form

    I have not pasted the code, here you go Private Sub BtnSearch_Click() Dim strSQL As String Dim db As Database Dim qDef As QueryDef Set db = CurrentDb() Set qDef = db.QueryDefs("qry_btn_search_payments") If IsNull(Me.txtInvoiceNumber) And IsNull(Me.txtPremiseCode) Then MsgBox "You need to...
  8. A

    Clear sub form at the time of opening the main form

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

    Or Operator giving problem, in VBA ACCESS

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

    Multiple forms, and making one form primary

    awsome, working fine thanks.
  11. A

    VBA Access SaveAS

    Yes I have removed it.
  12. A

    Saving as 2 excel files from one file

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

    VBA Access SaveAS

    Hey JHB, Seem like working fine, thank you for that, except for one occasion, where I had to close the excel template as well, once I have saved my own file at my liking. Thanks, Antonio
  14. A

    Multiple forms, and making one form primary

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

    VBA Access SaveAS

    Hi JHB, Thank you for the response, would you please send me the whole set of coding, cause when I try to save it, it pops us with the dialog box, and it does not allow me to select the .xls from the drop down, as the all files is fixed. Would you please help me to save it as an excel file...
  16. A

    VBA Access SaveAS

    Set xlApp = CreateObject("Excel.Application") Set xlbook = xlApp.Workbooks.Open(templatefile) Set xlWrksht = xlbook.Sheets("Already Paid") Set rsIn = CurrentDb().OpenRecordset("Mobile") Set rsIn = CurrentDb().OpenRecordset("Mobile") If rsIn.RecordCount > 0 Then...
  17. A

    VBA Access SaveAS

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

    Posting on forum as a Screenshot with Horizontal & Vertical bars

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

    VBA Access Code EOF does not stop, when records are over

    Hi Catalina & Cronk, Thank you for your speedy inputs, I would check are there any values in the excel. In the meantime would you be able to help on the same coding, where I just want to pinpoint into the excel sheet mentioning forcefuly to start reading from the 10th row of the excel...
  20. A

    VBA Access Code EOF does not stop, when records are over

    While Not rs.EOF ' rsIn.AddNew For i = 0 To rs.Fields.Count - 1 ' rsIn.Fields(i + 1) = rs.Fields(i) Debug.Print rs.Fields(i) Next i ' rsIn.update rs.MoveNext Wend Above...
Back
Top Bottom