Search results

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

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

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

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

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

Hi all I have a form with a tabular sub form, I have a button on the main form that the user clicks and when they do I want to automatically create a new record in the subform and to populate certain fields in the sub form how do I do this? Currently running in a module Main Form...

Hi all I have a main form with a sub form on it, is there a way to stop the last field in the main form tabbing into the sub form? in the design > Tab Order it is showing the sub form so is there a way to remove this? currently I have done it a bit of a crude why using a tiny text box it tabs...

Hi All we have a combo box list showing numerous different products, to make it a little easier is there a way to put sub heading (ENGINE & BOSYWORK) within it that cannot be clicked on and maybe even Bold? There isn't enough on the list to warrant a second dropdown list to choose the type but...

Hi all I have the below code that opens up Internet explorer and I want it to search the HTML for a certain word. when I run the code its coming back with an error Run-time error: '-2147023170 (800706be) automation error The remote procedure call failed. then highlights While .Busy Or...

Hi all I use the below code (with a lot more fields) that converts from an access form into a word template using bookmarks. I have decided to use Rich Tech in the text box so we can bold stuff but I am having issues when it converts it now as the shows all the <DIV>, <strong> tags etc how can I...

Hi all I have got some VBA code that opens up outlook, inputs all the subject, To, and body of the email etc I ideally trying to do it so certain text is bold how would I do this? also I want a CLICK HERE link that is a hyper link rather than showing the whole website address any ideas? the...

Hi all I have a form with a button that I want to be able to create a random password with 3 English spelt words, random numbers (1 or 2 long) and capitalization and automatically insert it into a textbox any suggestions on how to do this? do I need to create a table with all words or can it be...

Hi All I have got a Spell check function to check two fields when a button is clicked prior to creating a report, this works perfectly. The issue I have is when it is spell checking a particular box it wont scroll down show the sub form textbox it is checking and just remains at the top of the...

Hello all, I have got some VBA code that automatically opens up the correct intranet webpage via reference numbers in other fields, ideally what I want is when a user clicks out of the field it searches the website for the words "Incorrect Ref", if this happens then to do an If statement to...

Hi all I seem to be getting this issue again, but seems to be very intermittent, sometimes showing other times not which is a bit of a pain, If I copy + paste to make a copy of the database seems to work again for a while then appears again, any suggestions on where to look I have looked in...

Hi all this may not be possible but till give it an ask anyway, I have the below image on a form and I would like users to be able to draw over the top of it with a clear button which would clear everything afterwards. It could the the user clicks on it and opens another program to do the edit...

Hi all I have a form that some of the fields require a lot of data, we are having issues whereby users are in one field for several hours and sometimes if a network connection is lost and they haven't clicked out of the field they lose all the information, if there a bit of code I can use to...

Hi all I have a drop down list of reset wordings that the user can select the presses insert which will then insert that working into a field on a form, all works good but it seems that if the default text goes over 240 characters it wont past it all into the field any suggestions? Public...

Hi All Initially I was looking to open a outlook Pre Filled Email template and input the data form a form but was turning out to be a bit of a nightmare, I then managed to create the below code that opens up a blank email and all the data is entered that way which works fine, I ideally I now...