Search results

  1. C

    Question Simplest way to produce Excel spreadsheets from forms(acc 97)

    Many years ago I created a database to generate end of month reports in Access 97. 7 separate queries filtered the information from 2 large tables and placed it into 7 separate forms. Each form then had totals calculated on it within the forms code: e.g. Table Field: "Gross income" Client1: 20...
  2. C

    Pass string from Access 97 to Word?

    A few days ago I got some help creating a string so that a database would get its own residing directory to look for a word document I wanted to merge. It worked beautifully..... until I needed to move the entire content of the directory to another PC. The Access part still works perfectly -...
  3. C

    Mailmerge Word problem in VBA with change of location/machine.

    On a database run on a server system the following code was given to me to make a mailmerge word document open and print... If Me![TerrorCover] = True Then DoCmd.SetWarnings False Dim objword As Word.Document DoCmd.OpenQuery "MaketblTerror", acNormal Set objword =...
  4. C

    Accessing Public variables

    Not sure if this is the right place to post this or not - if it's in the wrong place please let me know and I'll shift it! Basic problem... In a forms class module some calculations are made, the result of one of which is then passed to a publically declared variable in the modules header...
  5. C

    globally running a rounding code

    Hi all, New here and reasonably new to coding so please excuse any errors! I've been doing some searching and reading here as a result of a problem I have in an Access 97 database. Basically it's all based around money, figures and calculations. Lots and lots of them, only access doesn't seem...
Back
Top Bottom