Search results for query: *

I have a report where the shading is working like it should. This report only has one grouping level which is "FileName". Now I have to have a secondary grouping level called "PersonName". When I add this grouping level the shading goes sideways. I am trying to shade in every other...

Is there a way to get all open workbook names using VBA. Currently I have an Excel Workbook that is distributed to users that updates a workbook kept on the user's workstation. My problem is some users workbook's are not the required workbook name and the users never keep the workbook in the...

I am trying to load workbooks into a database that contain 5 required worksheets with distinct names contract contractorinfo contractdetails contractstatus validuntil These workbooks are supplied from outside sources. The problem is: not all the workbooks contain all 5 worksheets. The load...

I have a package that I designed through DTS designer and I saved a visual basic file, made the changes I needed. My question is: Is it possile to import the file back into SQL Server 2000 as a package without retooling it through DTS designer. Thanks in advance

I have populated a list box that has two columns. I want to display both columns in a message box but all that comes up is the first column Here is my load code Dim intrCount As Long Dim i As Long Dim arFill() Sheets("CaseSetup").Select Range("A2").Activate Set...

I have a user form in excel that has a list box. I am populating it with an array that has two columns. There are currently 12 records but this will increase over time. If I use the following code there is no error Dim intrCount As Long Dim i As Long Dim arFill(1 To 1000, 1 To...

I have a blank user form which a user uses for data entry. I would like a combo box to load the values from a different worksheet in the same workbook. The worksheet is called called "BackorderName". I also need to have the list load alphabetically as the "BackorderName" worksheet is...

I am hoping to get somwe help on this one. I am trying to populate a combo Box with two field values. MinistryID MinistryName Ministry name is showing but the ministry ID is passed on as a parameter to a stored procedure in a SQL server 2000 database The problem I have come across is that...

I there a way to pass a variable to limit the criteria and select all records when the user doesn't pick any criteria. I have a variable called @strFiscal and I would like it to provide a limited criteria based on the parameter being passed to the variable or have all records selected if the...

I have tried this in other forums but have got no response. This stored procedure is activated from a Microsoft ACcess ADP form. I am trying to have a progress or status bar show when a store procdure gets executed through a click event. This stored procedure runs for about two minutes. It...

I am trying to have a progress or status bar show when a store procdure gets executed through a click event. This stored procedure runs for about two minutes. It would be nice if the user could see some sign of life. Any ideas would be greatly appreciated Thanks in advance Micheal

I am trying to have a progress or status bar show when a store procdure gets executed through a click event. This stored procedure runs for about two minutes. It would be nice if the user could see some sign of life. Any ideas would be greatly appreciated Thanks in advance Micheal

I Am trying to take a company_name field in one table that has associated company names in a relational table. tblCompany MinFileID MinName 1234 Whole Parts 4567 Ret Parts tblAsscCompany ClientID ClientName 7891...

My problem is I can pass the first ORDER BY SORT but I cannot get the ASC or DESC to work SET QUOTED_IDENTIFIER ON GO SET ANSI_NULLS ON GO ALTER PROC UDF_##CurLitFiles_Move ( @SortField char(20), @Order tinyint ) AS IF EXISTS (SELECT name FROM...

I am try to create that returs sum for the week of the month I am reporting in. Is there any way to create a running total to picK up the totals of students and researchers time by week For example: The month is february and I would like the format to look like this: Week 1...

I have a report that has running totals that runs Totals by Client on expense types Travel $500.00 Experts $0.00 Expenses $10.00 Office $0.00 Automotive $125.00 As there is 16 types I would like suppress that equal zero. When I try to supress the zero records I get this: Travel $500.00...

In my project I have a form that loads when a command button is clicked on another form. As the form is loading it executes an INSERT INTO stored procdure. My problem is that every time the stored procedure finishes executing the I get a message box with a title of Microsoft Access stating...

I am attempting to pass a date parameter to a stored procedure through a form in an Access project. My problem is when I execute the procedure it brings up the parameter value box and tells me to enter a value. I would like it to pick up the form value from the text boxs. The stored procedure...

Could someone please help. I am looking for a connection string and execution code for executing a stored procedure on SQL Server from Microsoft Access linked database. Thanks in advance Micheal

My report header seems to want to print as a page with no records on it. The page header is only 4 lines and the rest of the page is blank. One record has a memo field spanning over two pages. If I take 'Can Grow' off of this field, the report looks the way it should with the Report Header and...