Hello Everyone,
I have several questions. I was not sure, which sub forum shall i use, that's why I'm writing in General.
I created new DB,(this DB is for our IT-Equipment) and also tables and relationships. I have also Forms. My main Form name is "Personal_Info". This Form has also 4 (5. will come) Sub-forms. All of them connected with Email. And every Personal has devices. Which personal if you want to look you can see their devices. I will also send my DB and there is some Dummy Variables.
What generally I need :
1- Search in Main Form: I checked from internet. There was interesting solutions. But I could not match in my head. Also write some codes but did not work. I deleted all of them. Only there was a simple search with Query. But i was not what i needed... Or may be it was, but I could not continue.
What do I need:
I have List-box. And DB-User can see all E-Mails as a list. On top of List-box there is search bar. In this search-box I wanna search E-Mails in List-box. And when I click on This E-mail, it should go directly that record then DB-User can see all devices (Sub forms), which E-mail searched.
2- New and Edit : When DB-User Click New Button, automatically opens form "New Devices" or for Edit Button opens "Edit Devices" (I did not created this form.)
What do I need:
In this New Form, there is some options. First Choose your device, then other questions. The important one I do not want to see all options when i choose one, then comes other text or combo box. Other boxes shall be invisible until choosing Device.
For example : First Question
Choose your Device : (There is combo box) DB-User chooses Laptop, Then other question will open. Choose your Vendor, then Category etc.
I created for every devices different Tables also for every Category or Status different. I really do not know how can I do that. Because after choosing one of them, Laptop then it shall save all information in laptop table.
I really need your help, how shall I start this ?
This is just the beginning.
I thank you for your helps and understanding.
EDIT : After warning of moke123 I compacted and repaired my DB.
Thanks.
I have several questions. I was not sure, which sub forum shall i use, that's why I'm writing in General.
I created new DB,(this DB is for our IT-Equipment) and also tables and relationships. I have also Forms. My main Form name is "Personal_Info". This Form has also 4 (5. will come) Sub-forms. All of them connected with Email. And every Personal has devices. Which personal if you want to look you can see their devices. I will also send my DB and there is some Dummy Variables.
What generally I need :
1- Search in Main Form: I checked from internet. There was interesting solutions. But I could not match in my head. Also write some codes but did not work. I deleted all of them. Only there was a simple search with Query. But i was not what i needed... Or may be it was, but I could not continue.
What do I need:
I have List-box. And DB-User can see all E-Mails as a list. On top of List-box there is search bar. In this search-box I wanna search E-Mails in List-box. And when I click on This E-mail, it should go directly that record then DB-User can see all devices (Sub forms), which E-mail searched.
2- New and Edit : When DB-User Click New Button, automatically opens form "New Devices" or for Edit Button opens "Edit Devices" (I did not created this form.)
What do I need:
In this New Form, there is some options. First Choose your device, then other questions. The important one I do not want to see all options when i choose one, then comes other text or combo box. Other boxes shall be invisible until choosing Device.
For example : First Question
Choose your Device : (There is combo box) DB-User chooses Laptop, Then other question will open. Choose your Vendor, then Category etc.
I created for every devices different Tables also for every Category or Status different. I really do not know how can I do that. Because after choosing one of them, Laptop then it shall save all information in laptop table.
I really need your help, how shall I start this ?
This is just the beginning.
I thank you for your helps and understanding.
EDIT : After warning of moke123 I compacted and repaired my DB.
Thanks.
Last edited: