Search results

Bit of an update, I think the problem is that the dropdown list columns only allow up to 240 characters even if my table where the data is set to more, is there a way to increase the characters in a drop down column?

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

thank you!

sorry my fault its .docx file

Hi all I am currently using the below code to open a document Set oWd = CreateObject("Word.Application") Set oDoc = oWd.Documents.Add("C:\Users\Databases\HRRecords\Reports\HRReportFile.docx") Is there a way to only get access to search for the document within the main folder path...

Yes, once its filled out the details and clicked B1, I ideally need the window to open a new URL which contains a report so basically need to to insert the URL webpage into the already open window and navigate to it

hi all I have the below code and opens a webpage fills out the information and submits and works great, ideally I want it to open a different page once this is done, how can I get it to input a new website into the address bar and open this? Public Function FUNC_ChangeDetailsl() 'Input data...

Hello, Unfortunately at present we do! :(

unfortunately we do not use bitwarden software, it is only used for the password generator as shown from the link

unfortunately we have to use their website

Hi All I know this is a big ask, and so many have helped me to date, hopefully someone can help. on our database we produce passwords using the website: https://bitwarden.com/password-generator I have a button called BTNPassGenerator, when the user clicks on this ideally the following process...

i want it to work with the rest of the code above if possible? also where do I put the ,getMsgOnLen([field]) in the query?

hello, it is milli seconds, I just need a slight delay from opening to closing it as sometimes it does it far too quick and hasnt got enough time to realise it is open and produces an error that's all

Thank you for the reply, you are basically talking another language to me I genuinely have no idea how to do that, I have only just learnt how to do Functions all I did was select the button, go to properties then on Click

the Private Declare Sub Sleep Lib "kernel32" (ByVal lngMilliSeconds As Long) where do I put this a module / class?

Hello I am using the below code, what SQL code would I need to use to show REFstatus to read "NOT ENOUGH DIGITS" or "TOO MANY DIGITS" along with the below SELECT TBLALLHRDetails.HRRefID, TBLALLHRDetails.IDFKFullStaffDetailsID, TBLALLHRDetails.HRReferenceNumber...

Hi all when a user presses a button it automatically loads up a web page fills it out then closes it down then opens another webpage as a report, I need to be able to put a delay between the page loading then to close, how can I do this? Private Sub BtnUpdateRecords() FUNC_Webpage_OPEN [DELAY...

so the "N/A", Null, the null it here is the actual outcome of what will show?

Thank Arne, I will have to learn SQL by the looks of things :), just for my learning if I wanted to add another statement to this for example if one of the fields has "N/A" then the RefSatus shows blank how would I do this? hopefully then I can learn a little more form this :)