Search results

  1. W

    Solved "Update query" to update Value in one column based upon value of other column in same table

    Thanks a lot, This works. Appreciate for your looking and solving my problem. We created a custom join. I have like 7 fields to update in my update query. I will check at my end, if i can create custom joins for all of these fields or not. Thanks again
  2. W

    Solved "Update query" to update Value in one column based upon value of other column in same table

    Thats all right!, Learning is no fun without making mistakes.
  3. W

    Solved "Update query" to update Value in one column based upon value of other column in same table

    Hello Everyone, I have a table with part of it's data coming from an Append query. In next step, some of other columns are needed to be filled upon the basis of what is the existing value in other columns of same table. 1. Attaching an example DB, where tbl_ItemWardrobes is partially...
  4. W

    Hello MajP, Hope you are doing fine. I have made some progress in my database and stuck on an...

    Hello MajP, Hope you are doing fine. I have made some progress in my database and stuck on an issue. Please review the recent post, whenever you have time and let me know what is possible solution. Thanks for all your help
  5. W

    Solved Need expert advice regarding the table structure of Subtypes and supertypes

    Update - 22/11/20: I think, I will be going with method of exporting the query as a new table and work on it. thanks Removing the attachment. Hello again everyone, I have been slow in updating my database but have made some progress this month. I am again stuck on a issue and seek advice for...
  6. W

    Solved Need expert advice regarding the table structure of Subtypes and supertypes

    Do you guys have any sample of craftily setup cascade combo boxes in continuous form?
  7. W

    Solved Need expert advice regarding the table structure of Subtypes and supertypes

    Hello Guys, I need some help in one form. This Add item parts form is linked to above subform. I need to enter data in Add item parts by selecting items. There are 3 cbo for Itemmain, Itemsub and item. This is basically to categorize the items. If I individually choose record source as a...
  8. W

    Solved Need expert advice regarding the table structure of Subtypes and supertypes

    Oh there is no Standard size or so. Size of an item can be from 500mm to 5000mm. I need the price to appear or calculate automatically depending upon whatever size we fill in manually. I already have a product table all i need is how i setup pricing according to the slab. I am actually unable to...
  9. W

    Solved Need expert advice regarding the table structure of Subtypes and supertypes

    Hello Part/Mike Hope you are doing good. I need some advice in adding a pricing structure for the items in database. Scenario is we have say approx 10 basic product category. For example Product 1, Product 2, .... up to Product 10. Then we have 7 variant of each Product and that makes it...
  10. W

    Solved Need help regarding my databse. Seeking experts advice.

    Hello MajP, Hope you are doing good. I need help in adding a pricing structure for the items in database. Scenario is we have say approx 10 basic product category. For example Product 1, Product 2, .... up to Product 10. Then we have 7 variant of each Product and that makes it. Product 1A...
  11. W

    Solved Need expert advice regarding the table structure of Subtypes and supertypes

    I have removed the few extra tables. Removed spaces from the table fields and removed lookup queries from tables. Can I keep typed list of look up items instead? will that be fine?
  12. W

    Solved Need expert advice regarding the table structure of Subtypes and supertypes

    Thank you Pat and Mike for your suggestions. I will look into it again as you have advised and will try to get back.
  13. W

    Solved Need expert advice regarding the table structure of Subtypes and supertypes

    Hello Pat and Mike, Thanks for the reply. The detail is quite complex as there are more details to be added to each category later on. I am not very good in Access and learning at the moment and trying to achieve some results from my work. The customer screenshot is just an example from a...
  14. W

    Solved Need expert advice regarding the table structure of Subtypes and supertypes

    Hello, This is my second post here and I need help in regard of arranging my table structures. I have basic knowledge to Access and learning more at the moment. I have a basic table (Super-types) of products in which we have common attributes and various additional attributes need to be divided...
  15. W

    Solved Need help regarding my databse. Seeking experts advice.

    That's fine. I might open a new temporary thread if I need to ask anything and will get back to this main thread when you are back. Have a good time.
  16. W

    Solved Need help regarding my databse. Seeking experts advice.

    Thank you for giving your time and the code above. I will try to work it out as per your advice. As you mentioned, I will try to run things with VBA instead of macros.
  17. W

    Solved Need help regarding my databse. Seeking experts advice.

    Transaction table is nothing but all the data we entered into system to create a quote. If you check the relationship, you will see how there is a series going. starting with client details, project detail, units and room config, then further products, and later will be adding product details...
  18. W

    Solved Need help regarding my databse. Seeking experts advice.

    Sure, Take your time I will wait for your response. Thank you
Top Bottom