Modules & VBA :: Taking Data Form A Web Page

Aug 12, 2013

I am successfully using some code to open a web page and log in for me.

Code:

Dim ieApp As InternetExplorer
Set ieApp = New InternetExplorer
ieApp.visible = True

[Code] ....

The bit I am really stuck on and still after reading various posts and googling I cannot seem to get a bit of code to read a value from the web page.

<tableborder="0"cellpadding="0"cellspacing="0"class="linktable">
<tr><thcolspan="2">Status</th></tr>
<tr><tdvalign="top"style="width: 50%">
<divclass="fieldset"id="general_info">

[code]...

View Replies


ADVERTISEMENT

Modules & VBA :: Opening New Form And Taking Data From Another

Jul 19, 2013

IThe db has a form called ClientFormNew which logs client details into a table called Clients.Each client has a unique client ID in the table called ClientID. Sometimes Clients call back for further information and we want to log that information into a related table called ClientHistory.Each record in the ClientHistory table has a unique ID called HistoryID which is the same number as the ClientID so these fields are related.

When a client calls back and the telephone adviser opens up the ClientFormNew form and discovers they have called before they need to click on a button called Client History which then opens up the ClientHistoryForm..I am struggling with the code to put on the Client History button as I want the new form to display the details of the clients first contact then allow details of the second contact to be added in a new row. Also the new form needs to show all that client past history which would be in the form of the following fields from the ClientHistory table.HistoryID, ContactDate, Name, ContactMethod, ContactReason, AdviceGiven, Notes.

View 2 Replies View Related

Modules & VBA :: Taking Access Data On Button Click And Putting It Into Excel

Jun 23, 2015

I have a database that had some code that enabled the user to click a button and it would take information from one Access query or table and paste it into specific locations in Excel. This is important because the last worksheet has specific formatting in place.

If it didn't, I'd just use the transfer spreadsheet option and not even bother opening Excel at all with code.

I've got it working well except for the last part. The last query being copied has eight records and only one is being sent to Excel. Same code as the other queries where all of their data is going to the right spot in Excel with the right number of records.

Private Sub AM_Top_25_Click()
DoCmd.SetWarnings False
DoCmd.OpenQuery "delete_ShortPartItems", acNormal, acEdit
DoCmd.OpenQuery "append_to_Short_Part_Items", acNormal, acEdit

[Code] .....

View 3 Replies View Related

Forms :: Taking Data From Form And Placing Into Table

Nov 20, 2013

I have a form that I am inputting data into. I have been able to Clear the form. I have created an edit script and it brings the data from the table to populate the form. When I try to change the data in the form and run a VBA update to push the data down to the table I am having no luck. I can add/Delete recordswith no problems but I can't edit them and put them back in the table. I am novice and just learning the formats and scripting.

View 7 Replies View Related

Modules & VBA :: Reading Web Page Source Code Data?

Feb 13, 2014

Any method of reading web page source code data.

I am trying to create an event similar to a web query in Excel.

The table in question is not a html table but an asp.net table I think.

View 3 Replies View Related

Taking Data From Another Table

Feb 16, 2007

Hi All

I have a quick query. I have a table with a Account Code and its relavant Account Name.

What im tyring to do is in a query or another table, which has 17000 rows of data and the account code has been used in each entry. What i'm trying to do is to be able to create another column where the relavant Account Name can be next to Account code in the query or table.

Could someone please help.
Thanks
Anna:)

View 2 Replies View Related

Data Entry - Not Always Taking In Database

Jul 27, 2006

I am having a problem where I have a form that I enter data into. Sometimes when I enter the information it will add a record to the table and sometimes it doesn't. It doesn't put the information in the table more times than it does.

I have tried to enter the information outside the form and it still does the same thing.

Do you have any suggestions of what I can do to fix this.

Thanks

View 3 Replies View Related

Taking Data From Forms Every Month

Nov 21, 2005

I have a database set up with charts which plot information about support for "quality" purposes.
I have reports that work out the percentages but i would like to be able to take the percentage figure (say on the 1st of each month) and add it to a graph which will then be able to show the figures from the last 12 months so i can see how well the support is performing.
Any help would be greatly appreciated

View 3 Replies View Related

Data Access Page Filter Refresh The Page

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

Modules & VBA :: Calculating A Date While Taking Into Account Holidays

Mar 17, 2015

I have been looking for quite some time for some vba code that would return a date based on values in 2 fields.

In other words, I already have a field that returns transit days based on the customer chosen. End users will then enter a DueDate for the order. I want a field that returns a "ScheduledShipDate" based on [DueDate]-[TransitDays]. The part that makes this more difficult, in my opinion, is the fact that I also need to take into account some specific holidays.

I have already constructed a table with a list of the 6 company holidays and their corresponding dates. [tblHolidays.HolidayDate]

Unfortunately, my vba knowhow might as well be limited to copy and pasting as I do not need to use it all that often.

View 14 Replies View Related

Taking Data From Table1 Modify And Output To Table2

May 25, 2006

hey all,

bit of a head scratcher for me here.

i have a database and i need to be able to read all the records from table1 modify the data and output the data to table2 and I would prefer this to be done via just one button in a form so im guessing VBA need to be used.

table1 consists of an ID field, firstname field, lastname field and date field.

table2 has ID field, full name field, date field

so i want to read the first and last name and date from table1, merge the first and last name and then output the merged names and date to table 2.

