Results 1 to 3 of 3
  1. #1
    Join Date
    Aug 2008
    Posts
    1

    Unanswered: Several problems for my Access project

    One button to change one field of all of the reports
    Got a lot of reports that are needed to print out monthly (click one by one)
    There is a text field in each of the report which is needed to be changed from time to time (same for all of the reports)
    Is there any method so that a box can pop out and ask for that field’s data and then update all of the reports?


    Making the report more readable
    I have got a report with tabular form to show all the records. However, there are two fields with lots of data in the Remarks field.
    Is it possible to make the whole row to change its size according to the amount of data? (the other rows are small)


    Multi-Query
    I have built a multi-query which involves a lot of fields. There are bugs in this MQ though.
    I would like to know where the wrong part is
    As this MQ is quite big, I would like to also know if anyone of you can suggest any improvement of this input screen


    Exporting fields in form to existing Excel worksheet
    I have an Excel worksheet and I would like to link all the fields in this form to the first few fields in the excel file so that I can use them to calculate other fields.
    I have read the references but I can’t even link this form to the existing excel worksheet
    Can anyone tell me what to do? Thanks so much


    P.S. for pictures please see attachmentSOS.doc

  2. #2
    Join Date
    Oct 2003
    Posts
    103
    Quote Originally Posted by kei_iek
    One button to change one field of all of the reports
    Got a lot of reports that are needed to print out monthly (click one by one)
    There is a text field in each of the report which is needed to be changed from time to time (same for all of the reports)
    Is there any method so that a box can pop out and ask for that field’s data and then update all of the reports?
    SOS.doc
    I do a few things here, I have a "reports" control panel that I have user's run the report from, and I have a handful of controls on it that I check within the report query to see if the proper/required fields are filled out.

    I also have a few things that I want to print on each report ie "Confidential-[company name]" for example, but I wanted to keep that generic for portability reasons, so I simply have a table of global constants - I pull certain information from that at report run time . . . you could do something similar with global variables . . . OR, you could prompt when the report runs: [enter employee name], but then the user has to type the data correctly rather than use a combo box or something to aid in data validity.


    I'll leave your other questions for others. I have to run off to work.

  3. #3
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    Is there any method so that a box can pop out and ask for that field’s data and then update all of the reports?
    Yes. There are a few ways. The one you're probably interested in though is using a custom dialog box. Your "MQ" is an example of one... it just lacks the cancel button

    Is it possible to make the whole row to change its size according to the amount of data?
    The whole row IS changing. You just need to work on your lines. That comments field looks to me like it's showing what should be related data though, I'm not sure the table design is right....

    I would like to know where the wrong part is
    Since you haven't given ANY details about what is wrong with the query or any details about the query at all, there is absolutely no way to advise you.

    I would like to also know if anyone of you can suggest any improvement of this input screen
    That one is up to you imo, but I would be using a more compact design... make it look more like a dialog box rather than a data input screen.

    I have an Excel worksheet and I would like to link all the fields in this form to the first few fields in the excel file so that I can use them to calculate other fields... ...Can anyone tell me what to do?
    That's really an Excel support question tbh. I've never connected them that way around... I've always made Access look/link to Excel... sorry not much help there.
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!


    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •