Modules & VBA :: Access Textbox And Button Inside Form Of A Frame Of A Webpage
Oct 9, 2013
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.
View Replies
ADVERTISEMENT
May 24, 2013
On a Tab Control inside a from, I've created an Unbound Object Frame, referring to an MS Excel Work Sheet. The goal here is to link that Unbound Object Frame residing on the Tab Control and save the form/link.
Now, when I execute the code, the Object Frame is linked and updated, but when I close the form, the link inside the Object Frame is not saved! However, when I do the exact same thing without placing the Object Frame on one of the pages of the tab, so as regular control inside the form, all works fine.
The code is as follows (performed when I click the button);"OLETest" refers to the UnBound Object Frame placed inside the first page of a Tab Control inside the form.
With OLETest
.Enabled = True
.Locked = False
.Class = "Excel.Sheet.12"
[code]...
View 2 Replies
View Related
Jan 17, 2014
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?
View 2 Replies
View Related
Jul 31, 2013
I'm trying to extract information from Err.Description within a form's Error event. Alas, Err.Description does not seem to be available from there.I have a form that normally displays in DataSheet view. If a trigger on the Oracle back-end raises an error, I want my Access app to be able to parse out Err.Description and deliver a more user-friendly message than ODBC's message. I want to get the info about the message from the error coming back from Oracle, not by matching up error codes.
If I change the form to Single-Form view and put a Save button on it, I can capture Err.Description in the command button's Clicked() event, and then parse out what I need.So if I must display this form in Datasheet view, where can I trap the ODBC error and display my user-friendly message?
View 5 Replies
View Related
Mar 7, 2005
Hi,
I have created a text box for user to enter some descriptions of a particular product. On Enter, i want to have bullets... For example, when the user press enter one time, one bullet will appear, and he/she can continue typing, press enter another time, another bullet appear.Could anyone advise on this?? :(
View 2 Replies
View Related
Mar 29, 2007
I've created a frame but I'm not able to actually to put textboxes inside it, only radio buttons. Is there anyway to force textboxes inside the Frame? Thanks in advanced.
View 1 Replies
View Related
Jan 29, 2014
I have a master form named frmCustomer. I then have a set of tabs (not the navigation tabs) embedded within frmCustomer. The tabs are Invoice (frmInvoice), Contacts *frmContacts), Notes (frmNotes) and Orders (frmOrders). All form are Single Form. There is another form named frmInv that displays an invoice in a formatted manner. frmINV gets its data from a q1uery called InvQ.
It has a criteria that reads [Forms}![frmInvoice]![Invoice_ID]. I placed a button on frmInvoice that calls frmInv. If I run frmInvoice separately outside the tab the correct invoice displays. If I click the buttom from within the tab I am asked to enter the vale of [Forms}![frmInvoice]![Invoice_ID]. How do I call the frmInv form from the tab?
View 5 Replies
View Related
Mar 12, 2014
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.
View 2 Replies
View Related
Dec 9, 2013
I have a textbox with about 400 characters, I also have 5 textboxes next to it. I want to click a button and I want to transfer the characters to the other textboxes 208 characters at a time.
View 3 Replies
View Related
May 4, 2014
I have a mainform with a combobox and a button. What i want is when i click on the combobox and then on the button I want that the textbox in the subform automatically fill in.
The mainform name is FrmTakenInvoerenEnToewijzenAanEenMonteur,
The combobox name is Keuzelijst1,
The subform name is SubTakenInvoeren,
And the textbox name is txtOpdrachtnr.
I tried this code in on button click:
Me.SubTakenInvoeren.txtOpdrachtnr = Me.Keuzelijst1
But that doesn't work.
View 7 Replies
View Related
Mar 10, 2013
I have a Form called X which contains a subform called Y. I have placed this Form inside another form called Z.
There is a CommandButton which when clicked must refer to the Subform. How do I do this?
I tried using [Z]![X]!Y, Form_Z.Form_X.Y, [Z]![X].Y but it throws an error saying the form name has been misspelled ...
View 4 Replies
View Related
Oct 24, 2013
In my database I've encountered a hitch - I've got one form set up to view one person at a time and I've got many records in this database - Is it possible to create a textbox and a button called search that will take me to the record containing this text?
i.e currently im on record abc i type into the text dfe and press search - it will take me to a record that contains that text?
View 1 Replies
View Related
Oct 22, 2014
I have a form which adds in details of components
Sometimes I will need to add a number of components
What I would like to do is add a new line of the textboxes below the orginal when a button is pressed.
In my head I see it working in a similar visual sense to adding multiple attachments
View 1 Replies
View Related
Apr 8, 2015
I have three forms:
Form_A (main form for the application - should always be open)
Form_B (always open, but sometimes has visibility set to false)
Form_C (opens from button on Form_B)
When I press the button on Form_B, the only code behind it is DoCmd.OpenForm "Form_C". This seems to hide Form_B, and open Form_C behind Form_A (which is the main form of the application) inside of an Access window.
I would like Form_C to open in front of Form_B. I suspect that I set up the form incorrectly or something when I created it, and it is therefore opening inside an Access window.
View 1 Replies
View Related
Jun 23, 2005
My subform when i click the New record button on the subform i want it to disable a text box that is on the main form.
Me.Pensioners.Form!quicksearch.Enabled = False
where Pensioners is the name of the Parent Form. Thhis isnt working for one reason or another. Please advise.
View 3 Replies
View Related
Dec 2, 2014
So Access was unable to manage the amount of content that I needed to produce in a single report. The reports contain 12 charts/graphs all of which I needed on separate pages (one chart per page). As such I could not create large enough charts in access to fit to each page, as Access limits the amount of space one can use in a report.
I downloaded Microsoft Reports Builder 3.0 and built my reports as needed and can generate them as desired at current. I'm wondering if there a way to call that RDL file I created to generate my reports from a form control button in Access?
View 3 Replies
View Related
Dec 31, 2013
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?
View 2 Replies
View Related
Aug 23, 2013
I have a form with a tab control and an option group (frame). When I built the layout of the contents of the first tab, the frame responded properly to click events. Now that I have copied them onto the tab control, the events seem to disappear.
(When I check the events for the controls, they are all still there, and selected by the Properties table).
I know it's probably one of the "doesn't use Access very much, does he" type of situations, so how to get these controls working again!
Here is the Form Code listing.
Option Compare Database
Option Explicit
Sub SetSourceDescription()
If Me.frRunMode.Value = 0 Then
Me.lblSourceType.Caption = "Source for this run will be the Extract .pst file(s)"
[Code]...
View 3 Replies
View Related
May 7, 2013
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.
View 3 Replies
View Related
Mar 8, 2007
Here 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
View 8 Replies
View Related
Mar 19, 2013
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?
View 2 Replies
View Related
Nov 27, 2012
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.
View 1 Replies
View Related
Aug 23, 2004
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 Related
Jun 7, 2014
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.
View 9 Replies
View Related
Aug 20, 2012
In Excel, I can dynamically add option controls to a frame on a form using the Control.Add method. Is there an Access Equivalent? I can only find Count & Item as Control. items.
It might have something to do with design view i guess.
View 5 Replies
View Related
Jul 10, 2015
I have a form which contains a textbox called Expire_Date.
When the form is running, the contents of the [Expire_Date] txt box triggers
Some vba to populate another textbox [Flag] with "Valid" or "Expired" based on the date in [Expire_Date].
Textbox [Flag] is conditionally formatted but will only change if you click on the [Expire_Date] field.
Is there a way to use vba to click this field for each entry as there are multiple?
View 1 Replies
View Related