Search results for query: *

Ahhhh yes, that was helpful! This time I got the following output "DELETE command denied to user ..." which is correct. I completely forgot to check if the user account had delete permission (which of course it doesn't)!

Oops when I pasted the code above, I accidentally used VB style comments with ' instead of C-style //. My actual code doesn't have any comments there, so that's not the problem. I just included comments here for clarity.

...$USER_NAME, $PASSWORD, $DATABASE); $sql = 'DELETE FROM featured_special WHERE featured_special_id = ?'; $statement = $mysqli->prepare($sql); '*** error seems to be here $statement->bind_param('i', $featuredSpecialID); '*** crashes here $statement->execute(); $mysqli->close(); } It...

Sorry, you're right I should have posted my edit. I wasn't at my dev computer when I posted the last comment. In any case, my attempt at using delegates wasn't correct. As soon as I plugged in the code you gave me, everything worked perfectly! ... obj = CType(mbo("TargetInstance")...

Update: I put a Try / Catch block around the problem area, and got a more descriptive error message: [System.InvalidOperationException] = {"Cross-thread operation not valid: Control 'Button1' accessed from a thread other than the thread it was created on."} OK, so that verified my original...

Oops, I forgot to mention that the button should be set to disabled initially... or the Button1.Enabled = True / Button1.Enabled = False lines should be reversed.

Hi, I'm new to VB.Net, so I'm probably not understanding a basic concept here. I found some code (below) that will trigger an event whenever someone plugs in a USB drive. I need this check to be running constantly in the background. When a device is plugged in, I want to perform an action like...

Thank you darryncooke and Vragabond for your help. I actually figured out what I was doing wrong. The solution was to set the line-height in the anchor tag to the height of the anchor tag (i.e. [height: 134px] and [line-height: 134px]), and then to place [vertical-align: middle] in the img tag...

Thanks, I'll have a look at that website.

I tried padding with auto, but unfortunately it didn't work. The DIVs will be a fixed size, but the images can vary in size. This is why I'm using max-width and max-height instead of width and height. The actual images may be 50 x 50 or 200 x 200 but I want to use CSS to scale them to fit in a...

Thanks for the reply. I'm only having a problem getting the <img> vertically aligned inside the <a> tag in both Firefox and IE. Right now it only works in Firefox and Safari. But yes, I admit the CSS is sloppy. Though this is just a test page I'm playing with at the moment. I was hoping to...

...none; color: #0066cc; } div#main { width: 700px; } img { border: none; } div.previewPane { display: inline; float: left; /* required for [display: inline] effect to display correctly in Mozilla */ margin: 0 9px 9px 0; width: 169px; height: 200px; overflow: auto; border: 1px...

Thank you bubba100. I actually ended up just using [A1:Z65535] in my SELECT statement, which defaults to the first worksheet and crops the range to the actual data. Since my data won't go beyond column Z, this works quite well.

...I have several xls files with similar data, but each has a different name for the first worksheet. Therefore, the following doesn't work: SELECT * FROM [Sheet1$]; Does anyone know how to get the name of the first worksheet in an xls workbook via ADO or what syntax to use in my SQL...

I found thread702-1276011, which explains why my SelHeight was always returning 0. You're right, Remou. Everything works now. Thank you very much!

I haven't had a chance to run your code yet, but I do have one question: If a person selects upwards (from bottom to top), will the SelHeight property be negative? If not, how will I know which direction to loop? For example, if I start my selection at row 6 and stop at row 2, then SelHeight...

Thank you for your reply. I was trying SetTop and SelHeight, but I couldn't seem to get SelHeight to return anything other than 0. I'll try your code sample tonight, and I'll post my results. Thanks again

Hi, I have a parent form with a subform in datasheet view. I'd like to be able to select multiple rows in the datasheet subform and then change a value on each of those rows. I'm willing to use the continuous forms view instead of datasheet if it makes a difference. Here's an example of what...

Uh, never-mind. It turns out the client doesn't need this feature after-all.

Hi, I have a customer that would like to import or link his Excel spreadsheet data into and Access database. Most of the data in this spreadsheet is text and numbers, but some cells include embedded images. I need to know how to import or link these (I'm not sure which we'll be doing), so we...