Search results

  1. R

    Format Query in Excel

    Hi, I have the following code that takes a query with lots of Brokers and creates an Excel file for each Broker. Private Sub Command0_Click() Dim rs As DAO.Recordset Dim sql As String Dim strPath As String strPath = "C:\Temp\" sql = "SELECT DISTINCT Query.Broker FROM Query;" Set rs =...
  2. R

    Query Switch

    Hi Richard, You certainly seem to have hit the nail on the head with what I am trying to do. Time to set up a Test DB and ensure it works. Thanks for your time, Rob
  3. R

    Query Switch

    Hi I am not rightly sure where to start with the logic with this and not exactly an expert either:confused: The outline is I need to update client information in main table with information provided by my colleagues. This information may either exist already or be an additional client. I...
  4. R

    The Oracle Connection Option Isn't There...

    Hi Do you have a connection option in Crystal ODBC (RDO)? Thats where my Oracle connection is? Does your Oracle DSN appear in the System DSN list. Forgive the terminoligy I am no expert either.... R
  5. R

    Export table to a New File and Drop

    Thanks for the reply. I have 200 + linked tables in one Access file. I would like to import the data from each table into an Access table rather than have it linked. The imported tables will not fit in one Access DB - so I thought the best solution would be to export the newly created...
  6. R

    Export table to a New File and Drop

    Hi I have an Linked ODBC Connection to an Oracle 9 database. I am looking to import every table in the database into a table of similar name. e.g CLIENT_LIVE (Oracle Name) into CLIENT_STATIC (Access2007). I can easily do a make table query to import the table. However the problem I have is...
  7. R

    Newbie needs help with CR8.5

    You need to use a Left Outer Join for your second join this will select all records from your primary table and any records from your secondary table that match.
  8. R

    Sorting records for a specific date/time period

    You could try the inverse and filter out everything between 7:00AM and 5:00PM
  9. R

    IF statement in Crystal reports ver 10

    To nest an IF statement you must follow it with an else if if today is "Monday" then 1 else if today is "Tuesday" then 2 else if ...... else if today is "Sunday" then 7 else 0
  10. R

    Multiple Filters

    Hi I have a Global variable strVndCode which filters my summary report. What I would like to be able to do is on the line "strVndCode = "DUB TEAM 1"" expand this to include other Departments. I tried strVndCode = "DUB TEAM 1" OR strVndCode = "DUB TEAM 2" which did not work. My summary report...
  11. R

    parameters in SPs

    Here is Something I use The user has to key in date ranges but it would be very easy to adopt to make it formula based. Local DateVar StartDateCurrYear; Local DateVar EndDateCurrYear; Local DateVar StartDatePriorYear; Local DateVar EndDatePriorYear; StartDateCurrYear:= {?Start Date Curr...
  12. R

    Report Keeps Forgetting Printer Settings

    Hi I have tried 3 times to get the chumps in MS to reply to the request for the hotfix. Is there anywhere else I can obtain this....
  13. R

    Too Many Pages

    Sorted !!!! Have to some playing around I got it working. Pure fluke I think but both controls had to be in the same section.... I am using 2007. Thanks for all your help.
  14. R

    Too Many Pages

    Hi Mailman Thanks for the help so far ! Nearly there I think. My table is PagesPrinted my colums in that table are CLI_CLIENTNUMBER Text Pages Number I placed the code in the Report Property "On Page" and also tried it "On Close" Private Sub Report_Page() If...
  15. R

    Too Many Pages

    Hi Mailman, Thanks for the above, just done a search for me.pages to see if it would give me a little guidance. While I see where you are going with your answer I 'll be quite honest don't really have much clue as to what to do with it. I don't want a message box (if I can avoid it) as I...
  16. R

    Too Many Pages

    Hi Apologies for the subject difficult to condense..... The report I have is ran by looping through each client number and outputting a new report for each client. One Query One report multiple client numbers. The report 95% of the time fits on either on 1 Page or 2 Pages and if it is on 2...
  17. R

    Sum Problem (Footer)

    Hi I Have a debtors listing that has multiple currencies and is grouped by the Account Manager. In thr Group Footer (or somewhere) I would like to put the total, the problem is that I need a total for each currency. I have attached a sample which shows the data and the problem report. I am...
  18. R

    Conditional Sub-Report

    About 30 mins ago, I got it working maybe not the best way but its working. Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer) Me!SubInsurer.Visible = Me!SubInsurer.Report.HasData Me.RCP_NARRATIVE.Visible = (Me!SubInsurer.Report.HasData + 1) End Sub This is in the OnFormat...
  19. R

    Conditional Sub-Report

    You can possibly see from the number of posts that I am no expert.... meet me half way and a little bit of a pointer as to what else would be useful, maybe I might get it right next time. The subreport is on the detail line of the main report. If the subreport has some data then show the...
  20. R

    Conditional Sub-Report

    Hi I have a sub-report display on the report correctly ..... to a point. If there is no data in the sub-report then I would like it to display a field from the Master field list. If Data Present use sub-report else use RCP_NARRATIVE. The database produces receipts and if we allocate funds...
Back
Top Bottom