General :: Publishing Access Database On Web - Convert To HTML?
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 Replies
ADVERTISEMENT
Feb 4, 2013
My office recently purchased Microsoft Access for our secretary to keep track of our contacts. No other employee owns Access so we have to distribute the tables through Access Runtime. However, there seems to be a problem.
I save and publish a database using the Packaging Wizard. I then send the associated folder with the install program to a computer which has Access Runtime installed on it. But, when I install the file I created with Packaging Wizard it just opens an Access window that is completely blank. It's actually the same thing that occurs when I try to open an Access file on a computer that doesn't have Access or Runtime installed on it at all.
View 7 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
Sep 18, 2012
I have a database to send e-mails from access trough Outlook. The issue is that I would like the body of the e-mail to have hyperlinks, colours, bolds and that I can get it from plain text.
This is the code I have:
Dim MyDB As Database
Dim MyRS As Recordset
Dim MyTable As Recordset
Dim objOutlook As Outlook.Application
Dim objOutlookMsg As Outlook.MailItem
Dim objOutlookRecip As Outlook.Recipient
Dim objOutlookAttach As Outlook.Attachment
[Code] ....
How can I make the body to be HTML format, or, can I have a e-mail template storaged in my PC and then indicate to use it whenever the e-mail is sent?
View 4 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
Sep 27, 2006
Hi,
A few years ago I’ve made an access database on access 2000. The problem is that now I’ve installed the office 2003, and I can’t make the database work properly.
At first says that are missing those files: “tshoot.ocx”, “msioff9.ocx” and “msowc.dll”; so, I’ve copy them from another computer using office 2000 and now only complains about “msioff9.ocx” saying that my database contains a reference incomplete to it.
Is there no other way to convert my database do work properly with access 2003? What can I do?
Regards
View 2 Replies
View Related
Dec 29, 2006
I have a request to convert a Microsoft Access 2000 database from english to spanish. Can this be done easily?
View 1 Replies
View Related
Oct 29, 2005
Hi,
just starting out building a database product for mineral collectors and wanted to know what to do went it is complete.
If you want to issue the finished collectors data base as an application to other users do you need a program generator?
I have heard o the Access tollbox, does this do carry out the generation?
Thanks
View 1 Replies
View Related
Aug 26, 2004
I want to publish my access database on my local pc and was thinking of using something like Dreamweaver to do this. Is this possible? I don't want to put this on the webserver but on my local machine (only a few people will be connecting), and I've read something about a Personal Web Server so this could be done. Does anyone have any ideas / thoughts on the best way to do this? Oh, I want the database / web to be "live" so the tables get updated as they are changed over the web.
View 3 Replies
View Related
Oct 21, 2013
How can I convert a web Access file to desktop aplication? I've created it from a model from Office.com, but I need create code in vba and it don't permit.
The use of file is only in desktop.
View 3 Replies
View Related
Aug 7, 2015
I have files that have extension of TSV which are text files but viewable in exel. I figured out a way for the user to click on a button in Access which does the following
1. Run Macro in Excel: The macro prompts the user to select the TSV file. After selection, macro opens the employee.tsv file in the excel (with excel being invisible) and saves it as employee.xls
Code:
Sub SaveTSVtoXLS()
Dim myPath As String
Dim myString As Variant
Application.DisplayAlerts = False
With Application.FileDialog(msoFileDialogOpen)
[Code] .....
2. Imports the Excel file (employee.xls) into two tables: tblEmployee and tblDepartment using the following codes.
Code:
DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel12Xml, "qryDepartment", selectFile, True - 1, "A1:C2"
DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel12Xml, "qryEmployee", selectFile, True - 1, "A1:AE2"
Everything is working flawless except that the user has to select the file three times:
1 time for the tsv
2 times for the xls file
Is there a way that the user can select the file only once (tsv file) or at least only twice one of the tsv file and the other for the xls file?
View 8 Replies
View Related
Sep 24, 2003
Hi all,
It's my 1st posting! Need help on how to get Unbound OLE objects (i.e. lines, pics, et.) reflected when publishing my Access report into MS Word. So far, only the data are exported. Appreciate your help.
System Info: Intel Celeron 700MHz, W98SE, MS Access 2002
View 4 Replies
View Related
Dec 6, 2012
Having experimented with Access for a few months now; I know you can link an Access Database to SharePoint, and you can export Excel files into Access for inclusion in tables.
My question is; If I have a daily report being produced, through script, with an excel output. Is there anyway to automatically publish this in Access, negating the need to manually go into Access to import?
View 5 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
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 2 Replies
View Related
Sep 30, 2012
TextBox1 is Rich Text:-
I want to replace my String ("Evidence required of this please" ) in this code 1) following which works fine, with a variable (textToPaste) as in code 2) which doesn't work.
1) TextBox1 = "<div><font style=""BACKGROUND-COLOR:#FFFF00"">Evidence required of this please</font>"
2) TextBox1 = "<div><font style=""BACKGROUND-COLOR:#FFFF00"">textToPaste</font>"
Can I persuade the statement to accept "textToPaste" as a variable and not a normal string?
View 3 Replies
View Related
May 10, 2014
I would like it to be formated the same on the web page as it is in the MS Access code module.For Example:
Code:
Private Sub Form_Open(Cancel As Integer)
' Minimize the database window and initialize the form.
' Move to the switchboard page that is marked as the default.
Me.Filter = "[ItemNumber] = 0 AND [Argument] = 'Default' "
Me.FilterOn = True
[code]...
Is there a free online HTML code editor that will do this?
View 7 Replies
View Related
Jul 8, 2014
I Am working on a Access database that will build a excel spread sheet, that will be uploaded to Ebay via file exchange. I am looking to build a forum that will edit parts of a Html text in a column, such as the size and color.
View 1 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
May 4, 2007
.HTMLBody = .HTMLBody & "<LI>Resolution Description: " & Nz(Me!ResolutionDesc, "")
How can I keep the formatting of the ResolutionDesc memo field (ie Line Feeds and carriage returns) when I add it to an HTML email like this?
Thanks
View 4 Replies
View Related
Oct 17, 2005
Hello,
Is is possible to save Access forms in HTML and add data using these forms withouth any kind of special software?
I would like to interact beteween MS Front Page and Access.
I will use front page to design my web site and map to the tables in Access into which add or query data.
Thanks.
View 2 Replies
View Related
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
Aug 29, 2004
I'm updating a database that automatically sends an email to the drafts folder of Outlook. The developer that created the database used VBA code to call html code written in a table. The html code contains the body of the letter. I've figured out most of it but I need to include a date (one month from the current date) in the body of the letter. Unfortunately I've been researching java script and html all weekend and still haven't managed to figure that one out. Can anyone out there help with this? Also is this normal to include html and javascript in Access, I have never seen it before. Are the benefits good? I have serious studying to do if this is the case.
View 1 Replies
View Related
Nov 30, 2004
Hello all..
I have an HTML template with about 15 TAGS built in to it..such as:
[SKU]
[MITVALUE_TITLE]
[MITVALUE_ACCESSORY1]
[MITVALUE_ACCESSORY2]
[MITVALUE_ACCESSORY3]
[MITVALUE_ACCESSORY4]
[MITVALUE_ACCESSORY5]
[MITVALUE_ACCESSORY6]
[MITVALUE_ACCESSORY7]
etc. etc. etc...
Now I would like to somehow populate those fields from the tables that i have.. (The all have a common "related" field)
example:
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
"http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<title>Untitled Document</title>
<style type="text/css">
<!--
.style10 {color: #FF0000; font-size: 12px; }
-->
</style>
</head>
<body>
<table width="100%" height="100%" border="0">
<tr>
<th height="23" colspan="2" scope="col">ITEM INCLUDES:</th>
<th width="30%" height="100%" rowspan="4" scope="col"><a href="[MITVALUE_PHOTO5]" target="_blank"><img src="[MITVALUE_PHOTO5]" width=266 height=200 border="6" align="right"></a></th>
</tr>
<tr>
<th width="73%" height="23" colspan="2" scope="col"><p align="center">[MITVALUE_ITEM]</p></th>
</tr>
<tr>
<th width="10%" height="23" scope="col"><div align="left"></div></th>
<th width="38%" scope="col"><div align="left"><font size="2" face="Arial"><b><font color="DADADA" face="Verdana, Arial, Helvetica, sans-serif"><font color="0D4587"> </font><font color="#000099" size="2" face="Arial, Helvetica, sans-serif">[MITVALUE_ACCESSORY1]<br>
</font><font size="2" face="Arial"><b><font color="DADADA" face="Verdana, Arial, Helvetica, sans-serif"><font color="#000099" size="2" face="Arial, Helvetica, sans-serif">[MITVALUE_ACCESSORY2]</font></font></b></font><font color="#000099" size="2" face="Arial, Helvetica, sans-serif"><br>
</font><font size="2" face="Arial"><b><font color="DADADA" face="Verdana, Arial, Helvetica, sans-serif"><font color="#000099" size="2" face="Arial, Helvetica, sans-serif">[MITVALUE_ACCESSORY3]</font></font></b></font><font color="#000099" size="2" face="Arial, Helvetica, sans-serif"><br>
</font><font size="2" face="Arial"><b><font color="DADADA" face="Verdana, Arial, Helvetica, sans-serif"><font color="#000099" size="2" face="Arial, Helvetica, sans-serif">[MITVALUE_ACCESSORY4]</font></font></b></font><font color="#000099" size="2" face="Arial, Helvetica, sans-serif"><br>
</font><font size="2" face="Arial"><b><font color="DADADA" face="Verdana, Arial, Helvetica, sans-serif"><font color="#000099" size="2" face="Arial, Helvetica, sans-serif">[MITVALUE_ACCESSORY5]</font></font></b></font><font color="#000099" size="2" face="Arial, Helvetica, sans-serif"><br>
</font><font size="2" face="Arial"><b><font color="DADADA" face="Verdana, Arial, Helvetica, sans-serif"><font color="#000099" size="2" face="Arial, Helvetica, sans-serif">[MITVALUE_ACCESSORY6]</font></font></b></font><font color="#000099" size="2" face="Arial, Helvetica, sans-serif"><br>
</font><font size="2" face="Arial"><b><font color="DADADA" face="Verdana, Arial, Helvetica, sans-serif"><font color="#000099" size="2" face="Arial, Helvetica, sans-serif">[MITVALUE_ACCESSORY7]</font></font></b></font></font></b></font></div></th>
</tr>
<tr>
<th height="23" colspan="2" scope="col"><span class="style10">THIS ITEM ONLY INCLUDES ITEMS LISTED ABOVE </span></th>
</tr>
</table>
</body>
</html>
................................................
I would like those fields to be put in automatically.. wether they are in a memo field within a table or a field within a query ... it really doesn't matter.... Anyone have any ideas?
Regards,
OvAdoggvO
View 3 Replies
View Related
May 14, 2007
Hi im kinda a newbie here so, any helpful comments or links of creating a ms access database where it can be viewed in html is welcome. thanks
View 1 Replies
View Related
