Search results

I have a report in 2000 based on a query that picks up a BMP image from an OLE link in a table. Works fine shows the image no problem. Tried to recreate it in 2010 and it just displays a box with the file name in followed by (Command Line). I have tried a couple of activex controls as...

This keeps coming back to haunt me so any help would be appreciated. I have one table, Dbo_tblParts_Other, the fields i want are Partcode, Alt_Partcode, and Supplier. The data is stored thus: Partcode Alt_Partcode Supplier AM9026 81459634 Volvo AM9026...

I wish i could re design the table but it's part of our corporate system and has been developed over the years as a plaster for every sore. It has 5 million records and hundreds of columns so is too tightly interwoven with everything else for that option. Regards

Thanks this table is a mess, it's possible to have 20 suppliers for some items though some will only have 1. They are stored in no particular order and are not ranked in any way. So i thought a pivot table, once i've established the maximum number of suppliers for a part and so the maximum...

Hi, I have one table called MVPR and want to extract from it the part number and suppliers for that part. I want the layout to be : Part No Supplier1 Supplier2 Supplier3 a1234 41758 41963 42531 However the data is in this form: Part No Supplier a1234 41758 a1234 41963...

I have a table that shows warehouse locations thus: Part No Location A1234 A1 A1234 A2 A1234 A3 A1234 A4 There may be only the one location, or, as above four, I need to display the first three locations for each part side by side:- Part No Location1 Location2 Location3...

E-mail from reports Thanks for your help, i will give it a go i can get most things done but am afraid code is my undoing. I suffer from dyslexia which makes things difficult enough at times but i have learned to get by. Learning code puts me off completely, i am getting too old! Although i...

E-mailing reports All the data, including the e-mail address is in the various tables on our system. I can query out the required data and have got the report as i need it. As the data is dynamic I want to run the report/query and e-mail it out the results using the address on the report page...

Hi complete numpty when it comes to any sort of code so please be gentle.:) I have a report that picks up orders for our deep sea suppliers asking them to confirm shipment items and dates. Each page of the report is for a different supplier, the page header contains the supplier details. I...

Repeat posting Sorry about that, having a bad day, by the time i realised it was too late. I do try to be polite at all times, it costs nothing but opens many doors as my mother used to tell me regularly. :)

Memo field Thanks, but that misses me by about mile. Just bought an SQL book yesterday as i have been trying to avoid it as long as possible. Learning SQL leaves no time for fishing!:D It's all a matter of priorities. Give a man a fish and feed him for a day, teach him to fish and he can sit...

Hi, i have a fox pro memo field that has bill of materials information in like so:EACH KIT COMPRISES 1 CR10070SW £29.60 HALLITE PRODUCT 1 RBS24690 £0.82 1 RBS354 £0.95 2 RBS345 £0.75 1 S95MMEXT £3.90 £36.77 PER KIT I need to take out the...

Hi, i have a fox pro memo field that has bill of materials information in like so:EACH KIT COMPRISES 1 CR10070SW £29.60 HALLITE PRODUCT 1 RBS24690 £0.82 1 RBS354 £0.95 2 RBS345 £0.75 1 S95MMEXT £3.90 £36.77 PER KIT I need to take out the...

Result Thanks for your help, did this: Part no: IIf(Left([dbo_ILines]![Part],1)="*",[dbo_ILines]![Part]) This does the selection as you suggested, as I was after the invoice number for these parts I then put is not null in the selection criteria for the part to exclude the parts that do not...

Thanks Tried that but it won't work, it thinks it's a parameter and asks for a value. I only want the records that start with this as others may contain it but they are not required. Regards

I have a sales invoice table that contains parts that start with *, for example *SPR362. I need to select only those parts that start with the *, as this is the wildcard in queries how do i select those products that start with it without it being recognised as the wildcard and selecting all...

Foxpro import Thanks for that, how dum am I? Don't answer that, the feild is text and i am not sure all the records are numbers but it will certainly work for those that are. There are 1.4 million records and i aint checked them all! Thanks for pointing out the obvious, more thinking less...

Guys, i have a recovered Foxpro table, the problen i have is the numbers have the wrong format. To be exact, 63 should be 0.63, 1200 should be 12.00, 4250 should be 42.50. In other words i need to put in a decimal place two places to the left of each number. How do i do this on import ? Do i...

Guys, i have a recovered Foxpro table, the problen i have is the numbers have the wrong format. To be exact, 63 should be 0.63, 1200 should be 12.00, 4250 should be 42.50. In other words i need to put in a decimal place two places to the left of each number. How do i do this on import i? Do i...

Thanks For Your Help Thanks for your help, done it! Created a local table of the tax codes and it worked fine, try to pull it direct from the AS400 table it don't work??? Although it copes ok with the rest of the AS400 info and calcs no problem. Many Thanks