Search results for query: *

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

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

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

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

...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 & _ "')...

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

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

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

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

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

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

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

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

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

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

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

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.

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

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

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