Hello: Can't seem to find whats wrog with my setup.

[bkuuz1]

Any help would be great. Thanks for the help in advanced.
Useing Access 2003.

My problem is, I have two forms that need to send data to a daily report. I have one form that will be updated once every twelve hours. This one seems to be working corectly ( as long as you close the form after updating it it transfer the data). My other form will get updates every few minutes. The data being sent to the report is as follows: Event Time (manual input), Condition Of event (drop down box and select an action), and a description of the event (manual input). As the data is entered into the form and data base, I will then need the data sent to the report immediately. I also need data to run in a chronological order in two rows on the report. I have the report set for two colums (down, then up), but don't know if it is going to work yet. Any ideas would be great because I am out. Thank you.

 

[neileg]

When you show a record in a bound form and start to enter data in a control the record enters a state known as 'dirty'. That means that the data in the form isn't the same as the data in the underlying table. This is true of new records or amended ones. To get the data to transfer to the table, it needs to be saved. A save is trggered automatically when you close the form or when you move to another record. Alternatively, you can program an event on the form so that the record is specifically saved at that point. Without understanding the processes going on here, it's hard to give definitive advice on what you need.

 

[bkuuz1]

Re: Hello: I really need help, Out of ideas.

Neileg, Thanks for the reply. Maybe this this will help. On my second form,( this is the one that will be updated constantly) I am using the following command buttons, Cancel-cancels the record that was being added, Enter-this enters the data and sends it to the table, New Record- clears the form, Last Record- shows the last record (Data) that was entered, this is to make sure that the last record you entered was what you need to put in the table.

What I need to happen is, when you press the enter button, I need the data, one tobe entered into the table and also tobe entered into the the report.

I also need the data that is entered in the report tobe added in chronological order. Like the example below.

Time information code Event.
16:45 Alarm Received an alarm.
17:00 Responed Responed to alarm, nothing found.
17:10 Information Received phone message from John Doe.

The examples above could get as many as fifty in a twelve hour period or as little as one or two. My plan is, at the end of every twelve hours the report will be printed and put into a binder. So at the beginning of every twelve hours the data being sent to the report will need to start fresh.

So far I have the data above entering into the table like it should but I cant get it to go from the table to the report. Also because the report is short on space I need it to run in two colums, down then over and down. (Page setup-is set for two colums,down then over).

I really need some help with this I am just out of ideas on how to make this happen.

 

[bkuuz1]

Pat, Thanks for the reply. So here is my question, If on my form when the data is entered into the boxes and the command button for enter is presses the data is then entered into the tables. I am assuming the data in the tables are then automaticly saved. Is this not correct? Ok maybe I have been thinking of the whole process in the wrong way, but what I was trying to accomplush is after the data was entered into the form ( and into the table) then the person who entered it could then go to the reports and in print preview look at the information ( Time, Information code, Event) to make sure they had entered all information for the report. Can this be done? Thanks.

 

[bkuuz1]

After looking at this for a while can anyone tell me if I should use a subreport for the data to be entered in the report. Thanks

 

[coyote]

If I get what you want then its very simple like the way Pat told you reports are either based on tables or queries.
You can't be entering the data on the forms and the reports at the same time.
Depending on how you have designed your report the sorting of the Key field in the ascending order should sort your records as the are entered.

Once you press the save button on your form the data in the form is saved and then you can open the report and view the data changes.
From what I gather you need to filter your data by day since over time your records are going to grow and users might find it hard to scroll the report looking for the right date

Cheers

 

[bkuuz1]

Hello and thanks for the response.

(From Pat) OK so I understand this part, Forms don't store data. Tables store data. Forms get their data from tables. Reports get their data from tables.

(From Pat) If you want a report to show up to date information, the form that runs it probably needs to save the current record before opening the report. So if I wanted the data in the tables that is already saved to update the report so I could look at the events say from 08:00 to 12:00 how could I do this.

(Coyote) If I get what you want then its very simple like the way Pat told you reports are either based on tables or queries. I don't understand this point.

(Coyote) Depending on how you have designed your report the sorting of the Key field in the ascending order should sort your records as the are entered. Ok, this brings up another issue that I had thought about but didn't know yet how to fix this. I looked at the fey field and cant seem to figure out how to set it for ascending. Also seting a filter, is there some way to set it for a specific time frame, say every twelve hours. Thank you

 

[gemma-the-husky]

if you have an open form which draws data from another table, then once the form is open, i dont think it automatically refreshes itself if the underlying data changes

i think you may need a button on the form (or a timer event) to requery the form

all you need is the command me.requery in the button's or timer's code - the only thing to watch out for is, a requery will move your recordset cursor back to the first item in
the recordset

I think me.refresh will reread the data for the current item? but not the whole recordset i thnik

 

[bkuuz1]

Ok, so I think maybe I am looking at this the wrong way. Instead of updating the report automaticly, how about this, if I add a button on my form that says update report, then any data that has been add to the table thus far would be sent to the report. But then my other question would be, say another ten or so entries were added latter in the day and then the update report button was pressed again would it add all the entries for the day or just the next ten or so. You guys tell me, should I just set it up so that the data only updates on the reort one time during the shift (12HRS).

 

[neileg]

You can't update a report. Once a report has run, that's it. You need to re-run the report which replaces the previous version.

Exactly what data is included in the report depends on the query that feeds the report or the filters applied in the report properties.

 

[bkuuz1]

So should I make a new form with a date and time selection to run the reports? Or is there a better way.

 

[bkuuz1]

Hello Pat and thank you.

I ended up adding a save command button on the form. So far seams to do what I want.

If I could ask you another question, I only want the most current (saved) record to be sent to my report and only that record to be displayed on the report. Do you have any ideas as to the best way to do this. Thank You.

 

[coyote]

You need to create a filter. Assuming in the table you have a time and date fields,you can create a filter to search for records only entered for a specific duration of time and a specific date.
search the net for creating filters in ms access.
cheers