Search results for query: *

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

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

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

Got something weird here. I have an INSERT query inside a stored proc, used to copy records to a new record. It's been working previously; yesterday the table layouts were changed to add a single identity column as the primary key to the table, now the INSERT fails. It doesn't give an error...

Hi, The office staff here has a couple of custom templates that they've been using for several years now to generate company letters. The company was bought by another firm, and about two weeks ago this office's network was attached to the new company's domain; login scripts were changed...

Hi, I have an Access 2003 .adp front-end on a SQL Server 2000 back-end. One of the tasks I need to build allows the operator to select a Project Number,Task Number, and Week-Ending Date, and copy the records associated with that criteria to a new Project/Task/Week-Ending Date. I created a...

Hi, I'm working on a main form which will contain five embedded subforms (same form, just using different queries to return different subsets of data.) On these subforms, I need to set the default value (ideally in the OnOpen event of the mainform) to the value contained in a bound text box on...

The company I work for was recently "acquired" by another company, and I've inherited a set of document templates that the office managers want me to edit to replace the old company information with new. They're loaded with custom macros, and whenever I try to get into these macros, I get the...

Got an odd issue going on. I have a form on which I've created a very simple option group with only two options. The option values are 1 and 2, and the option group default value is 1. Problem is, I'm unable to select option two - the label for Option two will show that it's got the focus...

I don't know if this should properly go here or maybe the Windows XP forum, but here goes: I have a small utilities database that I use for reformatting and transferring data. I set up a form with a button. Inside the Click event, I have code to open a folder on the disk, read each file from...

I have an existing stored procedure which runs 4 concatenated SQL SELECT statements, like this: EXEC(@SqlState1 + @SqlState2 + @SqlState3 + @SqlState4) It builds and returns the dataset just fine. But now I have a need to send this dataset to an Excel spreadsheet. I know how to use DTS to...

I'm new to CR, and dealing with an ASP.NET app that is reaching its end-of-life. There are a handful of reports using CR for Visual Studio .NET (VS 2003), and I have been requested to add an additional field from the database to one of those reports. The report uses an XDataSet as its source...