Search results

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!

Hi all I want to run a query that when runs only shows words from a specific column but does not show duplicates of words is that possible? for example if the list was: BODYWORK BODYWORK ENGINE ENGINE ENGINE WINDSCREEN TYRES I would like the query to run but only show BODYWORK ENGINE WINDSCREEN...

Hello, I am a little confused as I currently have these in a table already called TBLDefaultText with the following field names IDFKAutonumber Category (will be Level 1) Default TextTitle (shows on the Level 2 list) DefaultTextBody (Once the user has selected this data is pasted into the TxtBox)...

For anyone that needs it, here is what worked for me :) Public Function FUNC_AutoPopulate() With Forms!FRMOrderDetails!SFRMCustomerDetails.Recordset .AddNew [Forms]![FRMOrderDetails]![SFRMCustomerDetails].[Form]![TxtOrderingDate]= NOW() 'ADD OTHER FIELD ENTRIES HERE End With End Function

Hello, I have updated my post a little with the details :)

Hi all I have records in a sub Form that have tick boxes and Text Boxes, is there a way to possibly have a button on the main form that you can click that pulls this data from the previous record sub form and copies it into the new one? 1 Record per form page The form details are Main form...