Updating Date In A Query & Data Access Page

Feb 1, 2007

I am trying to do an auto time stamp in a data access page without having to go to new record. What I am doing is farming out parts of a record to different departments, and I want to time stamp each time each department performs their query, but I want to be able to display the data for the department, and store the timestamp in the original table.

Everything is stored under the table [Appointments] and different departments enter certain things. For instance, Reception gives the customer a ticket # which they enter into the database based on the query for the customer appointment. On the data-access page, I want them to be able to see their check in time. I am able to do this with an expression, but I can't store it in the field. Here's what I have:

Expr1:Now() (this is in the query)

In the data access page I display Expr1 with no problem. How do I get the field [Reception time stamp] to equal Expr1? When I try to do it in the query, it treats it as another expression and doesn't store it in the field (Reception time stamp = Expr1)

Is there a way to assign a field the value of an expression in queries or data access pages?

In other words, for the field I have named "Reception Time Stamp" is their anyway to plug in the Now() value when I do my query? Not search for Now() but have it show Now() when I use the query in a data access page without having to create new record. I know how to do it when you time stamp it with new record, but how can I do it with a query that pulls up an existing record that more info is being updated on it.

Table Demographics:
Account Number (Primary)
Name
Address
SSN
DOB

Table Appointments:
Appointment Number (Primary Autonumber)
Appointment Date
Appointment Time
Account Number (Relationship tied to Demographics)
Reception Ticket #
Reception Timestamp
Cashier Amount Collected
Cashier Timestamp

Relationship is One to Many (One Demographic to Many Appointments)

Everybody will be entering data on a data access page using internet explorer, which makes this more tricky, as it would be easy to do using forms. So here's how it works. Appointments enters customer information, appt date, appt time, and account number.

Reception pulls up by date and name(queries) the appointment, and then enters a ticket number (Like taking a number to be waited upon) After they enter this and write this ticket number, I want an auto-time stamp to be saved under the appointment table for reception time stamp.

Then, when their number gets called, the cashier pulls up the patient by ticket number(queries) and collects money from the customer. After they write the amount they collected, I need an auto-time stamp.

The reason I need to auto time stamp is so I can calculate time difference from the customer walking in the door and going out the door. The main reason this has proven difficult is because I am doing all data entry on data access pages, and everybody will be using internet explorer. Another reason is because almost all info is being saved under appointments, and each department only enters a couple of things towards completing the appointment record.

View Replies


ADVERTISEMENT

Data Access Page Filter Refresh The Page

Dec 30, 2007

Hi All,

I have a data access page needs a filter by a dropdownlist, the dropdownlist used is a html control and I use javascript to filter the data programmaticlly in the onchanged event of the control.

MSODSC.DataPages(0).Recordset.Filter="AppID = 3";

My problem is, when this statement runs, the page refreshes. But I don't need the page refreshes, it set the dropdownlist text to the default text, not the value user select. The browser is IE7.

How can I stop the page refresh itself?

Thanks and Happy New Year!!

View 1 Replies View Related

Data Access Page

Oct 2, 2005

Is it good to use (to make) Data Access Page to access the database (and put it on the web ) ?? :confused:

View 1 Replies View Related

OLE In Data Access Page

Oct 19, 2005

I have a photo (jpg format) which store OLE field in a table. But, I would like to display it in a Data Access Page. But, I have being prompt the following error: "You tried to drop an OLE or long binary column onto your data access page. There is no HTML control which binds correctly to this column type."

Do anyone know how to overcome this problem?

View 1 Replies View Related

Data Access Web PAge

Apr 12, 2006

Hi,

Can anyone tell me how I can get my data input web page to load with a new fresh input page. At present, each time a user opens the form, it displays the last record that was input previously.

When using a form, the record properties can be changed so that when the form is opened, it displays a new blank record to fill in. I cannot find any properties in the web page design view that allow it to be set to startup with a new blank page rather than the last record that was entered.

Any suggestion?

Thanks

View 1 Replies View Related

Data Access Page Help

Jul 31, 2006

Hi,

So i have made a Data Access page using the wizard from a table called Employees
I want the Access page to have some sort of search button so that they can quickly find an employee, rather than scrolling through all 100 records.

How can i do this?

Thanks Brian

View 2 Replies View Related

Data Access Page Help

Jan 15, 2007

Hey guys,

I'm somewhat new to MS Access. I'm trying to allow a user to update, add/delete records through a data access page. I am able to view the query, navigate through the results, but I am not able to make any changes. I get a pop up message saying the record set I am using is read-only. As far as I know, my table is fully editable. Anyone have input on this issue?

