Search results for query: *

the problem is that it doesn't follow normalization standards. does anyone have any experience with something like this?

I guarantee you that you don't (at least with access 2000). Try it out on your local machine. Make a database in a full version of access with a simple switchboard to open a table. close it. Install and thenOpen the access runtime. Goto File-->Open and select your mdb. It will work. The...

You can just download the runtime from Microsoft's website. You can just open the mdb with that, but not see any of the 'guts' behind it.

We use the runtime here. You just need to make sure that everything is accessible from the switchboard / startup form b/c the user will have no access to the backend tables/queries/etc... Also, don't deploy it over a slow WAN w/links to a main datasoure. It will run like crap. I learned this...

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

I copied the syntax verbatim from the post that I found it in. I didn't realize that I copied an error as well. The VBA works fine but is slow. Does anyone know how to do this in pure SQL ?

Found this and it works.... Thanks for all the input. I know your code will work ~ because I saw the results ~ even if it was only for a few seconds!!! Could you take one last look at what I pasted into my module? I compacted and repaired the database, but still get the same error message...

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

It doesn't seem to work on a user control. There is the distinct possibility that my code is off. Check it out below, this is called from a main page, the control is called preappdisplay.ascx... Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles...

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

Is there any way to secure the cookies that an asp session creates?

SELECT foo, bar FROM ( SELECT foo, CASE WHEN x THEN y ELSE z END AS bar FROM t ) dt <-- What is this for? WHERE bar = 123

How do you add a 'WHERE' condition on a conditionally created field. Do i have to add the statement again, or can is there a trick to minimize the logic testing....

What about if you need to use 'LIKE'... Can I just drop it in there?

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

What do you mean? I was just pulling the report directly for the url string. Do you have a sample of an asp page that would call a report with parameters? I currently have it pulling data from an Access Query. Do I have to change this over to Crystal SQL? Thanks for your help!! Jesse

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?