Using HTML Page To Update Database
Apr 1, 2006
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?
View Replies
ADVERTISEMENT
Dec 6, 2005
first i'm sorry on my english.
I have in my work some computers with network.
I want to send mail to one computer, the mail is like form in HTML
have 3 things:
1. textbox
1 select
1 submit
is it possible to get the mail and to write in the mail and send it (by submit button) then to update the access db.
I have no idea.
if there is an easy way to do it, I will happy to hear.
[I think to do it with an asp page in each computer that the HTML send the items to the ASP page (by request.get) then the asp page update the db].
View 2 Replies
View Related
Apr 12, 2005
HI .
I have a problem thats over my head.
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
View 1 Replies
View Related
Jan 15, 2008
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?
Thanks,
Andreas
View 4 Replies
View Related
May 5, 2015
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
[Code] .....
View 9 Replies
View Related
May 30, 2005
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.
View 1 Replies
View Related
Mar 14, 2008
I'm really hoping someone can help with a topic which has cropped up from time to time in the past but which never seems to have been answered satisfactorily, and that's displaying html in a database.
I have a large database which already includes html codes in the fields - it's a complete set of email digest posts with fields for date, sender, message number, subject and body text - which I'd like to display in it's original form. An ordinary form shows all the html code making the contents difficult to read; is there a simple way of being able to view this so that the correct original message layout is shown, i.e., the html is parsed (is that the right expression)?
Perhaps I should point out I'm a complete novice when it comes to Access; I can write a simple form easily enough, but I have zero knowledge of VBA or anything similar, so non-technical answers or a step by step example would be very much appreciated.
View 1 Replies
View Related
Jul 25, 2007
HI All,
I have scoured the net and these forums looking for the answer but cannot find a good solution.
I am producing flow charts in Visio, and then saving them as HTML documents for use on our Intranet. Within the Visio flow diagrams I am using Hyperlinks on various shapes and text, to enable the viewer to open various other documents in various other applications. This seems to work fine in my web browser for normal office documents, like word and excel, but I need to be able to do it for MS Access databases too! Because the web browser tries to open it in the browser itself, the database won't open and I just get the normal "Web Page Could not be found" screen.
Another useful feature would be to be able to open to a number of different specific forms from a database, depending on which hyperlink is clicked. I assume this is not possible as you only seem to be able to define on page to be displayed upon opening the DB. Am I correct?
Any assistance would be greatly appreciated.
View 2 Replies
View Related
May 9, 2005
Hi,
I have a database which I can add to, edit and delete via an asp.net page, it also allows me to add html tags.
My problem is when the data is then rebinded to the page any HTML tags are changed from '<' to '<' and from '>' to '>' this results in the tags and contents being displayed on the page as text instead of being interpreted as HTML and then formatting the page - most frustrating!
Any help is greatly appreciated, this is a relatively new area for me so many thanks in advance.
Steve
View 1 Replies
View Related
Feb 1, 2013
I have small program in access database which contains about 100 cca tables, querys, forms, macros in total. Customer which both program from me, wants me to enable him to access this program not just from work, it wants to access it from home or when he is on business trip from hotel etc.
I am little confused how to achieve this and what are my options? I assume I have to set by database somewhere on server and so my customer could access it any time? Do I have to upsize access database to SQL express or similar?
Also, one more important question: is it possible to "convert" access database into HTML code or similar so it could be accessed via web browser without need to install microsoft access and with freedom that it can be opened from any type of PC OS (Linux, Mac etc)?
View 14 Replies
View Related
Dec 12, 2012
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
View 10 Replies
View Related
Dec 27, 2004
I need, in some way or another, to be able to import an HTML code from an HTML file into Access. It would be ideal if the end result is a table with one memo field named "HTML".
I know is seems strange, but I need the code itself. I've managed to do a bit of duct-tape work, and import from HTML, but this results in only the text of the HTML code (Meaning the text of the web page, not the tags).
I know I'm crazy for wanting this, but is there anyone out there who can give direction/guidance?
More web-ish than vba-ish,
Andrew
View 3 Replies
View Related
Jun 27, 2013
My database allows you to log issues (see attached)
An issue will belong to the project, the project may have multiple test plans.
The issue will also be the primary responsibility of a company, and that company may have multiple contacts (people)
Now, i could create a form over the top of each table but then if someone wanted to add a new project, testplans for that project, suppliers (companies) for that project AND new contacts for those companies, they are going to end up going through loads, and loads of forms.
So my question is, what approach would you recommend to create a control panel where they could add these items with the fewest number of page switches possible? (preferably none.
View 1 Replies
View Related
Aug 9, 2006
Hello all,
I currently have an inventory system on database and my customers can access this by clicking a link on the homepage, which in turn, pops up a search form and results table. When they enter the item number it returns the qty. available, without a problem.
The problem I am having is this; I would like to have the search form on the same page they are looking at (no pop-ups). I figure the inventory system will get used more often this way. BUT when I went ahead and tried to put the search form on the page it seemed to work out ok, except that when you click submit (to start the query) it sends me to my 404 page.
When the search form was a pop-up, it just returned the results to the same page. Is there any way that I can get the search form on the same page they would be looking at, to avoid any further windows for them to open and close??
Also, to advance this a bit, is there any way that I can have the database results posted to the page without a search form? Just posted based on the item number in the URL??
Thank you for all the help, I did a search in the forum and wasn't able to find enough information to get the job done. Hope you can help.
View 2 Replies
View Related
Apr 18, 2007
Hello!
I was wondering if someone could try and connect my database to the web. I would like to view the names of the CDs in her collection over the Internet.
My database is attached!
Thanks
View 3 Replies
View Related
Feb 24, 2013
1. how to convert an access database (query) to a web page.
2. what knowleage we should learn ?(php,asp....)
View 2 Replies
View Related
Oct 22, 2012
I want to get a page like following through DW8+ASP
>Yageo
#Resistor
#Capacitor
>Vishay
#Diode
#Transistor
database like following
tb_company
ID name profile website
1 Yageo *** ****
2 Vishay *** *****
tb_product
ID name category
1 yageo resistor
2 yageo capacitor
3 vishay diode
4 vishay transistor
How can I do to get a page above?
View 4 Replies
View Related
Oct 18, 2004
I am very new to access and have a question which I think is very easy to answer. What I have is an access file with a listing of companies, their contacts and what services we provide for them. (each company/client/service is listed in a row with each new set of information on the row below it).
What I am looking to do it to create a data access page that anyone in our office can view. I want the access page to have a text box where they can type in the name of the company, then click a 'search' button. That will then display the results in a box below everything. The results would be the contact and the services (there are other columns in the datasource as well, but I didn't list them).
If anyone can shed some light onto my problem it would be most appreciated!
Thanks
View 3 Replies
View Related
Jun 2, 2015
I want to create a main menu page for my database. I have tried the Navigation form and obviously I am doing something wrong....because the tabs won't open the forms. We have Access 2010 at work and I would like to create something similar to this:
Cardinal Rap - Main Menu
[button] Input Monthly data
This button would take me to another screen that would list the tables for appropriation, expenditures and revenue, each with their own respective button
[button] Reports
This button would take me to another screen that would would list the reports available each with their own respective button
[button] Monthly reconciliations
This button would take me to another screen that would list the tables necessary for my monthly reconciliations each with their own respective button that open that table.
The tabs in the Navigation form don't seem to do anything.
View 1 Replies
View Related
Nov 12, 2013
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.
View 3 Replies
View Related
Nov 22, 2004
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
Deleware
Dover
-------------------------------------------------------------------------------------------
Thanks !
View 1 Replies
View Related
Jun 13, 2015
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.
View 1 Replies
View Related
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
Oct 21, 2013
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.
View 2 Replies
View Related
Apr 20, 2014
I have a report that should only show 1 page yet I have 2 and one is blank . I cannot find out why?
View 3 Replies
View Related
Oct 23, 2014
I am trying to create an invoice report. I want to add all the costs from the detail section in my footer. I have accomplished this in either the Report footer and/or the page footer, but the problem is that the report footer doesn't go to the bottom of the page, and the page footer doesn't go to just the last page. I have tested a bunch of suggestions that don't seem to work.
1. Print page footer with Report header = NO - only works if your report is two pages or more.
2. Private Sub PageFooterSection_Format(Cancel As Integer, FormatCount As Integer)
If Page = Pages Then
Me.[TextBoxName].Visible = True
Else
Me.[TextBoxName].Visible = False
End If
End Sub
The Page functions worked, but it did not change the results from page to page. If it was a two page report, then the if statement is false and the text box was not visible on page 1, but it also was not visible on page 2.
View 1 Replies
View Related
