Search results

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

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

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

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

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

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

I have a parameter query which is based upon a combo box on a form. When I select something from the combo box the query runs, but I get no records returned. If I run the query without the combo box input (just by typing in the criteria), records are displayed no problem. What am I missing...

I have the following VBScript which finds a record based on text input into a message box. What I would like is a 'Find Next' to search through all the records that meet the criteria. How do I do this? Do I need another command button? <SCRIPT language=vbscript event=onclick for=cmdSearch>...

Is it possible to have a lookup field in a pivot table on a data access page? I currently have a pivot table on my web page that uses fields from a table. Can I have a lookup for one of these fields so the user can just select something from the list instead of free text typing into it?

Please can someone help me with this. I have a Data Access Page that I have added a Command Button to. I want a report to open when this button is clicked on. So i've opened up MS Script Editor and have put the following in the onclick of the button. <SCRIPT language=vbscript event=onclick...