Search results for query: *

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

No, they're just plain control buttons - I went back and double-checked. Just out of curiosity, I also checked a different form which has 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...

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

Code for the "show uncompleted only" filter button: Private Sub btnGetRecords_Click() On Error GoTo Err_btnGetRecords_Click Dim strSQL As String, strMsg As String If Nz(Me.txtCompletedBy, "") = "" Then Me.txtCompletedBy.SetFocus strMsg = "Must Enter Completed-By"...

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

The company I work for has a custom toolbar in Word 2003 that was created a few years back by someone no longer with the company. There's a button on the toolbar called "Report AutoText", which has as one of its options, a command called "Insert Framed Figure", when this button is clicked it...

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

bborissov, The commit isn't in the section of code I pasted - there's some other work going on that I'm actually skipping right now for testing purposes (copying records in the detail tables.) Right after the Error check, I have a GOTO TRAN_COMPLETE and put the following tag at the bottom...

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