Search results

ok i put in design view and named the subform container as mysub. The button works (i.ie i dont get a debug error) however it doesnt filter or requery the records in teh subform The cancel button on mine works, it clears the combos makes them invisible etc but even when seletcing a new...

the only bit which WONT work on my bit is me.mysub.requery Whats mysub ? Is it the subform name ? Thanks alot

this just may do the trick. will report back. thanks very much :)

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

thanks very much the docmd option is perfect

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

Add tax to a products price function zen_add_tax($price, $tax) { global $currencies; if (DISPLAY_PRICE_WITH_TAX_ADMIN == 'true') { return zen_round($price, $currencies->currencies[DEFAULT_CURRENCY]['decimal_places']) + zen_calculate_tax($price, $tax); } else { return...

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

Thanks a lot ill give it a go. Yeh crazy cds with like tiny tracks or interludes. Mostly folk or hiphop. :-) I figured id have to split the queries, will give it a try and let you know. Thanks so much for your help Ashley

Ok here goes. Thanks again Ashley Its fine as is, qryCrossIt is set to 60 but qryEndResult is set to 50. Set it any higher and you get an error result. As soem cds have 54 tracks etc i need it to do 60

Still for some reason cannot get the queries to work in my db. I exported all the 3 queries and your table25 adn then they work in my db so it has to be somethign to do with the design of my table etc. Ill go through and debug and comapre Ashley edit: debugged and it was my table field...

its fine i found that exporting the table using a macro running transferspreadsheet set to excel 8-10 doesnt truncate the memo fields. however if you set it to c:\documents and settings\User1\desktop\file1.xls you get an error set it to c:\file1.xls it works fine and exports without...

Really wierd. It works. Just if you view the table in datasheet view it chops it down to 255 chars However make a quaick tabular form using the wizard to display it and hey presto, theres the complete full memo with everything after the -- chopped off. Very very strange Now i have to export...

Wow thanks for teh code, i converted it to a 2003 db and tried it and saw that its fine. Differences in code were in the first query where it just added brackets around the UPC and Position in the select statement. SELECT [UPC],[Position], [Position] & " " & [Artist] & " " & [Title]] AS Expr1...

tried this qryStart runs fine qryCrossIt gives me an error thats got an unknown message 1038 qryEndResult gives the same error - probably becuase qrycrossit gives me an error in the first place. heres a copy of my EXACT code in the 3 seperate queries . i am also trying the db record set code...

copied this in and ammended the bold items for my actual table name and field names however i get an error i get the rs sub or function not defined do i need to add into the above code set rs=db.OpenRecordset(CDTRACKGROUP)

No problem, thats cool. Its sorted now - it does what you guys have helped me do Just the memo/text thing issue. Is it a case of swapping the code so it thinks its a memo field?

AHA bingo it works great, thansk so much Ken for the code and for Bob for pointing out the Nz bit 21995 records proccessed Heres where you guys shoot me. Its now chopping it to 255 characters. I forgot *dont hit me* that its a memo field not a text field. Wheres the embarassed smiley

I didnt change the code as yet, i left as is, i had a space in the bit where "DVDIMPORTFROM " was Im really sorry for being so dumb as to miss a space. So actually its referencing the file ok now its just the null command - ill try that what you suggested bob

It works past the line now but get an error on the following line ( maybe becuase i forgot to say that there are sometimes empty in the plot field) strImportText = .Fields("Plot") 'Read the imported text value Error was invalid use of null