Search results for query: *

hello all, I have to create a database that calculates commissions of sales staff. There are 6 different 'structures' that can each have different tiers. For example: I can have 2 loan officers on the same structure, but a parameter of the structure is TierA. TierA can be 100,000 for sales...

Hello, This is difficult for me to wrap my head around and I have been struggling with it for the better part of the day. I have a group by query that is in the following format: CatID | Product | SortCriteria1 | SortCriteria2 | [Needed Field] A 1 A 2 B 3...

Hello, I have several pages that have duplicate functions that look at page level variables (textbox values, etc) and then return values. It is getting burdensome to make sure that all of our changes cascade properly. The logical choice is to incorporate everything into class functions that...

Hello, I have to create an archive of the HTML that a user control displays by storing the static HTML in a SQL database. I do not have a clue how to do this in .Net. I can't seem to see a .Render option for the user control which was logically starting place. If this doesn't seem logical, I...

Hello all... here in my problem. I am moving from Access to SQL server for my ASP pages. I want to migrate the queries from Access to stored procedures. I am haing all sorts of trouble figuring out conditional logic and getting it to display properly. A simple example is... Access SQL...

I haven't been able to figure out how to do this yet... I have a web report where I can sucessfully pass closed.rpt?sf={CLOSING_QUERY.LoanOfficer}+%3d+'AdamDejak' I would like to pass two more critera, basically to mimic a date range. I tried...

Hello, I know this is a super easy question, I just can't figure it out. I am using Crystal 8. I copied a data field and pasted it a bunch of times (it was an odd sized field) and want just change the table field reference. I can't seem to find a 'properties' box for the fields. Help...

Hello, all of my asp.net pages are not being rendered correctly. They are all just showing as text in the browser (IE) window. I tried reinstalling the .Net framework but still with no luck... any clues, tips, fixes?

Hello All, I have written a few relatively simple classic ASP scripts that connect to an access db and return data, etc based on user input query strings. I recently received a copy of VS.Net and have been playing with the ASP.net stuff and can't sort out how to replicate the functionality. I...

Hello All, I have written a few relatively simple classic ASP scripts that connect to an access db and return data, etc based on user input query strings. I recently received a copy of VS.Net and have been playing with the ASP.net stuff and can't sort out how to replicate the functionality. I...

I have the code below which executes perfectly until I added the if... then... end if statement. Am I just missing something, can I not execute an IF in a recordset loop? This is the error I am getting: Microsoft VBScript runtime (0x800A0023) Sub or Function not defined /costcenter_Table1.asp...

Hello, I had the following code working fine until it just decided to stop working. I get a system low on virtual memory message. I increased this and then I get a timed out error message. This was working perfectly before and now works like crap. The only solace that I have is that if I...

Hello, I am new to ASP and can't get this to work. I am sure that it is something simple. Additionally, can some explain what the additional parameters in the rs.open line represent? Thanks, Jesse <%@ Language=VBScript %> <% Dim conn Dim rs Dim strConn Dim strSQL Dim appNumb Dim SQLstr...

I have a workbook that all of a sudden stopped letting me copy sheets. It allows it every once in a while, but then it also completely crashes too. I have no clue how or why this happened. This is the code that started all of the problems... Any ideas or suggestions...

Hi Everyone (again) This time I have to find the absolute location in pixars of cell L2 in a set of sheets The reason why is that I have to paste a form into each sheet and if I don't know its absolute location everything gets messed up. I am not even sure that this can be done so any help is...

Hi, I need to create either a form or an excel worksheet that I can put in cell j2 of every worksheet in a workbook I have. The form has to have 4 options (prefer to be check boxes) of active, 1099, terminated, or inactive. Based on which is checked, i want to have a macro parse through the...

Hi Everyone! I think that my problem is relatively simple, I just can't visualize how to solve it. I need to create and excel function (SumMonth) which I pass 3 variable into. 1)Range of Dates in a column 2)Corresponding Range of $ Values in a column 3)Single Cell Range of Month to Sum for...

I want to code a command button to print only the second to last page of a report that I run every day. btw, the report varies from 5 to 500 pages. Fun stuff.... Any ideas how to? Thanks! Jesse

Anyone know if this can be done? I have a table that has to be recreated each time before a select query can be run for a report. Any ideas?

Hi all, Now have I got a conumdrum for you. Here it goes. I have a crosstab that needs to display a running total for a year broken out by product. ie: dog cat 1-2001 1 0 2-2001 3 1 would be displayed if this was the actual data...