Search results

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.

Yes Bob your right it does not matter waht number the PK is. I am just having trouble with the delete macro as it deletes the whole table first. So I need to look at a delete query, I will try it out. Thanks for the help. Rgds

Thanks Bob, Yes that does it but the import just adds to the data already in the table. I wanted to start with fresh data everytime I import the new spreadsheet.(Pk to start at 1 each time) My macro starts with a deleteObject before it imports the new spreadsheet so I start with fresh data, but...

Hi, I have a TransferSpreadsheet Macro where I import a spreadsheet on click of a command botton. The settings are Transfer Type: Import Spreadsheet Type: MS Excel 5-7 Table Name: XYZ File Name: C\Documents and Settings\Home\MyDocuments\XYZ.xls Has Feild Names: Yes Range: (nothing) Is there...

Hi, I have a continuous form as a subform on a main form with one of the feilds being a checkbox. Once this checbox is ticked I would like todays date to populate a new line in the subform. Can anyone please help Tks

thanks macca