Good morning! I'm using Access to redesign our company's electronic phonebook. Our intranet uses SharePoint technology and our IT people have cranked our security settings up pretty high, so I can't use data access pages or ASP. Therefore, I'm going to use static HTML, producing a single page which the CEO's secretary will upload once a month, allowing our 800+ employees to view the entire phonebook at once. CTRL-F is their friend.
I've managed to design a data access page that looks very much like we want it to, but I don't know how to export it to static HTML. Can such a thing be done, or am I just being wacky? If so, is there a way to automate it so the secretary can just push a button to generate the page?
In my DB I have a query that I need to create a static webpage from, now in excel I can do the record button and bingo, but access is a lot more confusing.
I have a template named doc_tplt.html that when I do the export from the query it creates the webpage using this template.
I want to have a form with a selection of command buttons on it to export to html using the template for various queries and tables.
What is the VBA code to export the query (qry_docs) and apply the template (doc_tplt.html) and save to the same directory as the DB itself.
I am new to Access so forgive me if this is a dumb question. I want to export a report to html but I want for it to be wider. Right now I can export to html but each record gets wrapped so that all the text can fit on a single screen. I would like for my webpage to scroll left-to-right so that each record only takes up a single line.
Here is an example of a report that I exported: AudioVideo Report
As you can see the Album and Source fields are wrapped so that all the text can fit on the screen. Is there any way that I can make this same webpage but have every record appear on a single line? That way there would be a scroll bar on the bottom of the webpage and you'd just have to scroll to the right in order to read all the information.
Here is an example of how I'd like for it to look: AudioVideo Report 2
Again, sorry if this is a stupid question. Thanks for your help.
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 use vbs to download the page from a certain URL.In order to import data I go to get external data ,html format.Wizard shows that there are 5 different tables whithin the page.I need only one of them ,and more important I need it automaticly imported everytime I open my DB.
Tnx in advance
I've visited a few forums didnt get an answer. Here is the URL : http://www.nbs.yu/kl/today.php?vrsta=3
I have a scenario at work I need some help with. I'm just checking to make sure it is possible before I dive further into it.
We need a database for approximately 40 people to access at one time. They don't really need to access the database itself just be able to update it.
The question that was posed to me was this: Can we use an HTML page to update the database?
This will not be run through SQL or IIS or anything of that nature. It will just be an HTML page that is accessed through a users folder. On the HTML page will be the input boxes and a submit and reset button.
I made a data access page, but I really don't want the users to be able to go through the previous entries. I also wasn't sure if more than one person could be accessing the page at once.
Is a simple form page with a submit button possible not running on a web server?
Could anyone explain me the best way to fill external HTML pages automatically with data from an Access dbase? I have spotted several commercial tools that use macro recording. Surely there must be another way using visual basic for example?
I am trying to build a database to store product information and also the product page in HTML. I was able to do this in MS Access, however the export process would alter the code....(the field is in long text, and in Rich Text format)
For example, this is the code I store in the table:
I am simply trying to find text on a Web Browser Control htm page.
Using MS Access 2003, I have a form that includes the activeX Web Browser Control. On load of the form I initialize the web like below:
Code: Dim strURL As String strURL = "http://www.justice.gov/eoir/profcond/chart.htm" Me.WebBrowser0.Navigate strURL Me.WebBrowser0.Silent = True
The page loads fine.
Now, also, on my form is an unbound text box I call: [txtFind] and a command button I call [cmdFind]. I want [cmdFind] to find the first occurrence of the value in [txtFind]. My code below doesn't do anything when I click the [cmdFind] button.
Code: Public oRange As Object Public myfindFirst As Boolean Public intTextLength As Long Private Sub cmdFind_Click() Dim sSearch As String Dim strText As String
I am new to microsoft access and i am currently using microsoft access 2010...I have a students table in my access database and i have now append this table with data from a HTMLhow can i do that? using append query
Can i make an html of login form, whose data is saved in access as back end. I am curious to know. but of course simultaneous saving is considered yes in here...
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'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.
