Search results

  1. S

    Force Printer to show word paper type

    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...
  2. S

    Select next in drop down list

    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...
  3. S

    Force Printer to show word paper type

    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...
  4. S

    Creating a Barcode and copy into Word Document

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

    Creating a Barcode and copy into Word Document

    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
  6. S

    Creating a Barcode and copy into Word Document

    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...
  7. S

    Highlight Text in VBA HTML

    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...
  8. S

    Highlight Text in VBA HTML

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

    Highlight Text in VBA HTML

    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 &...
  10. S

    Query if present on form

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

    Query if present on form

    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
  12. S

    Query if present on 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
  13. S

    Query if present on form

    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]")
  14. S

    Query if present on form

    Example
  15. S

    Query if present on form

    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...
  16. S

    Disable all error messages

    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...
  17. S

    Rich Text into Word document

    anyone able to help further with this?
  18. S

    only show one entry per

    thank you!
  19. S

    only show one entry per

    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...
  20. S

    Dropdown Combo box with Sub Headings

    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)...
Top Bottom