Does access have a way to automatically generate a web page with a form that can allow a user to input his criteria, and when a submit button is clicked, automatically update the database?? Also, is it possible to generate through access a button that links back to a query. Or is all this something that web page developer would have to do and code, and the database would only be an underlying element in the code.
For more clarification, the web page that i need designed should only contain a single form to allow a user to add their information to the database, not the ability to view other entries, or make changes to other entries. Also, the query I would want should only display information regarding a certain field in the form the company just created for themself.
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.
I do not have any programming knowledge and have what might be a simple question.
I am having a hard time getting my hosting company to modify the rights on the data folder where I store my access database. They state they support ASP and access databases however this is the response I got when I requested the modify permissions set for the internet guest account:
No, we do not manage rights to folders.
My question to you is: Doesn't supporting asp require those permissions be set on the database folder or can asp work without those rights modified?
Hello All, BackGround: I recently started to use Access. I have been around MS Office products for quite a while but never used Access until I got my current position. I have made automated forms with MSWord and macros but Access is a different machine.
I have 2 simple tables the first one is as follows. It has 3 information columns and the autonumber.(Primary Key) The table contains hotelname, hotelph, hotel fax.
The second table I have. It has 6 information columns and the autonumber. (Also Primary Key) This table contains. guestname, rank, ssn, requestedhoteldate, durationofstay, remarks.
Both of these tables correspond with a form. To make things easier I only put the hotel name in the form as a combobox, so you don't have to type in the hotel information every time. Now my question.
I need to take the chosen hotel and the information entered and put it into the completed Report to print?
I suspect that I will need a third table that combines the information from the form, and link that to the report but I can't figure out how to get just one hotel to show or the relationship I need between the form and the tables.
1. In a form that I have created, I have a checkbox that I want to have checked when the form (ticket) that was filled out has been completed by our company. I want the checkbox to only be accessed by us. How do I achieve this to only certain users have access to check that box?
2. I have a main screen that the form is able to be accessed by. In that home screen I have a query that shows what tickets have not been completed (checked). How do I get those tickets that have been checked, to not show up on that screen?
I have a report which includes several subreports. There will be times when a subreport prints partially on one page and completes on the next. I don't always want to break to a new page with this subreport. However, I would want to break to a new page if the subreport cannot fully print on the current page.
I have a report that lists states and cities within the states. When a state name happens to be at the end of the page the individual cities appear on the next page with no State heading. I solved the second page problem by setting the "repeatSection = Yes" in the Section Header (though I haven't shown that in the example below).
But the previous page (which just shows the State Name and no cities looks dumb. Is there some sort of solution.?? (Actually I would also like any State that continues to a next page to not just have the state name but something like " Colorado (Continued)" Is there anything I can do in VB to make a page break if the section is going to print but therer isn't enough room for one detail line?
This is what I currently see
Alaska Ancorage Prudo Bay
California Whittier Anaheim
Colorado ------------------------Page Break --------------------------------- Denver Pueblo Colorado Springs
If I have a report and it has controls (labels representing column titles) in the page header. Now when I print the report - if it happens that the last page has no detail records - but there is text boxes and so forth in the report footer. Is there a way to not display the page header on the last page?
I have a report where the last page shows the page header - and the field/column labels on the page header - but for which there is no detail records left to display - on the last page. There is report footer information that should display. It just looks weird because the field/column labels show at the top of the page - but there is no data remaining to print under them on that last page.
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."
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.
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.
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?
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.
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.
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.
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.
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 have one-page forms which print a second page, blank except for a block of grey shading at the top. I have tried moving the content of the form up but that doesn't eliminate the second page. If I look at print preview, every second page of the entire database shows up as blank, regardless of where that happens to appear in the record.
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.
