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

    Command buttons stay highlighted even after selecting another control

    Heh. Saved for future use... ;-)
  2. cwadams1955

    Command buttons stay highlighted even after selecting another control

    ...a command button used for a nearly identical task, and that button does not retain the highlighting once the focus moves away from it. Now, there *is* one difference which just occurred to me: the other button displays text, while each of the buttons in question on this new form displays one...
  3. cwadams1955

    Command buttons stay highlighted even after selecting another control

    Nope. Access 2003, and it's in Form View. This is not a really big deal since all the functions are working properly, but my concern is that it might confuse the end users - I can barely get them to understand what buttons are for to start with. :-(
  4. cwadams1955

    Command buttons stay highlighted even after selecting another control

    No, the only form level event is the OnOpen: Private Sub Form_Open(Cancel As Integer) Me.txtCompletedBy.SetFocus End Sub which only makes sure that the cursor moves to the correct field to start. All other events are control-level events, and none do any formatting. Mostly, they...
  5. cwadams1955

    Command buttons stay highlighted even after selecting another control

    ...strMsg = "Must Select Request ID" Err.Raise vbObjectError + 1005, , strMsg End If strSQL = "SELECT * FROM tblLabTestDetail " & _ "WHERE ([ProjectNo] = '" & Me.cboProjectNo.Value & _ "') AND ([RequestType] = '" & Me.cboRequestType & _ "')...
  6. cwadams1955

    Command buttons stay highlighted even after selecting another control

    Hi, I have a continuous form which opens a single table for editing. In the header of the form are two command buttons which filter the records as "uncompleted only" or "all records", based on a single field in the table. The form detail contains a command button to "filter on selection" in a...
  7. cwadams1955

    Late Binding and Excel cell formats

    SkipVought - No, I got that, and that's probably what I'll do, I was just curious about whether the other format would work if I got the syntax right. PHV & RoyVidar - I tend to use the immediate window mostly, too, but I wasn't actually all that familiar with using the object browser to pull...
  8. cwadams1955

    Late Binding and Excel cell formats

    Sorry, that was in response to HarleyQuinn's code snippet. I had used something like that line previously, and the compiler balked.
  9. cwadams1955

    Late Binding and Excel cell formats

    Cool, thanks to both of you, this helps. I did try using "xlDiagonal", but it didn't like that, although it may have been the specific syntax. Since I need to check to see what the style is, I had tried "If .Cells(x, y).Borders(xlDiagonalDown).LineStyle = Solid then..." Probably should have...
  10. cwadams1955

    Late Binding and Excel cell formats

    I have an Access Data Project module that reads an Excel spreadsheet and imports the spreadsheet data into a table. Which column of data is needed is determined by a cell in that column with a diagonal border (representing a slash across the cell), so I need to look at the cell's border...
  11. cwadams1955

    How do I specify an Init module?

    Yep, I used those search options. There are also a couple of user-defined functions in the ModInit module that I thought might be getting called at startup, but I can't find anything doing that, either. They are used in the application, but not until one of the user forms gets posted back. I...
  12. cwadams1955

    How do I specify an Init module?

    That may be, but the ModInit module is running in the original application, which certainly is done in ASP.NET. I see the point of putting the connect string info in the Web.Config file, and I think I'll do that, but I'd still like to figure out why this module runs in one app and not in the...
  13. cwadams1955

    How do I specify an Init module?

    I'm starting my first ASP.NET project, and intended to model parts of it on an existing project. The existing project has a module, "ModInit.vb" which contains database connection information, like this: Module ModInit 'Development Connect Strings Public SQLDBConn1 As String =...
  14. cwadams1955

    Editing a custom toolbar in Word 2003

    ...but I can't find anyplace in any of the macro code that this image (or this button itself, for that matter) is referenced; in fact, I can't find *anything* in the macro code referencing the toolbar except for one block which synchronizes two of the buttons with a list of options (neither of...
  15. cwadams1955

    INSERT fails in stored proc, works in Query Analyzer

    Thanks, I'll keep that in mind. I've been programming for a long time, but SQL Server is relatively new to me.
  16. cwadams1955

    INSERT fails in stored proc, works in Query Analyzer

    No problem. Just as FYI, though, it looked like this: INSERT INTO [dbo].[tblBillRecordHeader] (ProjectNo, TaskNo, WEDate, ServiceArea, Client) VALUES '175508001', '500.100', '2008-08-08 00:00:00.000', 'COE', '63430') I've changed the coding now to use nondynamic SQL...
  17. cwadams1955

    INSERT fails in stored proc, works in Query Analyzer

    Ignore that last question, I just answered it: the SCOPE_IDENTITY *is* putting the value in my work field, it just didn't print it from the SELECT statement until the procedure ended. So as long as I can retrieve that value, looks like I'm good to go. Thanks to all.
  18. cwadams1955

    INSERT fails in stored proc, works in Query Analyzer

    Well, actually, I'm stepping through the stored proc in debug mode - oh, jeeze, let me check something.... ....you guys want to kill me now, or wait 'til later? After doing the code modifications, I forgot to make sure Auto-Rollback (which I'd had turned off before) was still turned off. It...
  19. cwadams1955

    INSERT fails in stored proc, works in Query Analyzer

    ...records in the detail tables.) Right after the Error check, I have a GOTO TRAN_COMPLETE and put the following tag at the bottom: TRAN_COMPLETE: /* ------------------------------------------- End of process. Commit the transaction. ---------------------------------------------- */ COMMIT...
  20. cwadams1955

    INSERT fails in stored proc, works in Query Analyzer

    SQLSister - there are only two records in the table currently, with the identity fields having values 1 & 2. When I was doing the testing with the original structure, I had about ten records in the tables, but those were cleared when the structure was changed and re-testing started. No fields...

Part and Inventory Search

Back
Top