Recent content by seat172

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