ive googled around and all ive come up against is recordsets but im having a hard time actually getting them to even work.

any help is appreciated.

cheers

Matty

View 6 Replies View Related

Modules & VBA :: How To Open Form With Page Up Screen

Dec 26, 2013

My form opening with page down screen, how could I open it with page up screen?

View 7 Replies View Related

Saving A Form As A Data Access Page

Apr 16, 2007

Hi

I want to save an open form as a data access page. Is there any code to do this and bring me directly to the file location dialog or do I have to use the DoCmd.RunCommand acCmdSaveAs command and then choose data access page from the dialog box?

Also, is there a way of saving a form as a data access page, without opening the form?

Many thanks

AL

View 1 Replies View Related

Modules & VBA :: Find Previous Date Taking Into Account Weekends / Bank Holidays

Mar 25, 2015

I want VbA code to find a date 1 less than todays date taking into account weekends/Bank Holidays.

View 8 Replies View Related

Forms :: One Page Form Printing Blank Second Page

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

How To Continue A Form Page After Page Automatically

Jul 9, 2005

to automatically create a second, third, fourth... page depending on how many characters are in the narrative. The only other thing needed to be changed is the page# of Page#.

So right now my form looks like below


CAD#
Person name
Charge

Narrative
"
"
"
"
"
"
"
"
"
"
"
"
"

Officer name date page # of #


Thanks in advance.

Matt

View 1 Replies View Related

Calendar On Page 1 Also Displaying On Page 4 Of Form

Sep 3, 2006

Hi All

I have added the Allen Browne Calendar 2k control to my form.

My form consists of 4 pages. On pages 2 and 3 I have subforms and on page 4 I have Personal data. Page 1 is general data and the Calendar is on Page 1.

What is happening is that the Calendar is also being displayed on my 4th page, in the same position as page 1. When I try to move it, cover it or delete it from page 4, it is also gone from page 1.

Any suggestions please?

Many thanks
Tee :(

View 6 Replies View Related

Going From Page To Page In A Tabbed Form

Oct 25, 2005

I have a form with six tabbed pages on it. Since data entry follows in a logical order I would like to put a command button on the bottom of each page (subform) that can be used to go to the next page. What I am going to though? If i put a command button (open form) then it opens the whole form not as a subform on a tabbed page. if I try and put a command button (open page) then it will not let me enter the page number. Hope that makes sense! Any ideas

View 3 Replies View Related

Modules & VBA :: Datasheet Mode Form For Both Data Entry And Data Retrieval

Feb 9, 2015

I want to use the same form in datasheet mode for data entry and retrieval. When retrieving, all controls are disabled and locked. I am trying to enable and unlock them for modifying but that isn't working.

<code>
DoCmd.OpenForm "PO_Practice Data", , , , acFormEdit, acHidden

Forms![PO_Practice Data]!PO_Name.Enabled = True
Forms![PO_Practice Data]!PO_Name.Locked = False
Forms![PO_Practice Data]!Practice_Name.Enabled = True
Forms![PO_Practice Data]!Practice_Name.Locked = False

[code]...

View 3 Replies View Related

Data Access Page

Oct 2, 2005

Is it good to use (to make) Data Access Page to access the database (and put it on the web ) ?? :confused:

View 1 Replies View Related

OLE In Data Access Page

Oct 19, 2005

I have a photo (jpg format) which store OLE field in a table. But, I would like to display it in a Data Access Page. But, I have being prompt the following error: "You tried to drop an OLE or long binary column onto your data access page. There is no HTML control which binds correctly to this column type."

Do anyone know how to overcome this problem?

View 1 Replies View Related

Data Access Web PAge

Apr 12, 2006

Hi,

Can anyone tell me how I can get my data input web page to load with a new fresh input page. At present, each time a user opens the form, it displays the last record that was input previously.

When using a form, the record properties can be changed so that when the form is opened, it displays a new blank record to fill in. I cannot find any properties in the web page design view that allow it to be set to startup with a new blank page rather than the last record that was entered.

Any suggestion?

Thanks

View 1 Replies View Related

Data Access Page Help

Jul 31, 2006

Hi,

So i have made a Data Access page using the wizard from a table called Employees
I want the Access page to have some sort of search button so that they can quickly find an employee, rather than scrolling through all 100 records.

How can i do this?

Thanks Brian

View 2 Replies View Related

Data Access Page Help

Jan 15, 2007

Hey guys,

I'm somewhat new to MS Access. I'm trying to allow a user to update, add/delete records through a data access page. I am able to view the query, navigate through the results, but I am not able to make any changes. I get a pop up message saying the record set I am using is read-only. As far as I know, my table is fully editable. Anyone have input on this issue?

View 5 Replies View Related

Data Access Page

Sep 1, 2007

Hi All,

I have created a Data Access(DAP) Page to append the sales order received on phone. The Data Access Page is linked to query which has autonumber field to store the Sales Order. I have a textbox on DAP for Sales Order No. The autonumber generated in Table is different from autonumber generated on DAP. I want same the autonumber on page and in table.


Thanks for time.

S Acharya

View 3 Replies View Related

Data Access Page

Oct 3, 2007

Hello Everyone,

Can you allow the users to update and edit the data access page and actually change the data in the database? Or is it just a view only? If possible I need the user to be able to update the database through the data access page.

Is this possible?

Any ideas would be helpful.....

Thanks

View 1 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved