I have a form with 3 datagridView's ie DataGridView1 DataGridView2 etc
With DataGridView1
.GridColor = Color.Red
.CellBorderStyle = DataGridViewCellBorderStyle.None
.BackgroundColor = Color.LightGray
'.DefaultCellStyle.SelectionBackColor =...
softhemc
Really appreciate the help it worked fine on a normal page
But i now find the the page i am trying to process is a TABPAGE
???How do i get the routine to work on a tabpage ?????
Appreciate some help if you have time
Regards Kennedymr2
I have a form with 6 datagridview controls ie datagridview1 datagridview2 etc
I need to loop through the 6 controls to set columnscount etc
rather than doing 6 seperate loops , is there a way eg
for ll= 1 to 6
With datagridview & str(ll)
???.columnscount=12
end with
next ll
Really...
strongm (MIS)...
Thanks once again for the help, much appreciated...i did not think of subnode...
Thanks also for the help you have offered me over the years with various other questions ...
Regards Kennedymr2
This is the abreviated xml
'*************************
<Pool Type="XX" Available="Y">
<Dividend Id="629" Amount="12.8000">
<DivResult No="1" RNo="2"/>
</Dividend>
<Dividend Id="6291" Amount="13.8000">
<DivResult No="1" RNo="4"/>
</Dividend>
</Pool>
VB6 Code.... working ok
Set oxmlNodeList =...
This is the abreviated xml
'*************************
<Pool Type="XX" Available="Y">
<Dividend Id="629" Amount="12.8000">
<DivResult No="1" RNo="2"/>
</Dividend>
<Dividend Id="6291" Amount="13.8000">
<DivResult No="1" RNo="4"/>
</Dividend>
</Pool>
VB6 Code.... working ok
Set...
strongm ,
I originally thought i had worked out the solution, but i found i walked into some problems., i can see what you are getting at.
I will have a good look at SendMessage(hwnd, WM_SETREDRAW, FALSE, 0)
All that i am trying to achieve is run firefox or ie using shell in order to get ssl...
JustinEzequiel...
Thanks a lot , this has pointed me in the right direction.
I need to position eg notepad ...in an exact position on the form..
The example just places the notepad over the top of the main form.
I was thinking i could create say a picturebox on say the bottom of the form ...
I have a program running and would like to open say Firefox in a position on the existing form.
I am trying to avoid using webbrowser....,
ie.
Shell ("C:\Program Files\Mozilla Firefox\firefox.exe c:\submit.html")
Can i put say a ???picturebox on my form... and place the above shell exactly...
I am developing an vb6 program on a windows 7 computer which has office 2010 on it.
To create an excel spreadsheet i need to reference excel 14 in windows 7
BUT
If i send the program to say an old xp computer (with say office 2003 on it) the excel 14 referenced does not exist (it seems to...
Finally solved it !!!!!
There is no docmd. for this in Access 2010
Solved...
Public Function ExportPT()
Dim BPT As Office.CommandBarPopup
Dim BEPT As Office.CommandBarButton
Set BPT = Application.CommandBars("Menu Bar").Controls("PivotTable")
Set BEPT = BPT.Controls("Export to Excel")...
PVH
Appreciate your giving time to my post...
Not real sure about export a crosstab query....i am trying to export a pivot table...
The acexport only seems to be able to export a table
Regards Kennedymr2
When the pivot Table is loaded and visual...
There is a button at the top export to excel
When this is pressed it creates a spreadsheet..
I also then need to save it auto as well
Regards Kennedymr2
I am using Access 2010
Trying to write a function to include in a macro
to export a pivot table to excel.
something like !!!!!
DoCmd.TransferSpreadsheet acCmdPivotTableExportToExcel, acSpreadsheetTypeExcel7, "datatabpivot", strFullPath & "Daily.xls", False
I realize that...
Mazeworx..
Thanks for your comments.
A bit hard to do seperate query's in this instance.
Looking for while ??????? report is open
do events
wend
regards Kennedymr2
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.