Search results

  1. M

    Forms from crosstab queries

    Creating forms from crosstabs. The forms will overlap the columns and not display totals. Only have a maximum of 31 columns. Will only go to 15 or so then overlap and not allow the form to be expanded. Would like to have column totals also. Why and how please. Thanks.
  2. M

    ODBC Connection String

    I have attempted to use connection string code to create ODBC link to a common financial application, but no luck. ie Driver not found or syntax incorrect etc, etc . I have followed Microsoft's and other sites instructions to no avail,but if someone has an example of a working connection I would...
  3. M

    Form Design

    How to incorporate access pivot tables in an access form? Also how to subtotal on changes withinin a field in a form?
  4. M

    Defaults in queries, forms

    How can I set Month or Year default as per the system date. ie Only select records by Month (October) or Year (2013) as per system date?
  5. M

    Field parse

    How to split a field in an Access table where the Date and Time are included? ie dd/mm/yyyy hh:mm::ss AM/PM, split to 1.date 2 Time 3 AM/PM. The solution would be perfect if in conjunction with a query using this field. Thanks for any help.
  6. M

    Marco

    G'day everyone. I just joined this forum and look forward to exchanging ideas. I live in Australia and hobbies include all sports, travelling and wine. My background is Senior Management, esp Finance and IT. I am no expert programmer but have led many large IT projects. I hope to be in touch...
Back
Top Bottom