Recent content by stu_c

Hi all I have a Rich Text box I need this part in Bold but the rest in standard, how is the best way to do this? Me.TxtTextSummary = UCase([Forms]![FRM_TBLALL_FullDetails]![SFRM_TBL_StaffDetails].[Form]![LblComplaintRef]

Hi all I am trying to copy text from my text box into a clipboard but seem to be running into an Active X error any suggestions? Me.TxtReportText.SetFocus Dim DataObj As Object Set DataObj = CreateObject("MSForms.DataObject") DataObj.SetText Me.TxtReportText.Value...

Hi all It seems that the error shows on the printer because the printer of this when I click on printer properties within file > Print. the actual page page is set to C5. If I just click print the error shows, but if I click Printer properties > OK then print then its fine. I am guessing I need...

Hi All. I have a drop down list and within it has pre defined text templates that users can select click insert text button and then goes into the main body of a text box. is there a VBA code that will automatically go to the next text selection below automatically within the list so the user...

Hi all I have some VBA code that opens up a word document, copies data from the access form into the word document then automatically prints. the word document is an envelope template. for some reason the printer doesn't automatically recognize the paper type is an envelope, is there a way to...

I was replying to GPGeorge's comment as to why I did not use Rich Text

Hello GPGeorge I had issues importing to word in rich text previously under https://www.access-programmers.co.uk/forums/threads/rich-text-into-word-document.329221/#post-1894872 Unfortunately never found a solution

Hi all I have a word document that is populated by Access forms using the below code, in the Access form we have a REF number that is inputted into a Text box named TXTREFNumber is it possible to create a CODE-128 barcode from this and then displayed within the word document as a barcode on the...

The other option would to for it to open a Email template using Set myOlApp = CreateObject("Outlook.Application") Set MyItem = myOlApp.CreateItemFromTemplate("\\TemplateEmail.oft") MyItem.Subject = "Status Report" MyItem.display and input into certain bookmark points but not entirely sure the...

Hello, That seems to only change the front colour not highlight / background colour

Hi All I have VBA HTML code to work so it transfers everything from a form into an Email have managed to get bold to work but I ideally want some text to be highlighted in either red or yellow, I have tried <mark> and <BGcolor> but haveing some issues sBody = sBody &...

Hello Yes, it is only one shelf per order on this form we need

All I wanted to do was run a query from an already open form but as mentioned its only searching the record that the curser is on rather than the whole form

In the example under TBLOrderDetails_All, the shelf numbers list I only want it to show the ones that haven't been allocated to an order

I have even tried a Dlookup but again only searches for the record the curser is on not all the records DLookUp("[ShelfNumber]","TBLShelfnumbers","[ShelfNumber]=[Forms]![FRM_Orders_OnGoing]![ShelfNo]")