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?
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!!
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 RelatedI 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?
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
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
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
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
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
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…..
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
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?
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.
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.
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 RelatedI 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!
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
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:
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
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
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!
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!!
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?
Hi - I am looking for some help understanding the instructions in the msdn article on how to pass a parameter from a DAP. Please refer to the article: http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnacc2k2/html/odc_PassParam.asp
I was able to follow the instructions until Page 2 of this article...where it says: "Add the functions to write, read and delete cookies in a separate global script block."
I do not understand how to create a global Script block. Do I just copy and paste this code right below the 1st code on Page 2? Or, is there a way to create a global script block separately and add this code there?
I am unable to find that much Online resources on DAP as other Access topics. I thought posting my question here would be the last resort for assistance! :confused:
HI THERE.
IVE GOT A QUICK QUESTION ABOUT DATA ACCESS PAGES AND THE DATA THAT IS SHOWN. IVE CREATED A DATABASE THAT HAS AROUND 25,000 RECORDS OF LANDUSE PROPERTIES AND HAVE CREATED A DATA ACCESS PAGE TO VIEW THESE RECORDS. THE PROBLEM IM HAVING IS THAT WHEN I LOAD THE FORM ONLY 1000 RECORDS SHOW OUT OF THE 25,000 THAT I HAVE IN MY DATABASE.
ARE THERE ANY SETTINGS THAT ALLOW YOU TO CHANGE HOW MANY RECORDS CAN BE SHOWN? IS THIS ONE OF THE SHORT FALLS OF DATA ACCESS PAGES? :confused:
ANY COMMENTS MUCH APPRECIATED.
Hi there,
I apologise if this has been answered, I couldn't find anywhere else on the forum.
On the data access page it gives an annoying warning that says 'This website is using your identity to access a data source. If you trust this website, click OK to continue, otherwise click cancel'.
Is there a way I can suppress this message? It looked cool at the start, but now it's just annoying....
Thanks!