Recent content by roccoau

Thanks for the tips

Hi I found below code on another site that does most of what I need it to do except for a few things I would like to add if possible. The code splits all sentence's in column A into maximum character length of 40 whole words in each sentence. Currently the split 40 character chunks are...

Thanks mate works perfect exactly what I wanted it to do

Hi thanks for reply When its "S" I need it to be the next whole number EG Item 1 S 2 S 3 S 3.1 N 4 S 5 S 5.1 N 5.2 N 6 S

Hi I would like to Increment a line item number by 0.1 depending on value in a particular field. The Field in question will have a "S" or an "N" When its an "N" I would like the preceding number to be incremented by 0.1 E.g Item No Code 1 S 2...

OK thanks noted

Hi thanks for reply Yes the program does allow pasting from excel The issue I have is that I can paste from excel to it when all the cell selections are equal Eg A1 to G1 A2 to G2 etc But excel won't let me copy multiple cell selections to copy in same program Eg A1 to G1 C2 to E2 A3 to...

Hi Is there any way of Copying multiple cell selections from Excel to be pasted into another program. (Like an ERP system data entry screen) The cells to be copied may not be equal Eg. A1 to A5 A2 to A13 A2 to A7 etc The data then needs to be pasted in running order with no spaces between the...

Thanks I will give it a go

Found my answer http://www.access-programmers.co.uk/forums/showthread.php?t=85794&highlight=clear+checkbox Should have searched a bit better the first time.

Hi I have a continuous form and one of the feilds is a checkbox. What I would like to do is have a command button which when I click it all the checkbox's which have a check in them to be deleted. Can anyone please help me with how I could do this. Tks Roc

Dreamweaver, thanks that works great, exactly what I wanted it to do. And thanks Ray for your imput as well.

Thanks Ray for help. I had a look at your site but am still having trouble, I don't think I understand how it work full being new to Access. I came up with below code but it does not work. Private Sub expedite_AfterUpdate() Forms Me.frmExpediteS.frmExpediteDetails.Form.PO = Me.PO End Sub...

I have a checkbox on a subform XYZ that when checked i would like the Value in Feild A of this subform to appear in Feild B in a second subform ABC. I think I need an after Update event but not sure of the code to use. Can someone please steer me in the right direction. Tks

Thanks Bob, delete query works great.