View 5 Replies View Related

Data Access Page

Sep 1, 2007

Hi All,

I have created a Data Access(DAP) Page to append the sales order received on phone. The Data Access Page is linked to query which has autonumber field to store the Sales Order. I have a textbox on DAP for Sales Order No. The autonumber generated in Table is different from autonumber generated on DAP. I want same the autonumber on page and in table.


Thanks for time.

S Acharya

View 3 Replies View Related

Data Access Page

Oct 3, 2007

Hello Everyone,

Can you allow the users to update and edit the data access page and actually change the data in the database? Or is it just a view only? If possible I need the user to be able to update the database through the data access page.

Is this possible?

Any ideas would be helpful.....

Thanks

View 1 Replies View Related

Data Access Page Help!!

Dec 21, 2007

I have a database for my staff to enter data into via a data access page. It works on all windows xp os computers. We do have staff working on Windows 2000 os computers and it is not working appropriately.

The database was created in Access 2003. When the user pulls up the page, none of the drop down menu's populate. I try to trouble shoot it and access states that it can't make a connection to the database. This is only on Windows 2000 os. Windows XP computers work fine.

Any suggestions?

Thanks in advance,

jason

View 1 Replies View Related

Access Data Page Help

Dec 29, 2004

I have built a BD with several date fields (on a form) that were set up with a simple command button for "today's date" to be entered.



I'm attempting to set up a Data Access Page that is very similar and easy to use. I need help setting up command buttons that auto-populate text boxes.....if this isn't the best route, I'm open for ideas.



I have just started putting the Access Data Pages together and don’t have a real good grasp yet.



Any help would be great…..

View 1 Replies View Related

Data Access Page On FTP

Oct 26, 2005

I have a database that I'm trying to create a data access page for. The database allows people to put in their information and register for a conference. This part works fine.
I tried using the data access page wizard to create the page. I can't seem to get the connection string to point to the database so that when I upload both to my FTP, they will work together.
I have successfully uploaded the access pages to the FTP, but it will only update the database if it remains on my computer.
How can I set the location to be relative to the data access page? (eg - DB1.mdb is on ftp in /_private, data access page in same directory on ftp and looks in its own directory).

Or, maybe the problem isn't this straight forward?
Thanks,
--Jim

View 1 Replies View Related

Access Data Page

May 5, 2006

I use data access pages for manipulating data from DB.
I wish to retrieve data from my Access2003 database using an SQL variable value which should be entered through some text box.
I would like to make DAP that would have one text field and action button, returning a result based upon my entry in that text field.So when button pressed
Can someone give me some sample ASP or VB code for doing this?

View 2 Replies View Related

Data Access Page

Mar 18, 2013

I have created a very simple Data access page and saved in in a folder on my computer, I can open it from MSACCESS. But when I try to opent it directly from where it is saved here is what happens:

- The explored message as the content is not allowed by secutity settings. then I allow the content.
-I got a message that Windows will close this program (Internet Explorer) to protect your computer.

View 1 Replies View Related

Forms :: Updating Date When Modifying Data

Nov 20, 2013

I want to update my date field in my database everytime when the record is changed. I do not want to do this by using a macro and I cannot make it word by using the before update function. In the before update I have tried the following without success (nothing happens):

Private Sub Modified_Date_BeforeUpdate(Cancel As Integer)
Me![Modified Date] = Now()
End Sub

View 7 Replies View Related

Data Access Page - Password

Jun 22, 2005

I'm currently using a data access page web form in order for users to enter data into my database. The database is protected with a generic password. Whenever the form is opened in IE, it asks for that password.

The functionality that I want is for the users accessing the database through the data access web form to not need a password, but I do want the password on the database itself. This way users can't just see all the information stored within the database, but they can submit certain information through forms. Is this possible? I can't really find much about data access pages even requiring passwords, but it makes sense. I just don't know how to achieve the desired functionality.

View 3 Replies View Related

Ask For Help About Hyperlink In Access Data Page, Thanks A Lot!

Aug 19, 2005

I created a hyperlink that links to a zip file. But when I use IE to browse the page, I cannot see "save target as" after right clicking the hyperlink. Why? Thank you very much for any help.

View 1 Replies View Related

Creating A Data Access Page

Aug 8, 2006

I am trying to make a DAP for data input into a table.

I used the wizard and it has the fields I want, I can scroll through them and view the entries, but they are not editable.

I read about changing the Page DataEntry property to True, but I still cannot select any of the editboxes on the DAP and now the DAP just shows blank non-selectable editboxes.

