Search results

fixed it myself the output file name was being created using data from the form. changed it to generic name and it worked so question is how can i get the date to be part of the filename but without the // bits i.e just a sixdigit 240809

no, made a query that made a table and then in the code added 2 lines to run the query and then export the outputted table from the query but i still get the readonly - now its on the new named table that the query made ? so again heres my code - i added a close to the recordset in case that...

wierd cos on the same form i do similar options with 3 other tables and they export fine. ill try and havea go with a query

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...

Dim checka As String 'try this method rst2.MoveFirst rst1.MoveFirst Do Until rst1.EOF checka = Left(rst1.Fields(1), 4) & "" & Str(rst1.Fields(4)) rst2.FindFirst (checka) If rst2.NoMatch Then ccost = o Else ccost = rst2.Fields("COST") rst1.Edit rst1.Fields(6) = ccost...

becuase im not that great at coding. :-( didnt realise .findfirst would work. ill have a look at how to use this

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...

works like a dream - you sir are very clever and im very grateful. all i had to do was change teh value from 2 to 1 in the drop last comma box as it chopped the last character off, but now its perfect thanks a lot muchly

regular, nightly based

ok cool, seems as i thought. im just unsure on opening and writing to the text file then closign the text file. i normally just use docmd.transfertext to dump the whole table/query

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...

im presuming soemthing like calculating th length. then reading each letter to see if it is what i want and then if not skipping it, loop, and only copy each letter across i want to the new value.

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...

cant believe it. it works. and before it didnt even give me anything. just blank or all of them? yes ur right it works exactly as expected. im so sorry / embarrased :-(

just some of the data. thanks a lot ashley

yes cs is a combox, its got 2 columns and the bound column is set to 2, the value i want as the first column is the customers name. ill attach. many thanks for looking. its like half 9 at night here - still at work on it :-( guess im not as good at access as i thought. crazy when i can do...

thanks, spelled linkcriteria wrong still doenst do the trick. i get a blank report now, regardless of which number is selected.

linkcriteria = "[CustomerId]= '" & Me![cs] & "'" DoCmd.OpenReport "AllCustomersOrders", acPreview, , lincriteria USed your code - thanks for the correct syntax - i dont get an error - however the filtering doesnt work. I get every record rather than filtered by the Customer Id Any ideas

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...

never mind i forgot to change SELECT orders.* FROM orders WHERE (orders.customer = forms!frm!cbocustomer OR forms!frm!cbocustomer IS NULL) AND (orders.item = forms!frm!cboitem OR forms!frm!cboitem IS NULL) AND (orders.carrier = forms!frm!cbocarrier OR forms!frm!cbocarrier IS NULL); to my...