Recent content by crystalnewbie

I've created a command button on a form that calls a word document to do a mail merge. It runs a query and uses the value of an ID field in the form as the query parameter. When the mail merge runs, the normal parameter window pops up asking for input. How can I prevent this? Why is it not...

Figured it out. Here's the solution for anyone who's interested. 'Code to search items in contacts if it already exists. Set myContact = myContacts.Items.find("[Fullname] = " & Me![Name].Value) If Not TypeName(myContact) = "Nothing" Then MsgBox Me![Name].Value & " is already in your...

Access 2000 / Outlook 2000 I have an Access contact form in which I would like to add a command button that will save the current contact to Microsoft Outlook Contacts or update and existing contact. I've read through the FAQ and posts and got the following code on how to do this. The problem...

Actually, there's really no need for me to open a recordset. Happen to come across an example that did and used it. Just needed to change the assignment to: Set rst = Me.recordset ...and that did the trick. Thanks.

I have a form with an email button that is supposed to open up an Outlook window. It does open the outlook window but it seems to be getting the email information from the first record and not the current record. What am I missing here? Thanks in advance...

I, too, have given up on parameters. Like I said on my previous post, I've been able to get the desired results on Crystal Designer. However when using that crystal query as a data source for a report. I am missing data. I tried doing a "Save Data with Query" on crystal designer and...

I'm using Crystal SQL Designer 8.0. I am able to paste my sql by going to File / New / Enter SQL Statement Directly. I moved the bottom select statement to the top and it is now showing all the data in Crystal Designer which matches the records as if I were to run the query in Query Analyzer...

CR 8.5 / SQL 2K I have a sql statement that works fine on Query Analyzer. The sql is something like (select * from tblA where blah... UNION select * from tblA where blah...). I then paste it and save on Crystal Designer with no apparent problems. I then try to output all the data into a...

Nigel - I added the group by on EmpID and EventDate prior to my post and still getting the same results. 1000---1/1/04---9:00am---12:00pm---NewShift 1000---1/1/04---9:00am---5:30pm---NewShift 1000---1/1/04---12:30pm---12:00pm---MealBreak 1000---1/1/04---12:30pm---5:30pm---MealBreak

Jiqjaq - i'm getting the expected results after i added the join condition. Nigel - you are right, my query would fail if a person has multiple breaks within a shift. I did try your sql though but all i got was duplicated lines for the people with meal breaks. Like this...

I have a table that looks like this: EmpID---EventDate---InpunchDTM---OutpunchDTM---StartReason 1000---1/1/04---9:00am---12:00pm---NewShift 1000---1/1/04---12:30pm---5:30pm---MealBreak 1002---1/1/04---9:00am---12:30pm---NewShift 1002---1/1/04---12:50pm---5:30pm---MealBreak...

Never mind. It was a syntax error. Taking out the '<<' & '>>' in the query did the trick.

CR9 / Oracle8 I'm trying to add the sql below in the CR repository. I need to include a {?StartDate} and {?EndDate} parameter in the sql. I think I got the syntax correct but am getting the following error message: "Failed to open a rowset. ORA-00936: Missing Expression" If i take out the...

I have created commands that were saved in the MS ACCESS db (Repository_en.mdb) that crystal 9 came with. We needed the commands centralized so I created a db in one of our SQK 2K database servers. I imported the Access tables in the repository into the SQL Server 2k db and created a DSN and...

I can't speak for CE10 but on CR9 if you want to modify an existing command in the repository, bring up the Database Expert. Right-click on command on the Selected table area and you need to disconnect from repository first in order to modify. To add a new command in the repository, select the...