Search results

Yes, but this does not make any difference.

I have 3 tables that i wish to pull information from:- TBLProspects LeadID (Primary Key) CompanyName RenewalDate Status TBLNotes NoteDate Note Who LeadID TBLQuotes QuotePremium Income Reason OnCoverPremium LeadID I have created the query and at the moment, I am getting duplicated rows of...

I have a continuous form with a description field. I have set conditional formatting to turn the background of the description field Red if the Diary field = Date(). This works great. BUT.... Is there a way to then display the highlighted records at the top of the continuous form or to...

When trying to save an excel worksheet on a network share, I get a sharing violation error where i can save the changes into another file or lose the changes. I have permission to write to this file and other users on the network are unaffected. If I log on to another computer, I do not...

I would like a query to return dates based upon the input of just the day and month. At the moment I have a parameter query which asks for 'start date' and 'end date' and this works fine, but I want the query to return all the records for all the years in the database and not just the current...

This worked great - Thanks Scott!

I've made some progress, but... I have changed things a bit. This is the code I currently have. I have RPTGeneralLetter being ran based on a combo box to select the query it uses. I also changed to DoCmd.RunSQL and this works. Private Sub Report_Open(Cancel As Integer) Me.RecordSource =...

I am trying to create a query which shows only the newest note for every prospect. I have the code below, but I get a 'Syntax error in JOIN Operation' when I try to run the query and TBLNotes is highlighted. SELECT TBLProspect.CompanyName,TBLNotes.Note, TBLNotes.NoteDate FROM TBLNotes AS a...

Enter Parameter Value I have made the changes you suggested and I now get prompted for the Parameter value QRYNotes.ProspectID. I want to show the first note for all the records Any ideas?

I have the following two querys which are supposed to return only the latest Note for a Prospect. QRYNotes SELECT TBLNotes.ProspectID AS Expr1, Max(TBLNotes.NoteDate) AS MaxOfNoteDate FROM TBLNotes GROUP BY TBLNotes.ProspectID; QRYNotes2 SELECT DISTINCT TBLProspects.CompanyName...

What about 2 tables? What would the SQL be for 2 tables? I'm selecting CompanyName from TBLProspects and Note and NoteDate from TBLNotes. I want to show only the latest Note for each company.

All looks fine Scott, I did the append query and it looked exactly the same as what you suggested apart from it had QRYLetterByPoscode.LeadID instead of just LeadID. I changed it and it still came up with the 'Too Few Parameters' rubbish. I've attached a copy of my DB. Thanks for having a...

This is exactly what I have... Option Compare Database Private Sub ReportFooter_Print(Cancel As Integer, PrintCount As Integer) strSQL = "INSERT INTO TBLLetterHistory (LeadID, LtrDate, ReportName) " strSQL = strSQL & "SELECT LeadID, Now() AS LtrDate, 'RPTLetterByPostcode' AS ReportName FROM...

Too few parameters I have put the SQL into the Report Footer's On Print. When I run the report and scroll through the letters I get an error that says 'Too Few Parameters. Expected 1.' and the Debug highlights CurrentDb.Execute strSQL. Any ideas?

I have the following code which is supposed to insert a new record into TBLLetterHistory when a report is printed. The report is based on a Query which selects the records based on their postcode. What actually happens is that only the first record in the query is inserted into the History...

All Done! Thanks, i've sorted it.

I am trying to add a record to TBLLetterHistory when RPTGeneralLetter is printed, to record the history of the report. The report is based upon a Query. QRYGeneralLetter is based upon a combo box selection on FRMLetter(CustomerID - select which customer to run the report for). I am able to...

Hello MStef! I want another window to open when the cmdNotes button is clicked rather than the information being displayed on the same form (frmprospects). I did use a wizard to add the command button to the main form, but that didn't work as the FRMNotes, when opened up from the onclick, did...

I have a main form (FRMProspects) with a combo box (ComboCoName) that has a query as it's record source to sort the records displayed in it. It is bound by the CustID (autonumber), but displays the CompanyName. What I want to do is open a sub form FRMNotes, based on the Company name that is...

This worked, I had column 1 bound and it was looking for column 2. Thanks very much for your help.