Recent content by paqguy

The database orginated completely in Access. They outgrew Access as the size of the mdb was approaching 2 gig very fast. So they imported all the tables to SQL Server using the DTS Wizard, then linked to the tables in Access. That was pretty much all they did. The access guru then changed...

no unfortunately they don't (locks don't get released when user closes form)... i assume if we were to completely reengineer the front end with unbound forms, and populate with recordsets that might work? just not sure of the best way of setting it up ... haven't had too much experience with...

It's a sql server lock. i haven't tried to modify tables through query analyzer ... good thought. I DO have record level locking enabled in Access. I gave them a vb script to distribute the front end to the users ... this is all being run from a Terminal Server 2003. So I have the script...

I have a client who is using SQL Server as the backend to an Access database ... for some reason everytime a user opens a form to make changes, Access puts a lock on the table and does not release it ... preventing anybody else from making modifications to ANY records. I have yet to find a...

I seem to remember that the drop down list in the select expert only shows the first 500 unique values from the field chosen ... is that correct? paqguy - Shaun Beane Instructor/Developer sbeane@verizon.net

Thanks! paqguy - Shaun Beane Instructor/Developer sbeane@verizon.net

I have already taken and passed 201 and 301 ... but I took them last year before Crystal XI was out. I just noticed (yes I'm a little slow) that you only need 2 exams to get the CRCP now. Does this apply to myself? Or do I need to retake both exams? paqguy - Shaun Beane Instructor/Developer...

i'm trapping for the f12 in Keydown and for the field validation in the form's Before Update event. I'll try the autokeys thing, didn't think of that. Thanks. paqguy - Shaun Beane Instructor/Developer sbeane@verizon.net

I'm trying to do field validation using the form before update event. I cancel the event if the validation fails. I'm trapping for a keydown of F12 so that I can mimic a previous software package used by the data entry people. When the user presses F12, I want to execute the click event of...

awesome!! coool, thanks :) paqguy - Shaun Beane Instructor/Developer sbeane@verizon.net

I remember reading (at least I think I remember ...) about a new feature in Crystal 10 that displays all the conditional formatting from a report in one place ... Anybody know more about this - like where the menu option is? paqguy - Shaun Beane Instructor/Developer sbeane@verizon.net

well, I am currently using version 9 and i haven't had a chance to try out changing the orientation on my report ... I'll let you know how I make out. Thank you for the feedback. paqguy - Shaun Beane Instructor/Developer sbeane@verizon.net

I'd like to print my first page portrait and the second page (or subreport) in landscape. I'm thinking I can just setup the second page so that the text is rotated 90 degrees and make it "look" like landscape. Anybody have experience doing this?? paqguy - Shaun Beane Instructor/Developer...

Does anybody know what Crystal's threshold is for formatting numbers to scientific notation - seems to be somewhere around 17-18 digits to the left of the decimal. Also, can I "force" a number to format with scientific notation? ANY information would be greatly appreciated :) Thanks paqguy -...

Yes, you CAN do this, but I'm not sure how, sorry. I do know that it has something to do with reading the registry to find out where Access is installed on the local machine. You would launch your database using a VB Script instead of just a shortcut. Hope that points you in the right...