Search results

Hello MajP, I have made some slow progress with the Database. I need some expert advice regarding some issues. In this DB, i need to store historic values i.e. store all quotations with datestamp and other details. What i am trying is to Append the required data in new transaction table which...

Thank you. The correct expression was "Me.Parent![subfrm_04_qry_All_Item_List].Requery" for my case. I will check your changes and get back asap. Thanks again.

Hello MajP, I have another problem in a form. Main form name is "frm_04_Add_Items_To_Unit_Types" (it is to be used to add items to Units types and it will populate automatically in all units of same unit types). I have added numbers to keep track of form and their related subforms. Attaching...

Thank you pbaldy, What would that mean? Can I still communicate here or I need to do something else?

Hello MajP, I have created some forms for entering data in database. Can you check and let me know if there can be any useful functions or improvements possible. I am using queries as data source instead of direct tables. I have heard that it can provide us some flexibility later on. Is this...

Thank you MajP. I am creating forms to enter data like create a client, or create a project. and then I will use these forms to connect with a project and might make some additions in it. Thank you once again. You provided me best idea for the table structure. BTW, in tblRoomConfiguration...

Getting a VB Code error upon opening one of the form. Do the code need any corrections to the references?

Oh Thank you so much, I will check it and reply back.

Thank you. I will check it with entering more data and checkout what results I get. The query shown in previous post was looking accurate of what is needed. I will just check it with more data rows. Will get back to you asap.

Thanks MajP, Can you post the relationship window screenshot? I want to know, how you have related all tables currently. Have you made relationship of UnitTypes to both Units and tblroomconfiguration both? If possible, can you attach your copy of DB?

Correction: It should be Apartment and not just the room. If an apartment unit type is A, then all Type A apartment units will be identical, no change. 100% same. If there is any difference, we can change its Type to Type A1 before adding data in database. In same type Apartments, everything...

Thanks for the reply. If a room is Type A, then all type A rooms will be identical. Same number of bedrooms, bathrooms etc, and same number of furniture inside, same size ditto. This is why grouping is required, since all units are same, I need to findout a way to take advantage of it and...

Hello MajP, Tried some new relationships. I want to know if these would work or can give any problem further? Sorry I am no expert and just learning and understanding. Sharing with you for valuable feedback. I can get all the details required in the query. Only issue is arranging data entering...

Thank you MajP for looking into it so deeply. I appreciate all your efforts. What i am trying to create here is an imitation of an existing web database. I am trying to create same or better options within access. I have attached few images for the information. My final target is the not the...

Let me explain it to you. Assuming there is an apartment complex, which have 30 apartments. We know that there are 30 individual apartment units, but we do not want to fill in details of each apartment manually by typing. We also know that there are 3 Types of design of apartments. Type A is...

Thank you MajP for your precious time for the review and the advice. I will work as per your method. BTW, i also need to add components to each room in each apartment unit. Each type of group i.e. Type A, B or C will have same layout of rooms and components as well.

Thank you for your reply. Sorry i am not expert in access. Yes, I have used one to many relationship and not many to many. You may be able to get better idea from the database. I am attaching herewith. There is chain of relationship i.e. Client --> project --> unit types --> units --> rooms...

I am preparing a database. In databse, I have two linked tables. One parent and one child table with more records. Parent table would have some records of similar items, for those child table will have to have same record except the primary key. I want to avoid time to type same information in...

Hello everyone, I am Anuj from India. Feeling great to be a part of this community.