Search results

Yes you can. Create a datasource that points to your SQL Database. When opening crystal it should ask you to choose which datasource you want to use, and hey presto. You should see all tables and views. Regards Kempes

Unfortunately it is not free, but has some great features. Here is the website. http://www.christiansteven.com/main.htm They have some great demos on there and it comes in different flavours depending what you need. One of the key features we use is called "event schedule". Based on a new...

Based on your severe constraints, I don't think that's going to be likely. Why not just give them limited access to your database where they can run reports direct from access. Other alternatives would be, Crystal Viewer, which is free but again will not be dynamic. Requires an install on each...

Does anyone know if this is possible? What I want to achieve is this. When you have a group header that is displayed at the bottom of the report, the header shows but the detail is naturally pushed to the next page because there isn't room. Is it possible to tie the header and detail together...

I have a solution but not sure if there is an easier way. Basically, if you add a subreport based on this data, you can choose your last 4 weeks in the selection criteria for this report, which can then be placed in your report header.

Just checked this to prove it works and it does. Good Luck!

You should be able to create a formula field and key the code in manually. Sum(TOtal MBD) + Sum(Total Keyed)

There a two ways of doing this. 1) Edit the current datasource to point to new server. (You will only need to do this once and all reports may need verifying but will be looking in the right place) 2) Create a new datasource, then go to database and set datasource location. Hope this helps...

Go into the event tab and edit the On Click code. when you see the line similar to this.... DoCmd.SendObject acReport, stDocName drop your cursor to the end and add commas , , , , You should see a help box appear with [to],[cc],[bcc],[subject] etc. This is where you will need to specify your...

have you tried Like "exp*" ??

A simple way would be to create 2 querys. Query 1) in design view, from your table bring on your Empname and date. Select Totals, group by empname and choose Max (from the drop down list) for the date. query 2) in design view. Bring on your table and query 1. Link the date from your table to...

If I understand this correctly, a subreport would not be needed. I would recommend you create a new query showing this information (linking the parent to the child), then base the report upon this query. Let me know if you need any more guidance on this. regards Kempes

Assuming the comboboxes are unbound, go into your query the form is based on, In the criteria for each searchable field enter the following . [Forms]![YourFormname]![YourComboBoxName] eg, for faultID, you want the user to choose from Combobox1 on Form name TEST. in the criteria for FaultID...

find record works ok for me. Based on a table containing recordID, and Field1 Record ID Field1 1 A 2 B 3 C 4 D I've just done a basic form with RecordID showing on the form and Field1. By adding a combo box named Test...

Try looking into this. Docmd.FindRecord This works for me.You'll need to point it to the value in your combo box as to what to find. Or Docmd.GotoRecord Regards Kempes

Try this. It now takes into account the Quantity, and the Ticker, and only adds the qty for these rows. SELECT T.Ticker, Count(DCount("Quantity","tblTransactions","Quantity > 0" And "Date <=#20/01/2007#")) AS NumberOfTrades, Sum(T.Quantity) AS SumOfQuantity FROM tblTransactions AS T WHERE...

Not entirely sure I understand, but I assume if you sort by the value, the donor appears more than once????? An easy alternative is the do a new query based on this query, which will allow you to then sort by the sum and not cause problems with the donor field. Hope this helps. Kempes

You might want to try adding a function using the DCount() formula.(As a new field within the query) This allows you to specify what you are looking for, the criteria, and where to find it. Look at the help option within access and it will explain this fully. Hopefully it should sort you out...

The solution is as follows. Go to your table relationships, which should have the two tables in there. Link OEORDH to OEORDHO by the ORDUNIQ (Primary Key) as a one to many relationship. Then, in your report, add the fields required from the OEORDHO. If you want this as a manual selection...

Right click on your section editor and edit. (On the left of the page). Go to the details section and click on the formula button. (No tick required). You will need to change the formula to suit your field but something like this should help. If {yourfieldname} = false then true else false...