Creating a report from imported data

Tech-Archive recommends: Speed Up your PC by fixing your registry

Hi all,

New to access programming. I'm using access 2003.


I'm programatically importing a FoxPro/Dbase table which I've managed to do
and I'll eventually want to report some findings to an access report.

However, in the interim, I need some help as to how I would programatically
retreive those findings and what commands I should study up on to retrieve
that data.

I need to

1. Get the field (column) names
2. Get the field size
3. The size of the longest record in each field
4. The number of populated fields in each field
5. The value (text) of the longest record in each field

6. The number of fields
7. The number of records

I guess what I really need is a good primer.


.

Relevant Pages

  • Re: Probably an easy question for an expert :)
    ... Therefore, it comes very strong in the find data, display data, report data ... start with Access then move up to SQL server, ... > programming is not my job but I'd like to make the job easier so my basic ...
    (microsoft.public.access.gettingstarted)
  • Re: RFC: Database Report Generator
    ... > not require a deep understanding of programming. ... of language to "link in" to allow transforming incoming data. ... "" if the output is to be HTML. ... > that the report becomes a script, rather than a datafile read by the ...
    (comp.os.linux.development.apps)
  • Re: On Error Resume Next
    ... > Resume Next is 'lazy' programming. ... >> about all reporting because all cleint reporting was done in Excel. ... >> client report that had been being run for about 6 months was calculating ... >> This is only my oppinion based on what I have learned and experienced ...
    (microsoft.public.excel.programming)
  • Re: Printing "3-up" records on a preprinted form
    ... It's fairly easy programming to et Access to calculate the height of each section: subtract double the margin + a spacer for each detail less one from the page height. ... We have _lots_ of reports which will need to use one of three variations on the footer event procedure ... I would prefer to be able to have a function or macro for each section count variation once in the database,, instead of once for each report. ... Print a page with 3 evenly spaced mailing slips ...
    (microsoft.public.access.reports)
  • Re: Dynamic Report
    ... report, then open the report in, what, IE, and cause it to be printed there? ... one of the steps necessary is to have it dynamically select a font size ... programming I provide to Word to perform the task. ... those templates to the sections of the text. ...
    (microsoft.public.access.reports)