Search results

Hi all odd question, I need to be able to find a VBA code to change text from a / to - is that possible? for example if you have a REF number of ABC/123/1 TO ABC-123-1 OR A/2 to A-2 The reference numbers can contain any length of letters before or after the / with one or multiple /'s thanks...

Hello I have managed to get the template to open and input the subject automaticallyjust struggling to get the bookmarks to work :( Set myOlApp = CreateObject("Outlook.Application") Set MyItem = myOlApp.CreateItemFromTemplate("C:\statusrep.oft") MyItem.Subject = "Status Report" MyItem.display...

Hi all I have a default Email template, I would like to create something in VBA that loads up the Email template, fills out the subject with data from the access form and also inputs data into a certain bookmark section is this possible?

how very odd Private Sub BtnIEClose_Click() Sub KillProcess(strProcess As String) ' ProcessKillLocal.vbs ' Sample VBScript to kill a program ' Author Guy Thomas http://computerperformance.co.uk/ ' Version 2.7 - December 2010 ' Modified for VBA Paul Steel 02/07/2022 ' ------------------------...

Hi mate I tried popping this into the on click VBA action but shows an error "Complie Error" Expected end sub

Hi all I have a form with fields the user fills out, once this is done they click a button to save and close the form, in the Button I want it to automatically put the fields into the correct Capitalization, how can I do this in the VBA code? Button name: BtnSaveNewUser (OnClick) Field Forname...

Hi Gasman, I did see your code and did have a little play around but I wasn't 100% sure how to integrate that with my original code

Hi all I am so sorry for the late reply, I didn't get any notifications on replies :( Basically I use the below code to fill out a form on IE, the issue I have is if there is already an IE window open is has a bit of a moment and comes up with the debug window, I was hoping for a way to force to...

Hello Gasman Thanks for the below i have an error in red for: objProcess.Terminate() any suggestions?

Hi all I am looking to add different images in a column of my combo Box beside each entry, I have a folder that id like access to go to where all the images are stored, I know how to do it so when a entry is selected it shows in a separate box beside it but ideally be cool if I could get this to...

no idea how to do that :/

Tried so many different ones without any success Dim IE As Object Set IE = New InternetExplorer IE.Visible = True IE.GoHome IE.Quit etc I Managed to get it to open and fill out the form but closing all IE pages seems another beast!

Hi all is it possible to do an IF statement in an control source?

Hi all I have an Access form that when filled in a button is pressed that opens up IE and fills out an online form, unfortunately if another IE page is open it comes back with an error as it cannot find the named fields, what VBA code would I need to close any open IE windows before it opens the...

thank you! just for my knowledge in learning if the ref number had a bracket such as 123/45 but wanted it to be 00123/45 how would this be achived?

hi all I want a button that when clicked if the field is less than 5 digits to automatically put in the leading Zeros how do you do this? ButtonName: BTNClickSearch Field: TxtRefNumber reason for this is if its more that 5 than a different ref number is searched :)

Hi all I have reference numbers such as 12345/89 iI want an if query to say if <7 then put leading zeros etc eg: 123/89 changes to 00123/89 or 23/56 to 00023/56

Hi all, how do I get a query to look for a value in Column 2 of a combo box?

THANK YOU!, just for my knowledge how owuld that be if it was in a sub form? [Forms]![YourmianFormName]![Subformname]![cmbManufacturer];

Hi all I have a form with drop down lists of Makes or vehicles and models, ideally I want to say when the user clicks on the manufacturer it only shows the models from that particular brand how do you do this? Table field names MANUFACTURER MODEL FORM OCOMB BOX NAMES CMBMANUFACTURER CMBMODEL...