Web Based Data Entery

[jumex]

Right now I have my database completed its on the server I have created an HTM Data entry page in the same directory as the database. It has been tested and works. I created network shortcuts that point to the HTM file for all my users.

I have it setup so all users can add data to the same record all day long. The page periodically refreshes to show the data other users have entered.

Now the problem I am having is this: Each record is supposed to represent a day of the month and the whole system works flawlessly for the first day or the first record.

When you move on to the second day or second record every time the page refreshes or you refresh it manually or when you close it and open it. It always goes back to the first record.

Now I can force it to go to a new record but then it goes to a new record for everyone, every time they open it or refresh it.

I need to know how I can force it to go to the last record when I open the HTM form. Keep in mind that since I am working with an HTM form it ignores all event properties as a result I can’t use a macro like I would if I was dealing with a normal Access From.

Any help would be appreciated.

 

[fneily]

It'll always go to the first record because that's what it's originally bound to when you created the DAP.

You state "Now I can force it to go to a new record but then it goes to a new record for everyone, every time they open it or refresh it." Does this mean that each user has a different record they're working on? In your discussion, it seems like everyone is working on the same record. This part is confusing.

Can you base your DAP on a query that picks off the record that needs to be worked on that day? If not, look at the "setrootrecordset" of MSODSC eg. (MSODSC.SetRootRecordset "MyTable", rst) to reset the binding, then reload the DAP, eg. simply put in the line
window.navigate("MyDAP.htm")

 

[jumex]

You state "Now I can force it to go to a new record but then it goes to a new record for everyone, every time they open it or refresh it." Does this mean that each user has a different record they're working on? In your discussion, it seems like everyone is working on the same record. This part is confusing.

Yes I need for them to be on the same record. With this I was mearly trying to show that the result I was able to acheve where First Record and New Record, however what I want it to do it go to Last Record.

When you create the HTM form you get a record navigator at the bottom. One of the buttons is "Last Record". Is there anyway I can code what ever that button does directly in to the page?

 

[fneily]

Oh, you just want to go to the last record when the DAP opens.
GoTo Design view. Right click and select Microsoft Script Editor. On the left under Script Outline, scroll down to Window. Double click on Window to expand and double click "onload". Type in the following:

MSODSC.CurrentSection.DataPage.MoveLast

Down when you open the DAP, it'll be on the last record.

By the way, if you want it to open to Data entry, do this:
GoTo Design view
Click on the Title Bar. Bring up the Property sheet and click the Data tab. Change DataEntry option to True

 

[jumex]

Thank you, I went with the query option that worked. Hoever its good to know there is another way.