Results 1 to 6 of 6
  1. #1
    Join Date
    Nov 2008
    Posts
    59

    Unanswered: How can I add the same data into a batch of new records

    Hi,
    I am wondering if someone can help me here. I am trying to find a way that I can make filling in a number of forms a lot easier.

    Basically I have a survey, which is completed and then inputted onto my database. There is some information to be inputted though which will be the same on every survey. For example, if the survey was taken on 12th April in the Market Square, the date of survey and location would be the same on survey.

    So I am trying to find a way that I could have a form where I could specify the date and location. Then when I click add new records, I would go through each survey one by one but they would all have the date and location information already inputted.

    How would I go about doing this. I really can't think how I would even start doing this!

    Russ

  2. #2
    Join Date
    Mar 2009
    Posts
    5,442
    Provided Answers: 14

  3. #3
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    sounds more like a table design problem to me
    I'd rather be riding on the Tiger 800 or the Norton

  4. #4
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    Well I'll take the simple approach...

    Just use Default Values. If you specify the defaults for those fields then the user doesn't have to enter them; they will automagically appear once the user starts entering data in [preferrably] a [different] field.
    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

  5. #5
    Join Date
    Nov 2008
    Posts
    59
    Sinndho, I have had a look at your suggestions. Unfortunately, I'm not too well versed in the coding side of Access and not entirely sure how they would work. But, I think 'Carry current value of a control to new records' is the most likely to be the one I'm looking for, but not sure how I would use it. If I had a text box for entering the data and location, and then had a button to go to the form for entering the rest of the data, would I be able to put the command behind that button and take the data from the date and location text boxes forward using this?

    Heraldem, I have no idea what you mean by table design problem. Can you say why you think this is? I am just looking for a way to save inputters a lot of time, and have no idea how the design of the table would help with this.

    StarTrekker, the problem with using Default Value is that for instance, the date field could be any day during the year, which is a lot of different values. And the location could be many different places as well. These are not defined so it would be hard to use Default Values for these.

    Thanks for all your help though and I am happy to hear any more suggestions!!!

  6. #6
    Join Date
    Mar 2009
    Posts
    5,442
    Provided Answers: 14
    Tell me if I correctly understand what you want to achieve:

    1. A user can input two values (date and location) and have those values to be carried from one record to another (only when it's a new record I presume), let's call those the default values.

    2. The same user can change those values at any moment and the new input values then become the default values.

    3. The same user can change those values only for one record and keep the default values the same as they where before.

    4. The default values can be stored and reused from one working session to the next.

    If this is what you're looking for, have a look at the attached mdb.

    Have a nice day!
    Attached Files Attached Files

Posting Permissions

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