Search results

  1. 2

    undefined function 'replace' in expression

    Thank you. Originally, I have the following checked: Visual Basic for applications Microsoft Access 10.0 object library IAS Helper COM component 1.0 Type libaryry IAS RADIUS Protocol 1.0 type library Acrobat Access 3.0 Type library AcroIEHelper 1.0 Type Library The first two are needed all...
  2. 2

    undefined function 'replace' in expression

    I just began to use Access 2003, SP3. I got error message: undefined function 'replace' in expression when I run a existing Macro. I remembered when I first using Access, it was 2002 and I got similar error message. I fixed it by checking off the missing lib. But this time, I opened the VB...
  3. 2

    How to export the report to Excel and keep the same layout?

    I’m using Access 2002. I can generate a nice report in Access, with color background for the header and each section. But when I export the report to Excel, (or analyze with Excel), the nice format are lost in Excel file. Each section’s header is moved to the first few columns and no color...
Back
Top Bottom