I decided to create a dummy table to work with to test creating a DAP, my dummy table looks like this:

Group Name Number Text
1 Bill 3 pink
1 Adam 5 green
2 Charlie 7 blue

I ran the wizard on the above table and again I can scroll through but not select any of the fields, and with DataEntry set to True I still cannot select/edit the textboxes.

Is there something else I need to do to be able to make an input form?


Once I get that sorted out I have a followup question: The dummy table above is where the input data goes, but on the input form I would like if possible to get the Group and Name from a different table using drop-lists. The real table has over 5000 names split into groups of about 30-50 so picking a group first would help find a name in the list which will eventually be input to the table above.

Hope that all makes sense, and thanks in advance for any help!

View 1 Replies View Related

Login For Data Access Page

Mar 19, 2007

Hello

Can anyone help?

Im in the process of making an access database with a login form. I used VB code to validate the login which was bound to a logon button after the user puts in a username and password.

This worked fine - but I now need to do the same for a data access page.

Can anyone tell me how to do this please?

Many Thanks
Daz

View 6 Replies View Related

Access Data Page /access2003

May 4, 2006

Hi all,
I was thinking if some could suggest me how could I make DAP which will have only one text box and command button in which will the value written there be forwarded to some parameter SQL when that button is pressed...

Do you know what VB code should I implement in onClick action for that button so he could start some query who would use value placed in that text box and then generate results in DAP....

Any comment is appriciated!:rolleyes:

View 3 Replies View Related

Data Access Page-Default Value

Apr 5, 2006

Hi All,

I've made a data access page which is in data entry mode. One of the fields is a date field which I have set the default value as =Date(), but it only inserts the default value when you move to a new record it doesn't put it in on the initial record.

Any ideas?

Cheers

View 2 Replies View Related

Alert Box On Data Access Page

Aug 23, 2005

Hi,

I have a Data Access Page linked to an access database (of course!) and I would like to have a script in the submit button, so that it inputs the current time onto a particular field, and also throw up an alert box...could someone please help? I am not good at this, but it looks like it is javascript - thats currently on the button for the save action

Regards

Sunny

View 3 Replies View Related

Creating A Data Access Page

Aug 8, 2006

I am trying to make a DAP for data input into a table.

I used the wizard and it has the fields I want, I can scroll through them and view the entries, but they are not editable.

I read about changing the Page DataEntry property to True, but I still cannot select any of the editboxes on the DAP and now the DAP just shows blank non-selectable editboxes.

I decided to create a dummy table to work with to test creating a DAP, my dummy table looks like this:

Code:Group Name Number Text1 Bill 3 pink1 Adam 5 green2 Charlie 7 blue

I ran the wizard on the above table and again I can scroll through but not select any of the fields, and with DataEntry set to True I still cannot select/edit the textboxes.

Is there something else I need to do to be able to make an input form?


Once I get that sorted out I have a followup question: The dummy table above is where the input data goes, but on the input form I would like if possible to get the Group and Name from a different table using drop-lists. The real table has over 5000 names split into groups of about 30-50 so picking a group first would help find a name in the list which will eventually be input to the table above.

Hope that all makes sense, and thanks in advance for any help!

View 1 Replies View Related

Two Data Access Objects On Same Web Page

Jun 19, 2007

Is it possible to have a button on a data access web page that saves the record and then refreshes the screen? I have the data access page in data entry mode under page properties, and I want the person entering the data to press the save button, which saves the record and clears the screen for the next record.

I am running this in frames (I currently have 4 frames on the web page) and if you set the button as "add new record" which works for a regular page, with frames, it doesn't clear the screen, but rather puts the data entry form below the original.

Any help would be greatly appreciated. Thanks!!

View 1 Replies View Related

Search In An Access Data Page

Sep 6, 2007

Hi i have a small problem that i hope you maybe able to answer.

I have creted an access data page, which works ok. However i really would like the option to search on a certain field to lookup a record. Is this possible?

I understand that there are filter options, but i need to define just one field, for one record.

The nature of this database is to store info on batches we produce, therefor it's important i can search via a batch number.

Is this possible?

View 1 Replies View Related

Forms :: Updating Old Database - Repeat Data From A Given Date

Feb 20, 2015

I am currently updating an old Db which rosters staff. One of the enhancements will allow the user to automatically allocate staff details to a Roster after a given date. i.e. Roster date 20th Feb 15, repeat for 3 days. 21st 22nd 23rd Feb 15. I have created a form with a medium date field and then a Combo box with drop down values of 1 thru 7 days. I want to link the combo box value to the Date box.

View 3 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved