Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: SteveCop2
  • Content: Threads
  • Order by date
  1. SteveCop2

    Printing a complicated report for every month of a year

    I have devised a report which gives the following type of information for a single month: ACCOUNTS OPENED John Smith Richard Jones ACCOUNTS CLOSED Jim Arnold TOTAL OPEN AT END OF MONTH: 37 The data all comes from a single table and is presented using 3 sub reports, each fed with a suitable...
  2. SteveCop2

    Incorrect Maths

    Access is giving me strange results for perfectly straightforward calculations. For example, try the following in the Immediate window of VBA: 1108.91 - 306.38 - 802.53 The answer should be 0 (or 0.00) but is actually 1.13686837721616E-13 (which in non-scientific display is 0.000000000000114...
  3. SteveCop2

    Compact and Repair causes problems

    I have a large Access system (Office 2003, Windows XP Pro) which comprises the main program file with all forms, queries, reports and VBA and then 4 data files which share the 50+ tables feeding the system each table being linked into the prog file. I experience unpredicatble problems when doing...
  4. SteveCop2

    Excel Chart failing to redraw

    I have a number of Excel files which are populated by data exported from Access. One of the files is behaving most oddly! It's charts have data tables on them and the data tables show different figures from the source data. Opening the file for the first time this month, I see that the data...

Part and Inventory Search

Back
Top