Search results

Sure - on the Click event of the label: Private Sub lblTitle_Click() Me.chkCheckBox1.Value = True Me.chkCheckBox2.Value = True Me.chkCheckBox3.Value = True Me.chkCheckBox4.Value = True Me.chkCheckBox5.Value = True End Sub

Hi, Look into APIs for your VOIP software. It'll usually offer a hook or publish an event of some sort that indicates the number calling in. If you're lucky, they'll have an ActiveX component of some sort, but not as likely these days (these days you're more apt to have a .NET or C[++]...

Sure, you can use Datasheet subforms or Continuous Forms (by setting the form style under properties). You can add ComboBox controls for your dropdowns.

A search for "WIA Crop Image" seems promising... for example, post #5 in this thread: http://www.vbforums.com/showthread.php?804921-crop-resize-zoom-and-save-image

That Range reference will give you a collection of objects: cells and rows and columns and such, where each cell might have a particular value. The Value is what you need to be comparing for your date, not the range. It's akin to saying "I have a calendar for the month of May, does it equal...

The logic looks correct... try being more explicit with types (you're leaving a lot up to interpretation by the compile/runtime): Dim myDate As Integer MyDate = Year(Date) If CInt(Me.cboYear.Value) <> MyDate Then ... (if the combo is nullable, wrap that check in NZ() as well)

Good find, WIA is a great library (hadn't thought of it), built-in, no external dependencies, etc. Sounds like the way to go were it me doing this. Cheers,

Looks like GDIPlus does have a rotate/flip method, but whether it's worth it try to and access that via VBA might be a different story: https://msdn.microsoft.com/en-us/library/windows/desktop/ms535401(v=vs.85).aspx (for other reference, you can find some nice GDIPlus API code from here...

For future reference, Base64 is the cheapo-defacto-standard way to move binary data through character-based mediums, so it's likely to be something you'll run into often (Base64 data is usually recognizable as such in that it's not limited to the hex ascii code set, and often ends in = or ==...

You would have to know what kind of format that data is in. I would have first guessed Base64, but it doesn't quite look like it. If it were base64, you would run a procedure to turn the string contents into a bytearray then write the bytes to a file, which essentially converts the text-based...

<pedant> I think technically the Windows API calls would be considered as having less external dependencies than FSO, despite the fact that there's more lines of code to write on our behalf. FSO being an abstraction that calls those same API functions anyway, it would be an extra dependency...

Just to be sure as I saw no specific mention of it, have you tried the DAO.Errors collection? For example, if you catch VBA 3146 (or any of the others), you can look at DAO.Errors(0).Description (or .Number, etc) to get information returned by the server. I've usually found this a pretty easy...

(not to try to derail the thread again, but just for the record: when I said actual musical instruments, that did include ones of the electronic nature - what I meant was those who make music by grabbing digital samples of things actual musicians have played and using those to put together...

I can't imagine it'd be any more problematic than what you already have set up, it's just specifying the correct data type so the driver knows how to map it to the server. Cheers,

As mentioned in your other thread, use need to use the adLongVarBinary instead of adVarBinary for the parameter type of the BLOB content. In this line: .Parameters.Append .CreateParameter("VendorAtt", 204, 1, adoStream.Size, adoStream.Read) Change 204 to 205 Ref...

arnelgp - I don't think relational databases were ever really designed to store binary information, but rather to model much smaller, more structured related data. While each of the major RDBMSs have grow into the ability to store BLOB and other unstructured information, it tends to have the...

As a related side note, I always import into a temp table that's free of any validation rules, foreign keys and usually all text-based (even if they are numbers and dates coming in). This lets me get the data into a table, then clean it up to my heart's desire there. Importing has always been...

Separate your queries: in your main query, don't reach to the image field/table. Only get those when you're ready to show them (use an ID from the main query as a link to get the image needed, but only when needed). You should be able to do this without needing any admin rights on the server...

I'll listen to just about anything that comes from an actual musical instrument (sorry Techno) and isn't written by someone in a suit (sorry most modern chart hits). BBVD: great music, my only critique would be that the singer could sound a tad less white (cool namesake for the band too!). For...

Try opening the db with the shift key held so you can remove the 6.0 reference and replace with 6.1. Sounds like something is using it, but that shouldn't be the case unless you have active code running somewhere. (not sure what breaking changes may have been between the two versions, so be...