Search results

Hi namliam.. thanks for your reply been thinking about what I am trying to do...if i know the Pmt Period and the Startdate of the policy, what I ultimately want to achieve is to run a report with date params which will pick up those policies with a pmt due for whatever Pmt period type within...

Hi, looking for advise on which direction to take with this, if possible I have a form with policy start date from which the customer chooses the period to receive payments - Quarterly, Monthly, Half Yearly, Yearly I would like to select the pmt period and and have the date calculation done...

Replace the following cmdBUTTON - Name of the button you click on the form REPORTNAME – Name of the report you are attaching to the email MESSAGETORECIPIENT – whatever you want the message to be it the subject line of the email IDFIELDOFTableMain – The name of the ID field on TableMain...

have just found and used this thread to disable a command button on a form didnt want users authorising a document more than once, Missinglinq's code and Atol's suggestion to set enable to false were a great help to my db and work perfectly ...thanks once again to this forum ...cheers Fi

Hi...you need to use all the code sSubject = "MESSAGE TO RECIPIENT" "Message to Recipient" is the opersonalised message you want to show in the subject line of the email Fi

ghudson....brilliant thanks spent all day looking through threads to suppress error messages, found yours and 2 mins later all done ...big thanks cheers Fi

Hi.. Just used KevinM's solution and it worked a treat...cheers Fi

Hi...apologies cboClient was the name of the field on my form basically I wanted to show a message todays date and the name of the client in the subject line of the email, all you need is sSubject = "YOURMESSAGETORECIPIENT" for this line 'Method or data member not found' basically means the...

Hi ...been working on this myself and through threads on this forum I have this working from a command button on my form...hope it helps..Fi Private Sub cmdBUTTON_Click() Dim sSubject As String Dim stMail As String Dim sDocName As String sDocName = "REPORTNAME" 'message subject sSubject =...

Hi danz013...been tyring to work out how to do this and have got as far as looping thru all the email address producing an seperate email for each client but cannot get my head round how to attach the client report very similar to your thread where you wanted to attach an invoice, I wnat to...

Hi dkinley...your thread worked well for me also and also first shot...I am trying to add as an attachment to the email a report specific to each client, your thread does the looping thru brilliantly you wouldnt have any pointers on how to attach a client specific report to each email as it...

Hi Cyberlynx...I have jsut used this solution and it works brilliantly thanks so much for posting it ...cheers Fi

Hi Jon K....I had posted a similar thread and your solution here as worked a treat many many thanks, I too had sepnt a couple of days trying to get this one sorted :) cheers Fii

Hi MSAccesRookie...I have this now but need to add a field from tblClientCompany which is when the Max stops working ?? any ideas ? thaks again...Fi.. SELECT tblAgedDebtors.Amount, Max(qryMaxFNCDate.FeeNoteFNC) AS MaxOfFeeNoteFNC, Max(qryMaxFNCDate.MaxDate) AS MaxOfMaxDate, tblAgedDebtors.Name...

Hi MSAccessRookie...since my first post I have created a query which seems to be giving me latest entered record, but as soon as add more fields (from tblAgedDebtors) to the query Max stops working and I get all records ?? so I am thinking it is my relationships that arent correct ?? Here is...

Hi MrQ...yes the form and subform are both based on tables and updating cboFeedue creates a new record ??

Hi...cant get my head round this at all :( ...I have a subform where info about the progress of debt collection on a clients fees is recorded. The main form (ClientID, ClientName, ClientCode, Manager) has a subform which shows all current o/s debts for that client (this sf is populated from an...

Hi...SQL view DELETE tblYourTableName.* FROM tblYourTable Name; its a Delete Query which you can do by creating a query in design view, select the table then go to Query type select Delete query, add to the query which data you want to delete or use * to select all hope this helps...cheers Fi

Hi ...I have been looking for a way to automate a data import from an Excel spreadsheet, which is updated daily and needed to be imported to the DB, the previous days data needed to be deleted with the current days data only, being stored in the table, I wanted to do this by clicking on a...

Hi...I have a DB that links to an excel spreadsheet which is updated daily from another system, the link to the Excel sheet is then updated using Linked Table Manager, the DB and the excel workbook are both on the office server with a shortcut to the DB on each users desk. It looks like there is...