Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. TheInsider

    mysqli fails to prepare statement

    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)!
  2. TheInsider

    mysqli fails to prepare statement

    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.
  3. TheInsider

    mysqli fails to prepare statement

    ...$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...
  4. TheInsider

    WMI: Program Crashes When Setting Enabled Property of Button

    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")...
  5. TheInsider

    WMI: Program Crashes When Setting Enabled Property of Button

    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...
  6. TheInsider

    WMI: Program Crashes When Setting Enabled Property of Button

    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.
  7. TheInsider

    WMI: Program Crashes When Setting Enabled Property of Button

    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...
  8. TheInsider

    Vertically Align an Image in an Anchor Tag

    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...
  9. TheInsider

    Vertically Align an Image in an Anchor Tag

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

    Vertically Align an Image in an Anchor Tag

    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...
  11. TheInsider

    Vertically Align an Image in an Anchor Tag

    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...
  12. TheInsider

    Vertically Align an Image in an Anchor Tag

    ...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...
  13. TheInsider

    Get Data from First Worksheet in XLS File

    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.
  14. TheInsider

    Get Data from First Worksheet in XLS File

    ...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...
  15. TheInsider

    Get Selected Rows from Datasheet Subform

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

    Get Selected Rows from Datasheet Subform

    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...
  17. TheInsider

    Get Selected Rows from Datasheet Subform

    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
  18. TheInsider

    Get Selected Rows from Datasheet Subform

    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...
  19. TheInsider

    Import/Link Images from Excel into Access OLE field

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

    Import/Link Images from Excel into Access OLE field

    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...

Part and Inventory Search

Back
Top