Recent content by 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...

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

I will look at them now. Thank you.

so how do I create the query?

I really need some help in a bad way!!! Except for a few small details I had pretty much everything working on my database. I tried to do something new and wiped out my whole database. So after having to start over I can't figure out some problems. First- On one form, I have drop down box...

So here is what I have going. I have a form that will be updated every twelve hours. As of now on my report it shows all records listed in order on the report. I only want the most current record to show on the report. Example. Start of shift, person updates the info on the opening form and...

Updating a report with the current record only Hello, and thanks in advance, Not sure what setting I need to change but I only want my current record to be sent to my report from my table and not all the records. Any ideas. Thanks

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...

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...

Thanks for such a quick response. I am ok with the date and time stamp entered together in the table as one unit but, I can't have the time stamp show up on the report. Example. I have a form that my operators at a power plant will enter events that go on at the plant, the way that I have...

Doc, I found your post from doing a search. Your explanation is almost exactly what I need except I don't want the time stamp. How do I get just the date stamp and I will have the same date stamp entered multiple times. Do I just use duplicates ok?

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

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...

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...

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...