Search results

missinglinq, you beat me to it

why on open out of interest?

I think the issue may lie with your formula field in your main report. a subreport is probably your only option. I found this on the crystal help facility which better explains what I was trying to suggest. Linking to/from a formula field. There are situations in which you may need to link to...

Another way, and maybe a more simple option, would be to make the change within your database query to strip the number out as a new field. Then, update/verify the database in crystal so it shows up, and link this new field to your dealer table in database table linking. This way, subreports...

You could achieve this using a subreport. go to insert then subquery. Follow the wizard and bring on the relevant data. Then, make sure you choose the links tab, and link your formula field to your dealernumber. This should work.

Try this. if isdate({?TradeDate})=true then datevalue({FundTransactionLines.TradeDate}) >= DateValue({?TradeDate}) and not ({FundTransactionLines.FundTransactionSource} in [10,1,2,8]) and {FundTransactionTypes.TransactionTypeName} in ["Dealer Redemption", "Dealer purchase", "Purchase"...

sorry, I have been really busy recently. I've had a quick look and created a copy of your form (attached, called kempes1). Does this do what you want it to do? I'm not entirely sure that your database structure is sound, but hopefully this should get you started with what you want to do...

This is because you must have selected id rather than value to show within the detail of your report. To correct this, open field explorer (view\field explorer). expand database fields. expand your table drag value into the detail section. The value field should now show.

What data type is the field? String, Date...etc

Hi Gaz, Could you post an acc 97 version please? Thanks

Just add 2 text boxes in your report header. set the control source to be min([datefield]) and the other max([datefield]) That should sort it

Can I just ask, are the records actually showing for the last month? Is this what you want it to do? Datadate will show a date when the data was retrieved for the report. If you want the actual data to show for the last month, you will need to open the select expert (which is basically your...

Hi, what I would advise is, do not use FN and LN, as the combination of them are not unique. You do have a unique field within this table which is clientID. You will need to use this to determine which investor will be displayed. Looks like your query is already set up, so it should be fairly...

The answer is , yes, all records will show in the list until you submit your criteria. Like "*" basically means show everything. If you enter nothing in text0, the query will know to show all records. if you then add something in text0, the criteria then says show every record that has your...

firstly, how are your tables linked? secondly, how are you getting around clients with the same first and last name? (it may not have happened yet, but could happen)

OK, Create a new query containing the names of the customers or use the current query, (not the table). Save it. Open your form, change the list box so it feeds from this new query. (let say your list box is called list0 on the form) Add a command button to your form and add the following code...

If you just want a combo box to check if a location exists in your table before actually creating a new record for it, you can simply do this. Insert a new combo box into the form header. Don't go through the wizard. (Make sure it in unbound. ie, there is no control source for this particular...

My guess is that the combo box is bound, so when you are selecting your location, what you are effectively doing is creating a new record in the table. I imagine that your table is set up to not allow nulls in this field. As a quick workaround, you could add a new unbound combo that will not...

Acrobat Reader 7.0 onwards does let you copy text to clipboard. Not sure about previous versions. Tools/Basic/Select will give you a cursor on the page. This may be a workaround.

I can't understand why Word would be doing this, but can't you just export as a PDF?