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

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

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

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

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

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

Hi guys, I have a query that is trying to calculate a tax amount based on invoice value, but is variable depending on a customer tax code. So if a customer has tax code A,( this info is stored in the customer table) then tax is 17.5%, if tax code is X then it is zero but i still need to show...

Hi, i have a linked table where the date is stored as a number, can't change the format as it's an export file from an old system. The date is held thus: 20040629, for the 29th June 2004. I need to change this to a usable date to enable me to perform days since calculations. i am sort of half...