Hi,
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 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?
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....=)
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)
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?
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.
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 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 am trying to create a button that opens up a webpage. I get how to create a hyperlink on a button. The problem is, I need to open a specific page depending on the information in a text box.
The text box displays the tracking number for the current record. That number is populated automatically via a control source. The problem is that I need to open different web pages depending on the tracking number displayed. For example, UPS has a specific start to their number (1ZX....). Other trucking companies have a specific format, also.
So how do I tell it to look at the tracking number and then open the corresponding web 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 writing a macro to automate the filling up some data from excel to company website. I have changed the website name in this post for data protection purpose. The excel will login for different clients by using the combination of username and password for respective clients and then some data are required to be inserted in a text box on a web page, I think the text box is on a form and form is within an iframe, within the web page. Once the data is inserted into text box, one button (Submit), which is also on the same form, is to be clicked.
On the click of a button, the updated data appears on another section, I could not make out if it is an form or frame, which is under the abovementioned form. Once we are happy with the way data appears on the web page, we have to click another button (Update), which is on the same section, to finally updating the data on website.
I wrote the following code to login to the website and then to navigate to the web page where I have to fill up the performance numbers in a text box. The first problem is how to access the text box inside the form from VBA so that the macro can write a number in that text box and how to access the button to submit the data. The HTML code, which can be seen on click of F12, is attached below. The second problem is how to access the Update button inside the other section, so that the data will be finally uploaded.
Code:
Sub LoginToCorpAccount() Dim ie As Object Set ie = CreateObject("InternetExplorer.Application")
[code]...
<div id="ssc-consumers-holder"/> -
This the line which gets highlighted when I click on the section where the data appears after clicking the submit button, and from here Update button is to be clicked.
I am trying to get information from webpage. [URL] ....
I am using the code: Set ie = CreateObject("internetexplorer.application") ie.Visible = True ie.Navigate "http://benwerd.com/lab/geo.php" While ie.Busy DoEvents Wend
Here is the info I can't get from the page. Can't find the id or element that hold the information, latitude, longitude ... that is listed in the website.
I have a Contact table and imported data into it from another Access Contact table. All but one field inserted correctly - the "Notes" field from the table I was importing FROM was inserted into the WebPage field of my current table. So now I am trying to update my Notes field in the Contact table from the WebPage field in the Contact table - or move the data over rather. I created an update query but when I try to run it it is asking for the Notes and WebPage parameters.
I have a form that displays minutes. When the minutes are 9 or less it displays as, e.g. 9 instead of 09.
How do I get that leading zero to display?
I read in previous posts that one way was to format as text or date, but I don't want to do that bc the minutes are added up on form save/close. :confused:
I have a point system. What I want it to do is, when the points field reaches 55 I need for the Congrats field to display “Congratulations you are now eligible to advance to the next peer group”
I have a Yes/No field in my table - I would like to display the words in a report instead of the checkmark. How would I display this in a query or report?
I created a combo box which as 2 columns, eg Plant ID and Plant name I need to have the Plant ID on the left and Plant Name on the right which it is at them moment, however....
When I choose an option inthe combo box, it will display the Plant ID number in the textbox because it is on left (its the 1st column in the drop down box)
.... I want it to show the plant name instead, but still have the plant id colun on the left and plant name onthe right when i click the arrow of the drop down box,
sry if its confusing, i need an anwser ASAP, thanks!
Is it possible when loading a control form to set the users default display size to say 1024x768. I'm creating quite a complex form and it will be too large on an 800x600 display.
