Pulling a Date from one Table and adding it to another

[lance.heinen]

I am trying to figure out a way to pull a date from a table and add it to another table automatically. I'm building a database for a harvest/trucking operation and we want to be to set the date everyday and then it pull that date on all of our tickets, reports, etc. Most days we run till after midnight but we want to still record the date as the day we started so I don't think pulling the date from the computer itself would be a good option. Any ideas?



Thanks/Lance

[June7]

Lots of ways. Keep in mind, the more user friendly, the more code.

One way is to set the DefaultValue property of the textbox with the first record entry. As long as the form remains open the value will carry forward to new record and won't change until user enters a different date.

Other methods involve global variable or TempVars or setting a control on a form that never closes. Reference TempVars or textbox or a function that uses global variable in DefaultValue property or in VBA code that populates field.

[NoellaG]

Hi Lance,

I found that most applications have a lot of settings/preferences that determine how the app should work, like folder locations where to get/store files to import or export, the preferred language of the current user ect. In your case this could be the default date for the application. To store these I designed a tsysParameters table where I can store and retrieve these parameters.
In your case you can design a form where the user can change the date in the table whenever it is necessary, and then throughout the application the date can be retrieved from the table when needed. For example ,you can retrieve it when opening the form used to manage the trucking operations and store it as a property of that window.