Recent content by SharonT

Hi, just to let folks know that I am not ignoring this but we had a network crash yesterday and things are not fully restored yet so I don't have access to my Access DB at the moment and I am out of the country next week! Thanks for all questions and hints to date and I will be picking it up...

I don't think the bound column is correct as I let the table generate a unique id so that may be causing the problem. Also, I can't debug at the moment as I am out of the office today but will give it a go when I am back in tomorrow. Many thanks for helping - this is turning me grey! :)

SELECT [Data_for_despatch_note SUB QUERY].h_deladd6_1, [Data_for_despatch_note SUB QUERY].Presort, [Data_for_despatch_note SUB QUERY].h_import_order_no, [Data_for_despatch_note SUB QUERY].l_oldproductid, [Data_for_despatch_note SUB QUERY].l_qty_required, [Data_for_despatch_note SUB...

Thanks for that. I have used this code on a different form where the user just keys data straight into the field and it works fine but it does not work for me with a list box. Do you need to do something with the 'On Click' event or similar when the user makes their selection from the list...

Hi I have read the faq on how to set up a report to accept criteria from a list box on a form and whilst I seem to have most of the relevant steps in place I don't seem to be able to tie them together to get it working. I think I am missing a crucial step. FORM: I have a form with two list...

Sorry, I didn't actually have a solution as such, just a work around. My work around was to create two separate 'iqd' files rather than put everything into one file. By doing this I didn't have to make the joins in Impromptu. The impromptu file was the source for my cube so I made the 'join' in...

Thanks all drlex - I did try swapping the code that you gave me and it gave me an error saying that my database driver (MS Access) does not support this type of join. Looks like I have my answer. griffindm - I think you are right that as I do have two outer joins and it doesn't seem to...

select T1.`OrderId`, T1.`Product_ID`, T1.`Website`, T1.`Name`, T1.`ProductPrice`, T3.`product_id`, T3.`unit_cost`, T3.`unit_quantity` from `orders` T1 LEFT OUTER JOIN `product` T3 on T1.`Product_ID` = T3.`product_id` order by T1.`OrderId`, T1.`Product_ID` select T2.`RMA_CREDIT_NUM`...

I have tried to do a few simplified versions of the report and found that if I linked "product" to "orders" (and nothing else) I lost a couple of records. A couple of old products had been removed. I changed this link to be an outer join and then got all records from the orders table. Then I...

Not sure how you want me to show this but if I go into "Joins" then "Definitions" in impromptu, it shows: product.product_id = orders.product_id orders.orderid = rma_credit.orderid and orders.product_id = rma_credit.product_id outer join for table "orders" is ticked. Thanks for the quick...

Hi, I have read a few other threads on this subject and still can't seem to get to the bottom of my problem. I have three tables in my report: Product, Orders, RMA_Credit Product to Orders should be an equal join and Orders to RMA_Credit should be the left outer join. What I am trying to...

Wonderful person, thank you very much! I will try it out.

We have a barcode scanner to scan barcodes produced on Special Delivery and Recorded labels. We just want to be able to print the barcodes rather than having to stick all the labels on. We are scanning the barcode labels and storing the resulting alphanumeric values in the Access database with...

We have a barcode scanner but no software to read the barcodes into an Access database. Does anyone know where I might find a free barcode font which handles both numbers and alpha characters please?

Thanks for the responses. I am trying to take some very bad old data and convert it into a suitable format for a data load into another database. The table which I need to load the data into requires a unique contact id per customer. I don't want to spend a lot of time writing code as I only...