Results 1 to 7 of 7
  1. #1
    fishhead is offline Competent Performer
    Windows 7 32bit Access 2010 32bit
    Join Date
    Apr 2015
    Posts
    167

    Continuous form question

    Can someone suggest how i might create a continuous form that would have the following fields [startdate] [term] [value] [growthrate]



    where
    [startdate] = the day i wish to start the calculations
    [term] = how long i want the calculations to continue (in this field i will enter 365 if i wish the make a calculation for each day of 1 full year)
    [value] = my starting value
    [growthrate] = how much i wish to increase the previous records [value]

    So what i'm trying to do is have a form with a header as follows: (this i already know how to do)
    [startdate] [term] [value] [growthrate]
    9/8/20 365 $1000 $10

    with 365 continuous records in 1 day increments that start with a [value] of $1000 for record 1, and $1010 for record 2, $1020 for record 3 ..... all the way until the end of the year (record 365).

    I'm not sure how to set this up. Can anyone suggest a simple structure?

    thanks in advance.

  2. #2
    Bob Fitz's Avatar
    Bob Fitz is offline Access Developer
    Windows 10 Access 2016
    Join Date
    May 2011
    Location
    Essex UK
    Posts
    3,530
    Take a look at the attached db. Post back if you have any questions.
    Attached Files Attached Files
    If this helped, please click the star at the bottom left of this posting and add to my reputation . Many thanks.
    Bob Fitzpatrick

  3. #3
    fishhead is offline Competent Performer
    Windows 7 32bit Access 2010 32bit
    Join Date
    Apr 2015
    Posts
    167
    Thanks Bob,
    i can see this works perfectly but i don't know how to reverse engineer it as you created in in VBA.
    I was hoping for help building this with queries and macros (which i'm familiar with).

    Would you be able to tell me how to have the form create 365 records (without using VBA)? I should be able to take it from there.

  4. #4
    fishhead is offline Competent Performer
    Windows 7 32bit Access 2010 32bit
    Join Date
    Apr 2015
    Posts
    167
    I just figured out i can use the REPEAT COUNT in the RunMacro expression to create my desired records. For some reason though when i run this (with the repeat count set to 365) it usually crashes around record 40 with the error "the command or action "Paste" isn't available now". Can anyone suggest why this would be happening? it never stops at the same record # it appears to be random at around the 40 record mark.

  5. #5
    Bob Fitz's Avatar
    Bob Fitz is offline Access Developer
    Windows 10 Access 2016
    Join Date
    May 2011
    Location
    Essex UK
    Posts
    3,530
    Quote Originally Posted by fishhead View Post
    I just figured out i can use the REPEAT COUNT in the RunMacro expression to create my desired records. For some reason though when i run this (with the repeat count set to 365) it usually crashes around record 40 with the error "the command or action "Paste" isn't available now". Can anyone suggest why this would be happening? it never stops at the same record # it appears to be random at around the 40 record mark.
    I'm sorry but I haven't really used macros for over 20 years. Whatever I knew has long since been forgotten.
    I'd be more than happy to help with explaining the code I used.
    It sounds to me as though what you actually want is a solution to a problem in another database. I'd be happy to help you with that too but of course I would need more details.
    If this helped, please click the star at the bottom left of this posting and add to my reputation . Many thanks.
    Bob Fitzpatrick

  6. #6
    fishhead is offline Competent Performer
    Windows 7 32bit Access 2010 32bit
    Join Date
    Apr 2015
    Posts
    167
    thanks Bob, that is very generous.
    I'm creating an application that will automatically track a specific stock i plug in the front end and show me specific variances over time - to help identify patterns etc.

    ultimately i plan on loading thousands of records of data into the model (the more the merrier as they say), and will be looking for specific trends.

    I have been using MSaccess for many years though never the VBA functions. So i'm at a bit disadvantage in that regard. Once done i should be able to look at historical data to see if my predictions are accurate or if the model needs to be adjusted further etc.

    I would love a hand with this if you are still offering? is it possible to PM you?

    regards,
    Steve

  7. #7
    Bob Fitz's Avatar
    Bob Fitz is offline Access Developer
    Windows 10 Access 2016
    Join Date
    May 2011
    Location
    Essex UK
    Posts
    3,530
    For the benefit of all members, it would be better to carry on here.
    If this helped, please click the star at the bottom left of this posting and add to my reputation . Many thanks.
    Bob Fitzpatrick

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Continuous Form Question
    By amallon in forum Forms
    Replies: 1
    Last Post: 08-24-2020, 03:22 PM
  2. Replies: 9
    Last Post: 07-14-2014, 07:56 PM
  3. Replies: 2
    Last Post: 01-01-2014, 02:10 PM
  4. Replies: 5
    Last Post: 08-24-2013, 08:04 PM
  5. continuous form question
    By dadofgage in forum Forms
    Replies: 1
    Last Post: 10-17-2012, 03:38 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums