Search results

  1. C

    Very Strange VBA Problem

    Thank you both to Anakardian and JHB. Your advice is appreciated. I have discovered the cause of the problem. When I declared a function I used a "$" character in the function name: Function FixString$(s) <--- doesn't work When I removed the $ from the function name everything works...
  2. C

    Very Strange VBA Problem

    I am running Access 2007. I have an .mdb database, and it works fine. BUT, I am unable to make any change whatsoever to the VBA code without causing an error when I try to open the database. For example, I view the code for Form_frmMenu. Inside a function, on a blank line, I enter the code...
  3. C

    Export Form to Text File

    Good question. The two databases were originally the same. But I decided to experiment with some enhancements to the frmMenu form in one of the databases. Then I realized I misplaced some of the notes I made along the way. Now I would like to see exactly what changes/enhancements I made...
  4. C

    Export Form to Text File

    While I was waiting for a reply I did a Google search and found that I could export a form by going into the VBE Editor, opening the immediate window, and executing the following line. SaveAsText acForm, "frmMenu", "C:\frmMenu.txt" This will export the complete form definition: controls...
  5. C

    Export Form to Text File

    Hello, I have two separate .mdb databases. Each contains a form named "frmMenu". I would like to compare these two forms. Specifically, I would like to compare everything about them - the controls, their properties, and the VBA code. Ideally, I could export each form to a text file and use...
  6. C

    Testing Recordset for No Records

    Hello, It seems there are various ways to test a newly opened recordset for no records. But wouldn't this be the simplest and most foolproof? If Not (rs.BOF And rs.EOF) Then ... Thanks.
  7. C

    When is the "OpenDatabase" Method Needed?

    Thank you for explaining the need for the Close method.
  8. C

    When is the "OpenDatabase" Method Needed?

    Thank you, Galaxiom and pbaldy, for your answers and sample code. They are greatly appreciated.
  9. C

    When is the "OpenDatabase" Method Needed?

    Hello, I am quite new to both Microsoft Access and VBA. I am using Access 2007. I have been asked to write some simple VBA code to be used inside an existing .mdb database. I will be using DAO. My question is very simple. If I want to open a recordset, is the following code sufficient...
View older results
Back
Top Bottom