Search results

Thanks Arnel, i'm a bit closer. I've never referenced Excel before and i just cannot seem to get the data "PONumber" into the cell A2 Once i crack this i will then insert other data from the form into other cells along the new row that is created on row 2 every time the code is run. I have...

Hi guys and thank you for trying to help someone as stupid as me..... I now have these various bits of code and nothing is working because i just don't know what i am doing Set oExcel = CreateObject("excel.application") 'Set oBook = oExcel.Workbooks.Open(Environ("userprofile") &...

Thanks Minty, Tried this: Set oBook = GetObject("C:\Users\Sam Summers\Desktop\Tanera Docs\Database Backups\Logistics System\June order form 21.xlsx") Set oSheet = oBook.Sheets(1) 'insert new row oBook.oSheet.oRow(2).Insert xlShiftDown 'set value of a cell oSheet.Cells(1, 1).Formula =...

Hi everyone, This is my second day on this and basically i don't have a clue what i'm doing! I have tried everything i can find an am nearly there. Basically i am trying to insert certain data from a form into an existing Excel spreadsheet - i need to insert this data into the row below the...

Hi Arnel, Don't know why it all failed but i will use your demo and sort it out. Once again thank you and thank everyone for helping me!

I am using this currently which worked perfectly yesterday but after trying some of the other suggestions here it now doesn't work at all? Completely baffled? Private Sub OrderedBy_AfterUpdate() If Me.OrderedBy = "1" Then Me.OrderedByInitial = "AC" ElseIf Me.OrderedBy = "2" Then...

Hi Minty, thank you. I'm having a bad day. I will try but not sure if can do it?

If anyone is out there - after it tried a couple of things yesterday the code i used from Arnel and event i used it in which previously worked, now doesn't ! So nothing is any different (that i can see) but i am back to square one with "PONumber" textbox and table field blank?

Now nothing works - i've messed it all up. Back to the drawing board.

Thank you for your help. Tried that but its beyond my current abilities but i might be able to get it working in the future

Yes there is that possibility so that may be better. Thank you once again! I'm slowly learning.....

Hi Arnel That could work, thank you. What i did was use this code: Private Sub OrderedBy_AfterUpdate() If Me.OrderedBy = "1" Then Me.OrderedByInitial = "AC" ElseIf Me.OrderedBy = "2" Then Me.OrderedByInitial = "M" ElseIf Me.OrderedBy = "3" Then Me.OrderedByInitial = "T" End If With Me...

Thank you guys. I got it working with Arnels code. Very pleased. Thank you

Hi again, I have tried literally hundreds of ways and searched but just cannot get this to work? I have an unbound textbox "PO_Number" with this as its control source =[Prefix] & [OrderedByInitial] & [POYear] & [PO] This is to produce a unique PO Number that looks like this PO-T02110036...

Hi guys, Thank you all for your help. I have cracked it but it works by using a label as i explained previously. But i have now managed to insert the text from my textbox "PO" by using this: ="https://wa.me/447926674707?text=Your%20Order%20PO " & [PO] &...

I have been trying numerous methods but for some reason the way that works best is from a label for some reason rather than a hyperlink field or textbox. To clarify what i am attempting to do is when an order arrives at our port the receiver simply clicks on a checkbox where i have overlaid a...

https://wa.me/XXXXXXXXXXXX?text=Your%20PO436274%20has%20been%20received%20at%20Dornie

Hi Guys and thank you for replying. pbaldy's one didn't work. This works perfectly: https://wa.me/XXXXXXXXXXXX?text=%20has%20been%20received%20at%20Dornie but i need to somehow dynamically enter a number from the textbox "PO"

Hi, What i have below is all working so far apart from getting the text inserted into from the textbox "PO" on my form into the message of the hyperlink but where i have inserted Me.PO it isnt working? https://wa.me/XXXXXXXXXXXX?text=Me.PO%20has%20been%20received%20at%20Dornie Any ideas...

Well i need to send an automatic message when an item is received. So the user simply clicks the checkbox to confirm receipt