Hi,
Is there a good developer tool for turning an access db into a webpage?
Or should I go about it in a completely different way?
I want it to work just as it does, but I would like to have it on the www.
Fuga.
I am just checking to see if anyone knows of a way (or a plugin download) that will allow me to create some sort of box that has a pre-specified website in it. It would be something like www.usps.gov, because sometimes our reps need to look something up, and it would be nice to have it right there. But the website that they will use has a login/password. So i will need some sort of "reset" button that will take them back to the main page in case it times out. Anyone know of anything?
View 5 Replies View RelatedHi,
I've currently got apache/asp up and running, I'm just wondering how I display an access database, or if there is any tutorials about to do this.
I should point out here, that ASP is an entirely new language to me, and I really haven't got a clue how to write in it, I do have a solid programming with software and such.
What I'm trying to avoid is, some kind of prefab made by "access" itself display, as the data in the database has to be displayed in a certain way.
If anyone could give me some advice on where to start on this adventure, I'd be glad to hear your comments and sudjestions, as I'm currently
I wasn't sure where I should have posted this question so please feel free to move it if necessary.
I am not even sure this is possible and I didn't know where to begin but these forums have always been extremely helpful.
What I would like to do is export data directly from Access (via form, table or query) and populate it directly to an existing, external webpage.
A little background. My company orders cars an for certain manufacturers, Toyota for example, we order via a secure website. All of the other manufacturers have their order directly transmitted to them. The orders for Toyota take 3-4 times longer to place and I was hoping to speed the process by exporting existing order information directly to the webpage.
Please let me know if it seems like I am smoking something and I will gladly step away from the pipe....=)
Thanks in advance,
Brian
I've been attempting to link a ms access database to our company's website, but now each time I try to view the page I recieve the following message:
" HTTP Error 403
403.1 Forbidden: Execute Access Forbidden
This error can be caused if you try to execute a CGI, ISAPI, or other executable program from a directory that does not allow programs to be executed.
Please contact the Web server's administrator if the problem persists. "
...rude.
Here is the code...
<%@LANGUAGE="JAVASCRIPT" CODEPAGE="1252"%>
<!--#include virtual="/Connections/TRIAL2.asp" -->
<%
var Trial2 = Server.CreateObject("ADODB.Recordset");
Trial2.ActiveConnection = MM_TRIAL2_STRING;
Trial2.Source = "SELECT * FROM [website update] ORDER BY Price ASC";
Trial2.CursorType = 0;
Trial2.CursorLocation = 2;
Trial2.LockType = 1;
Trial2.Open();
var Trial2_numRows = 0;
%>
<%
var Repeat1__numRows = -1;
var Repeat1__index = 0;
Trial2_numRows += Repeat1__numRows;
%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<title>Untitled Document</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<style type="text/css">
<!--
.style6 {font-size: 12px; font-family: arial;}
-->
</style>
</head>
<body>
<table width="82%" border="1" cellspacing="0" cellpadding="0" summary="List of property details">
<tr>
<th width="22%" scope="col"><span class="style6"> Code </span></th>
<th width="18%" scope="col"><span class="style6">Address</span></th>
<th width="28%" scope="col"><span class="style6">Suburb</span></th>
<th width="17%" scope="col"><span class="style6">Price</span></th>
<th width="15%" scope="col"><span class="style6">Title</span></th>
</tr>
<% while ((Repeat1__numRows-- != 0) && (!Trial2.EOF)) { %>
<tr>
<td><%=(Trial2.Fields.Item("Property Code").Value)%></td>
<td><%=(Trial2.Fields.Item("Address").Value)%></td>
<td><%=(Trial2.Fields.Item("Suburb").Value)%></td>
<td><%=(Trial2.Fields.Item("Price").Value)%></td>
<td><%=(Trial2.Fields.Item("Title").Value)%></td>
</tr>
<%
Repeat1__index++;
Trial2.MoveNext();
}
%>
</table>
</body>
</html>
<%
Trial2.Close();
%>
I can't find any info on this error through google, so i'm not sure what step to take next. Any advice would be great, I'm willing to try out other databases (obviously retyping the data would be a pain in the arm but if it works its worth it)
Cheers:p
I am trying to put my form on the internet so that many users can access the form, that way I can keep one copy of the database and have everyone simply use the webform to edit it. I have converted my forms into webpages and all seems fine except my subforms dont show. Also, my comboboxes become text boxes. How can I stop this from happening? Once I have everything in order, how would I go about putting the forms on the internet for use? Is it possible to password protect the form, so only certain people can use it?
Any help would be GREATLY appreciated.
Thanks,
JetBlack
Right, I knew this day would arrive and have somewhat been dreading it but excited by the idea of a new development at the same time.
We have a database within the school on our server that staff would like to be able to access at home through the internet. They will need to be able to view, add and edit data. What is my best way of doing this for someone who has never done this before?
Is it possible just to put a link on a website? or do I have to covert?
Is the MSAcces dataaccess pages something i should look at? Should I use VB.NET? ASP.NET?Frontpage? Everyone seems to have a different take on this from the forum but most of the advice was quite old. So what do you all think out there?
And How can I learn really really fast? Any online tutorials or Books people can suggest would be ever so helpful as well.
Thanks alot in advance for any support you are able to give me with regards my best route of action.
MS Access 2000 - Quite simply, on a form I have an Email field and I have the "Is Hyperlink" property set to yes. In the On-Click event of this email field I use this single line of code below to open a new outlook (2007) email with the address already entered. Staff will be entering the email address themselves as part of the clients contact details Form.
Code:
FollowHyperlink "mailto: " & [Email]
This is all fine, however access also tracks [URL] .... onto the end of the email address and tries to also open a web page which obviously fails.
Is there something somewhere I can tweak that tells access to always only treat the text in this field as an email address, and when clicked open an email?
In addition to my Intro to Access class, I am taking a Web Programming class, which has the same general assignment, but for Web pages, instead of an Access database; create at least 3 pages, 1 each for financial data, customer relations and product/service info.
I would like to create a small Access database connected to a Web page. I won't have a server, but I can run everything off a computer. I have a book that tells me the steps to do all this, but I'm supposed to install MS SQL Server (I chose to download MS SQL Express Server), and I can't get Access to talk to it. Among other things, I noticed that I could not stop SQL Server, nor could I start SQL Browser. I did enable TCP/IP (I think). I uninstalled the whole thing, thinking I could start from scratch.
How to publish my database on a Web page.
How would I setup a hyperlink to a web page, from Access?
View 1 Replies View RelatedWe need to enter the string INCL as a data value in one of our tables. When we try to exit the field, Access keeps changing it to INCLUDE. This occurs whether the value is entered via a form or directly in the table. I assume it is doing some type of autocorrect based on th spelling. There is no VBA code associated with this field.
Is there some way to turn this off?
I am doing a project which currently requires me to input a new file we just got. However, the dates on all of them, as in the field containing the dates, displays something like 20030608 instead of June 8, 2003. I was thinking I could just run the file through a looped vb array to go through the information, reformat it, and then dump it into a new column.
View 2 Replies View RelatedI would like to turn a cell red in a query - is this possible or can this only be done in a form or report. I have created a table with medical information and want the cell to turn red when blood pressure entry is greater than 140. Not sure what and where formula should be entered.
View 3 Replies View RelatedHere is my code:PHP Code:<%@ Page Language="VB" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<script runat="server">
Protected Sub Button1_Click(ByVal sender As Object, ByVal e As System.EventArgs)
Dim Dbconnection, sqlcommand, dbcommunication, dbread
Dbconnection = New Data.OleDb.OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;data source=" & Server.MapPath("LAM.mdb"))
Dbconnection.Open()
sqlcommand = "INSERT INTO Customers([CustomerID],[LastName],[FirstName],[Title],[BirthDate],[Address],[Town],[County],[PostCode],[HomePhone]) values ('" & CustomerID.Text & "', '" & LastName.Text & "', '" & FirstName.Text & "','" & Title.Text & "', '" & BirthDate.Text & "', '" & Address.Text & "', '" & Town.Text & "', '" & County.Text & "', '" & PostCode.Text & "', '" & HomePhone.Text & "')"
dbcommunication = New Data.OleDb.OleDbCommand(sqlcommand, Dbconnection)
dbread = dbcommunication.ExecuteReader()
dbread.Close()
Dbconnection.Close()
End Sub
</script>
<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<title>Untitled Page</title>
</head>
<body>
<form id="form1" runat="server">
<div>
<asp:TextBox ID="CustomerID" runat="server"></asp:TextBox><br />
<asp:TextBox ID="LastName" runat="server"></asp:TextBox><br />
<asp:TextBox ID="FirstName" runat="server"></asp:TextBox><br />
<asp:TextBox ID="Title" runat="server"></asp:TextBox><br />
<asp:TextBox ID="BirthDate" runat="server"></asp:TextBox><br />
<asp:TextBox ID="Address" runat="server"></asp:TextBox><br />
<asp:TextBox ID="Town" runat="server"></asp:TextBox><br />
<asp:TextBox ID="County" runat="server"></asp:TextBox><br />
<asp:TextBox ID="PostCode" runat="server"></asp:TextBox><br />
<asp:TextBox ID="HomePhone" runat="server"></asp:TextBox><br />
<br />
<asp:Button ID="Button1" runat="server" OnClick="Button1_Click" Text="Button" /> </div>
</form>
</body>
</html>
It says the problem is with: PHP Code: dbread = dbcommunication.ExecuteReader()
Can I get some advice on this please,
Jane
I try to open a web page with a form in access 2007. During the loading of the page it shows me 2 security error messages.
I tried to change the properties in Activex and especially the Silent property from No to Yes but this is not possible. In the next restart of the form restores the original settings.
When i open the same page with Internet Explorer it doesn't show any error. I have attached the database example to see exactly what happening.
I am using Access 2007 to update a page on an external website (amongst other things) from an Access form using VBA, but that page has recently changed. I have dealt with most of the issues around this, but there is still a problem that I cannot see how to resolve. Previously all the fields on the page were uniquely named, and so I was able to assign values from my form to them using
Code:
.document.all.item(fieldname).value=...
But now there appear to be identically named fields on the webpage and I cannot see how to differentiate between them in my code. I have attached a text file with the two relevant sections, containing the HTML for the two relevant sections on that page only (the code for the whole page runs to 8000+ lines and I can add the lot if really necessary) and as you will see the names for things like runs (name="result[][runs]") and wickets ("result[][wickets]") are the same in both sections. So how do I tell one from the other in my code?
Currently I have the following:
With objIE
.Visible = True
....
'1st innings - new HTML field names but duplicated on the webpage
.Document.all.Item("result[][runs]").value = nz(Me![runs_for#])
.Document.all.Item("result[][wickets]").value = nz(Me![wickets_for#])
[Code] .....
How can I differentiate between the HTML field names in the attached file as simply as possible in my code above?
I'm using "Application.FollowHyperlink" to send parameters to a remote application.
Each time i hit the enter button an 'After Update' event opens a web page.But i don't want the web page to be opened.
is there another method to send parameters over the web without opening a web page?
I have written a html page that posts a form to a .asp page, which in turn is supposed to write data to a MS Access database. Problem is while my html page works, and my .asp page seems to work fine as well, nothing is being saved to my database!
I'm not sure if its something wrong in my .asp page...
Code:
<%@LANGUAGE="VBSCRIPT" CODEPAGE="65001"%>
<% Option Explicit %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
[code]....
or if you think there may be some configuration in my database I'm missing. Just an FYI all the database table columns take empty values.
I have a table with data structured like this:
Emp#STOT
--------------------
301741421540
301801882518
3020024000
30223227166
I want to create a query that takes that data and does this:
Emp#STOT
--------------------
3017414210
301740540
3018018820
301800518
3020024000
3020000
3022322710
30223066
Is that even possible? How do I get started?
Hi all.
I have been tasked with replacing an external database in house and obviously the external database has multilpe tables joined by various id fields. I'm assuming when they created the db they were assigned autonumber qualities etc to create unique numbers.
However, I can't replicate that in mine. I have the external references for existing data fine. But ho do I now create a new record with a unique number in the existing field.
I tried setting it to primary key and/or no duplicates etc but it's expecting me to enter a number.
I imagine I've got to set some kind of loop to count from one and matech it and then when it finds a number not currently in use it'll stop and use that but how to do that........
Cheers for any help.
Hello, I have a query that returns a list of courses undertaken by certain employees. They are in the format NPTC CS 30; NPTC CS 31; NPTC 33; NPTC FTC 38; NPTC FTC 40 etc...
Anyway what I need to do with this is convert these results to a string and manipulate them in such a way that they can be displayed in a text box on the back of an ID card in the following format:
NPTC CS 30, 31, 33, NPTC FTC 38, 40... etc.
Because there is not enough room on the back of the ID card to use a subform to just display them in a list...
Hi,
I have two main forms which are essentially the same apart from some command buttons, one form to enter data, one form to view data.
These forms also contain about 8 subforms, in Data Entry mode (for the data entry form, funnily enough).
Problem is, obviously when I open my form to view records, the subforms don't update as I flick through, due to them being in data entry.
What's the easiest way to prevent this problem? Obviously I'll need to turn data entry off, but was wondering whether there's a more elegant solution than either creating 8 duplicate subforms with data entry turned off, or using about 50 lines of code to turn Data Entry off/on every time.
Thanks,
Toby
I'm filtering a sub form in datasheet using an option group frame, and the on click does exactly what I want it to do.However, Once I'm done filtering, I can either set the filter to all ...
Code:
Case 1
Forms!frmmain!frmtoplinelist.form.FilterOn= False
Or click a Button "Remove Filter"
Code:
Private Sub btnClear_Click()
Me.frmTopLineList.Form.FilterOn = False
End Sub
(I've tried both references to the subform too... "Me." and "forms!etc. However, the subform filter isn't switching off.
im doing my ict unit 7 edexcel ict exam atm and as one of the tasks we have been asked to generate the testid. the test id consits the year a underscore and then the number of the month so for example if a test happened this year and this month the test id should be 2013_5. i can get the year and the underscore into the code to generate the testid but im not sure how to get the month to change to a number so for example if i select may from a drop down the code needs to take that and generate it into a number.
View 6 Replies View RelatedI have a table in a database where the telephone numbers are in two separate fields, i.e. [123] (which is the areacode) and [456-7899]. Is there a way to take the two fields in this table and put combine these two numbers into one field so the new field will be in this format.... [123-456-7899]?
View 9 Replies View RelatedI have a file structured as listed below. I need to pivot Patient Id, Patient Name, Send Reason, Provider Name and Visit Number into columns and then insert the values into the corresponding columns.
My data set contains about 1,000 rows, so I cannot simply paste special in Excel.
Patient ID 111111
Patient Name Doe, Jane
Send Reason Cannot resolve provider
Provider Name Doe, John
Visit Number ABCD#F1234567
I have tried Pivot and Transform, neither of which seems to work.