Search results

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 =...

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

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...

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

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...

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...

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.

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

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

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...

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...

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....

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.

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...

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...

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...

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...

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...

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...

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...