Recent content by stu_c

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]")

Example

Hi all. I have two tables TBLOrderDetails TBLShelfnumbers within the TBLOrderDetails I have used the look up wizard to see all the Shelf locations from TBLShelfnumbers I have got the query to search for what ever is on the first entry in the form but wont do all records...

Hi all, In my Access DB, I have a User mode which hides all Nav / Tool bars, disables right click etc I also have a way to enable developer mode which enables all the above (only people with certain access can do this). What I am looking to do is when the user mode is active no error messages...

anyone able to help further with this?

thank you!