Recent content by T8JGT

Hi How can i get a button on a form to select a item on the access toolbar (Compact & Repair Database). Thanks

The reason is it is company policy to send in this format as it is copied into my differend documents.

i have a piece of code which develops an email in outlook, it worls great. BUT i need the attachment to be in the body of the email. Any Suggestions (code below). Private Sub cmdSend_Click() Dim strEmail, HTML As String Dim objOutlook As Object Dim objEmail As Object Set objOutlook =...

Does anyone know how i can make a memo field insert a bullet point after each new line?

Many thanks All working fine.

Hi I am a bit new to all this, so bare with me. I have this piece of VBA which sends and email in HTML format. What i want to is if ITSQFList has text then add the statement "with the following points to note" after ITSQFQualityGate. If it is empty then there is no statement. Any suggestions...

I have a browse button which uses the following code: Private Sub Label44_Click() Dim strFilter As String Dim lngFlags As Long strFilter = ahtAddFilterItem(strFilter, "Word Files (*.doc)", "*.DOC") strFilter = ahtAddFilterItem(strFilter, "Excel Files (*.xls)", "*.XLS")...

I have a browse button which uses the following code: Private Sub Label44_Click() Dim strFilter As String Dim lngFlags As Long strFilter = ahtAddFilterItem(strFilter, "Word Files (*.doc)", "*.DOC") strFilter = ahtAddFilterItem(strFilter, "Excel Files (*.xls)", "*.XLS")...

I have a form automatically send an email (which it does very well), though i always get the Outlook warning message: "A program is automatically trying to send an email on your behalf. Do you want to allow this?" Is there anyway i can bypass it?

Hi I have some VBA which generates an email, i need it to be in a particular fond and certain words made bold. What do i need to do to acheive this (code given below) Private Sub Command18_Click() Dim strEmail, strBody As String Dim objOutlook As Object Dim objEmail As Object Set objOutlook...

Hi I have some code which i am trying to get to work. i is used to transfer data from a query to a word template. Any suggestions (i am not very good at VBA as you can probabily tell by my code): Private Sub cmdPrintReport_Click() Dim appWord As Word.Application Dim doc As Word.Document Dim...

Hi I have a query (qryITSQFSubmission) which contiains inforamtion used to write a weekly meeting agenda. Each record must be individually must submitted by email as the body text and then removed from the query e.g. setting a status field to "submitted". The submission must be in a particular...

Hi How can i send an email that has the information from a particular record in the following format: «ITSQFDocumentName» received from «ProjectServiceDesigner»: ‘«ProjectName»’ - PAR «ProjectPAR» Go Live - «ProjectLiveDate» «ProjectSummary» «ITSQFServRecommendation»«ITSQFQualityGate»...

Thanks

Hi I have a word document which Mail Merges with an Access Database, I am using it for submitting items for a meeting's agenda. Is it possible to clear the document automatically once it has been merged? So that the same item isn't submitted twice. Any Ideas James