Because of screen real estate limitations, I thought checkboxes with vertical text would be useful and decided to give custom controls an inaugural attempt. Below is a simple control class: unfortunately it renders a proper checkbox graphic, but no visible text. I'd appreciate comments as to...
The type conversion functions (cdbl, cint, etc.) with unknown input have hazards similar to IsNumeric() plus potential overflow problems.
Dim s As String
s = "1239d45"
Dim dbl As Double
dbl = CDbl(s)
MsgBox CStr(dbl)
displays 1.239E+48
"123d945" generates an overflow on casting to double...
I have 2 related tables: tblItem (child) and tblSetItem (master). I am attempting to filter tblSetItem and obtain a related subset from tblItem. Can anyone comment on why an exception is being raised:
"DataMember property 'tblSetItem_tblItem' cannot be found on the DataSource."
I can...
The following vb.net code block serves to retrieve Windows thumbnails. I like some opinions as to whether it will translate to VBA or whether a better route will be to amend to a vb.net class and create a .dll ?
Thanks much.
Public Enum SIIGBF
'SIIGBF_RESIZETOFIT = 0...
Strongm,
Thank you for staying with this thread. You've been very helpful. I did get the clipboard.dll registered. With Windows 7 it meant placing copies of the dll in BOTH SysWow64 and System32 folders and then following the normal admin regsvr32 procedure. Otherwise, plopping the dll just...
The dll isn't the preferred route, but it would have been interesting for a test. Unfortunately it won't register on Win7 32 bit. Binary and/or dependency issues. I pulled up Dependency Walker and it refused to find clipboard.dll in the Open dialog. So a bit of a rabbithole at the moment.
Thank you, strongm, for the WIA heads up. I fondly remember the Kodak control and wasn't familiar with the WIA library. It will be useful. So tif > stdPicture is fine. However, exchanging a couple of pages of code for a mere few lines did seem a wee bit too good. I'm using VBA 7.0 and I...
My apologies to the VB guys on the forum since I am doing this on an Access/VBA platform, but it does seem to be primarily an API issue.
I want to be able to pass an image to the clipboard based on the image file path and do so based on a variety of image types. Converting the image file to...
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.