Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. SharonT

    Report parameters from a List box not working - any help please?

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

    Report parameters from a List box not working - any help please?

    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! :)
  3. SharonT

    Report parameters from a List box not working - any help please?

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

    Report parameters from a List box not working - any help please?

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

    Report parameters from a List box not working - any help please?

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

    Outer Join not working in Impromptu

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

    Outer Join not working in Impromptu

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

    Outer Join not working in Impromptu

    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`...
  9. SharonT

    Outer Join not working in Impromptu

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

    Outer Join not working in Impromptu

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

    Outer Join not working in Impromptu

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

    How to get barcodes into Access

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

    How to get barcodes into Access

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

    How to get barcodes into Access

    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?
  15. SharonT

    Autonumber a column in a query based on another column?

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

    Autonumber a column in a query based on another column?

    Does anyone know how to add an autonumber based on another column in a query and be able to specify the start number? e.g. I have a column called customer account and wish to generate an id for each new contact. (At the moment the are all zero. All contacts are secondary contacts so I want...
  17. SharonT

    Transformed TR1102

    I have the same problem also. Unfortunately, I don't have the answer. I only receive this error after I have successfully generated the categories in the model. So I get around the problem by reverting back to a version I saved before generating the categories. We haven't found a way back...

Part and Inventory Search

Back
Top