worksheet automatically pre-populate

[NoLegalMoves via AccessMonster.com]

I have a main form that contains a subform in worksheet format. The worksheet
has 2 columns which tracks the values of a parameter overtime.
For each record of the main form, I have always the same time intervals in my
worksheet.

examples:
12:00 value1
12:30 value2
13:00 value3

I would like that for each new record of the main form created, the time (12:
00, 12:30... etc) pre-populate in the worksheet?
Is it doable?

Jeff

 

[June7 via AccessMonster.com]

First, try not to use the word 'worksheet' in association with Access project.
Spreadsheet apps (Excel, etc.) have 'worksheets'. Access forms and queries
have a 'datasheet view'. I know this sounds petty but could save some
confusion in discussions. Access datasheet views are not worksheets and
cannot be interacted with in the same manner.

Now, I am not understanding the nature of your data and this form and why you
need to display these time intervals. Please give more detail about what you
are trying to do so that might be able to provide a reasonable solution.

 

[jfsauzeat129 via AccessMonster.com]

Thanks for the reply

My form in datasheet view has some data for a graph
The data graphed is pH during a fermentation process
The 1st column has the time enlapsed info, the 2nd column has the pH

The reason I would like the time intervals to be pre-populated is that the pH
measurements do not have to occur at designated times. However, when I graph
the data, my time axis has to have consistent time intervals.

I hope I am more clear.

Thanks for the help.

Jeff

First, try not to use the word 'worksheet' in association with Access project.
Spreadsheet apps (Excel, etc.) have 'worksheets'. Access forms and queries
have a 'datasheet view'. I know this sounds petty but could save some
confusion in discussions. Access datasheet views are not worksheets and
cannot be interacted with in the same manner.

Now, I am not understanding the nature of your data and this form and why you
need to display these time intervals. Please give more detail about what you
are trying to do so that might be able to provide a reasonable solution.

I have a main form that contains a subform in worksheet format. The worksheet
has 2 columns which tracks the values of a parameter overtime.

[quoted text clipped - 11 lines]

Jeff

 

[June7 via AccessMonster.com]

Ahh, graphing! And this concerns pH data. From your original post I thought
payroll because you mentioned 'overtime'. Okay, I have built about 20 graphs
in a project but they all rely on Union queries and display data for one
record. So this is a new challenge for me. You don't want to use the elapsed
time as X coordinate and base the X axis scale on that range of values? I
don't know any easy way to automatically populate the graph's datasheet
dynamically with sequential values for the X coordinate. I did a net search
for 'VB increment function' and found users who have built their own
functions to do this. So, try to write your own or save the time to a table
field and then include that field in the graph's RowSource query. I
experimented and after some frustrating moments managed to get time and pH to
graph as XY pairs. There must be some value that the data will be filtered on,
such as a project number? In other words, is there some value that unites
records as a data series for purposes of graphing? Use this value in a query
to find the last time value saved for that series then just add increment and
save that value for new record. Good Luck.

Thanks for the reply

My form in datasheet view has some data for a graph
The data graphed is pH during a fermentation process
The 1st column has the time enlapsed info, the 2nd column has the pH

The reason I would like the time intervals to be pre-populated is that the pH
measurements do not have to occur at designated times. However, when I graph
the data, my time axis has to have consistent time intervals.

I hope I am more clear.

Thanks for the help.

Jeff

First, try not to use the word 'worksheet' in association with Access project.
Spreadsheet apps (Excel, etc.) have 'worksheets'. Access forms and queries

[quoted text clipped - 11 lines]