hi thanks for the help :)
i still have a problem though once i run this code and the pic is in the clipboard, how can i get it out of there again?
like opening it so the user can make changes to it then put it back to the clipboard?
do you know if i can have more then one pic stored there? so...
Hi all, does somebody know how i can create a screenshot via vba code?
by clicking a button a screenshot shall be made and then this picture (bmp) shall be automatically stored in a ole object field of the access database
does anybody know how to do that?
thanks so much
hi all
im working with a ms access 2003 database and vba
what i need to do is to save pictures / screenshots (bitmaps and jpegs) in the database
first i would need to save these to a array though (because application specific) and then save them into a database
does somebody know how i can...
in this case it is needed to save the pictures
if the database gets to big the user has the possibility to create an archive from this database and start with a fresh one
hi all
i have a question,
im working with a ms access 2003 database and vba
what i need to do is to save pictures / screenshots (bitmaps and jpegs) in the database
first i would need to save these to a array though (because application specific) and then save them into a database
does somebody...
Hi i changed the cursertype to adUseClient but i still get the same errormessage :(
i didnt understand what you mean with
"You will also need to check out supported cursor/locktype availability with your specific database driver"
how do i do that?
Thanks a lot :)
Hi everybody i have a problem
I have a programme that got its data from a access database
i used to do that with a recordset which i get with this function
'setting the recordset
Set GetData1 = New adodb.Recordset
'execute the SQL-Query
GetData1.Open strSQL, conDB...
hi everybody i have a problem
i have a programme that gets data from a oracle database and also should write data into the database
now i get the datas with a recordset like that
GetData SQLUserData, adOpenForwardOnly, recData
function GetData()
'setting the recordset
Set GetData1 = New...
that is all that i need for the connection?
oConn.Open "Provider=OraOLEDB.Oracle;" & _
"Data Source=MyOracleDB;" & _
"User Id=myUsername;" & _
"Password=myPassword"
thanks alot :)
Hi everybody i have a question
i have a database in Access which i get data from
in order to do so i open the database with the code
Set dbDBSAccessConn = New adodb.Connection
dbDBSAccessConn.Provider = "Microsoft.Jet.OLEDB.4.0"
dbDBSAccessConn.Open (strDatabasePath))...
if the user chooses a item in the combobox then i say
Set nodeX = frmMain.treeview.Nodes.Add(, , "Key Root1", "Root1")
nodeX.Tag = "R1"
nodeX.Sorted = True
and then i use a nother function to create the childs to the rootnode
thats the problem they dont want it that way you said
I had it that way first but then different filters were added to the different roots which made the users get mixed up if all three roots stayed displayed in the treeview
so we came up with the combobox but that makes it very slow unless we...
Hi everybody i have a problem
I have a treeview and a combobox
the combobox contains 3 items, say Root1, Root2, Root3 niow if the user chooses Root2 then the nodes to the Root2 are build up in the treebview.
Now, the problem is to build up all the nodes takes really long and therefore if the...
Hello, i have a question
have a form from which the user can open up a new from on this second form he shall be able to check or uncheck a checkBox, then he closes the second form again. (the second form is closed by cmdok_click() with Me.unload at the end of the code)
Now i would need to know...
thank you for your suggestion :)
i tried it by crating a extra child to those nodes i need the special info and then wanted to put those childs on invisible so my code in the loop to get all the data of the recordset into the node looks like this:
Set nodeX = tvwToFill.Nodes.Add(strRootKey...
Hi all i have another problem
i have a treeview, the nodes in it already got a tag added to it
now i need to put additional information to each node
since the information in the tag is beein used very often in the programme i would rather not change the tag as it would be difficult to make the...
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.