I would like to automate a data entry part on a website however the site is constructed with VIEW STATE hidden, please advise how to read values from View State through VBA?
I would like to have all the input fields name so that I can push the data through code
Thanks in advance
johny6685
Last Activity: Dec 18 '15, 08:56 AM
Joined: Dec 16 '14
Location:
-
How to read values from View State through Excel VBA?
-
Hi Guys, Please advise Do I need to move this to some other TOPICS to get an answer or I am right TOPICS ? -
How to read the data from a web page during prerendercomplete
I am trying get the input box name and feed some data in a webpage. The website I am trying to work is not showing an details about the elements due to the VIEWSTATE set to hidden. I read some articles that Page.prerenderc omplete will helps to identify the objects before it moves to VIEWSTATE hidden status.
Please advise whether I can get elements and feed data through VBA. -
Dynamic Report with VBA in MS ACCESS
Hi All,
Please advise how to set a dynamic report to be tabular automatically
Also, help me to add groupings to a dynamic report via VBA code.
I Used the below code, but the problem with this code is, it creates report with one line in each page and if I tried to correct the width of the report through VBA I am getting the header for every single line. I am not sure where I am incorrect.
...Code:Function
-
Thank You both. I am going with both of your input i.e. creating a calculation within query and append to the tableLeave a comment:
-
MS ACCESS CREATE TABLE with a calculated field through VBA
Hi
Is there a way to create table with a calculated type column through VBA.
Currently I am using the below code But I am getting, Syntax error in field Expression.
Code:db.Execute "CREATE TABLE tblFields(FieldName TEXT (55), " _ & "FieldValue TEXT (55), STotal NUMBER, Goods NUMBER, Goods% " _ & "CALCULATED ([Goods]/[STotal]) );"
Any Help pl... -
I am sorry about that. May be I might have confused in post 5 but if you see my post 3 i have made a note that this report is coming out from a query based on user selection.
I am going to try your words, let me check and get back if something I get positive. :-)Leave a comment:
-
I am trying to create the report from a query during runtime with VBA code, so I am not sure how best "Group and total" will helps me in that.
Bcoz, my previous idea is to show the data in datasheet view, since the grouping and showing subtotal is not possible in datasheet I thought of using report but reports again it is dynamic as it created based on the user selection. So I am trying to create the report through vba based...Leave a comment:
-
Hi twinnyfo, did you find any examples. I am really stuck into this part. :-(
I tried the Group and Total part but I am not sure whether it helps me for the dynamic report.
Please advise whether it will helps me to create a dynamic report or I have to look for another way.Leave a comment:
-
Hmmm... I am not catching everything...
Do you have any example link or sample file twinnyfo.?Leave a comment:
-
As you stated, user would like to have the subtotal of each parent and child separately due to which I am thinking to get it through datasheet or report.
Like this
Parent Child Child1 Total
----------------------------------------------
ABC-------------------------------------50
-------------CDB------------------------10
---------------------------RST----------5
---------------------------UWV----------3...Leave a comment:
-
Thanks twinnyfo, But I would like to make the pivot table through VBA. I mean a treeview structure datasheet through vba from a dynamic query which changes on user selection from a form.
Please see below site which will help you understand what I am looking for.
http://www.experts-exchange.com/Data..._27964604.html...Leave a comment:
-
MS Access datasheet view like pivot table
Hi Guys,
Is there any possiblity to bring pivot table view in datasheet. where we can group data and see the total on each group seperately ?
http://pbrd.co/182mJDo... -
OMG!!! I am not sure why haven't tried it.
instead of IS NOTHING i placed as = NOTHING which is why i am not able to get what i need.
Code:if tv.selecteditem.parent is nothing then code end if
Leave a comment:
-
MS ACCESS Treeview
How to check whether the selected item in the treeview is parent? -
Thank for the reply Seth. But unfortunately I do not have access to view the video in office, I will try to look at it once I reach home.
In the mean time please could you help me to code the treeview part.
I managed to move the selected data from List view to tree view. I am now stuck in to the Treeview part. How can I load the child nodes for all the field items I populated in the Treeview.
Please could someone...Leave a comment:
-
MS ACCESS Drag and drop LISTVIEW to TREEVIEW help
Hi Team,
I am working on developing a reporting tool, user would like to show all the column headers in one list box and they would like to drag and drop the required fields in a treeview box. From Tree view box they will be filtering further more for the report.
This is similar to PIVOT TABLE functionality we use in excel. list of fieldnames, drag and drop option for ROWS and COLUMNS treeview box. An additional requirement... -
Thank you both, I already tried as Rabbit stated, I opened the sub selection in a new floatting pane which will pop-up on double click but I think Tree view suggestion is what I expected. Let me try and get back if I have some questions. Thanks.Leave a comment:
-
Access List box DblClick should expand the item values
Hi
I have a listbox in my form which will show list of field names in a table. If the user double click on one of the field say for example Location, the list box should reload the data with Location field unique data. such as USA, UK, INDIA, etc...
This is similar to our explorer side bar view which expands the folder on selection.
Please confirm is this possible with MS Access.
Thanks -
Ok... Here I have coded with an additional table created for that.
...Code:Private Sub lstRowDtls_AfterUpdate() Dim varSelected, lstitm As Variant lstColData.Requery If Me.Subform.Visible = True Then Me.Subform.Visible = False End If DoCmd.SetWarnings False DoCmd.RunSQL "DELETE * FROM tbltmpColmlst" DoCmd.SetWarnings TrueLeave a comment:
No activity results to display
Leave a comment: