Search results

Ive got some code i have been using on a button fine involving scrolling through 1 recorset and created a new recordset using variables froma form and data from the first recordset. It all works fine. My second bit of code does the same, but at the end i then have a transfertext acdelim to...

Hi there I have table1 - rs1 containing records(33,000). I want to loop through each record. Then i have to find the matching record from table2 - rs2 (also about 33,000). So starting at rs1 - position 1 check and see if rs2 - position 1 matches. If it matches then copy a field from rs2 into...

Hiya Is it possible to set the transfer text so it only exports say 10,000 lines in the table to a file and then does the next 10,000 to a diff file. im presuming it will involve looping through a recordset and using a 'temp table' and a integer flag counter. each record read and copied...

Hiya tried seraching but no avail. Im scrolling through a recordset and as its from data imported sometimes i get characters in some of the fields that i dont want. As they are in diff places i need a find and replace type function to remove these characters. ANy help or ideas much...

Hiya HAving trouble getting a report to open filtered on a value from my form In the form is a dropdown combo box that selects the customers name A text box at teh side retrives the value of the customers id number which is the second field in the combo box. Then the report is meant to take...

Hi ive tried the serach and some filter code i found in the forums but they dont do what i requrie so figured id ask for direct help. I have a table full of information and i have it set as a form. Ive popped it as a subform in a mainform. on the mainform is a combobox that i want to use to...

Im running some queries and append and access pops up askign are you sure and i hit yes always Anyway of turing this function off or some parameters i can run Most things are being done in VB throught the 'on clik' of a button The user doesnt want/need to be pressing yes a few times and i...

Hi there Im trying to take the vat percent from my selling price. I need to minus by 17.5% Im trying this method in a query [RetailPrice]-([RetailPrice]*0.175) However my website adds vat to the price rather than multiplies. So for ex if my product is £5 then minus vat its actually 4.1255...

Hi i want to righttrim from a field however each record is going to be of different lengths as its full of text. I know the point i want to start as right at the end of the record is a -- character followed by some text. I wish to trim everything after the -- to the end of the record. I...

Hi there i have a report which is based on a table. In the table several are of type 'memo' When i export to excel it seems to chop down the amount of characters. Anybody know why this happens and a workaround. I tried exporting to text but it doesnt hold the formatting i need. When i export...

Hi there im new , been watching and using for help but i need some specifcs. If anyone can help im greatly appreciated. Problem:// Table is called CDTRACKS Field 1 = UPC (barcode) Field 2 = Position Field 3 = Artist Field 4 = Title Ok. If a cd has 10 tracks then there will be 10 records...