At Fixya.com, our trusted experts are meticulously vetted and possess extensive experience in their respective fields. Backed by a community of knowledgeable professionals, our platform ensures that the solutions provided are thoroughly researched and validated.
Ms access how can make data base in ms access and i want to make queries reports with event handling i want to know all features of ms acces give solve otherwise give most site names for free downloading
how to make a database in ms access and i want to know how to make queries using event handlinghow to make a database in ms access and i want to know how to make queries using event handling
You can't post conmments that contain an email address.
- If you need clarification, ask it in the comment box above.
- Better answers use proper spelling and grammar.
- Provide details, support with references or personal experience.
Tell us some more! Your answer needs to include more details to help people.You can't post answers that contain an email address.Please enter a valid email address.The email address entered is already associated to an account.Login to postPlease use English characters only.
Tip: The max point reward for answering a question is 15.
The repair method attempts to recover only the tables, indexes and queries in the database. Do not attempt to repair damaged forms, reports, macros and modules. Before executing the Compact and Repair tool, please ensure the following condition:
1. Do not Open Access database must closed
2. Sufficient storage space available - minimum double in size of your Access database on that Disk.
3. Close the .mdb file related to .ldb file before you delete the .ldb file.
4. Then Run the Compact and Repair tool
You say corrupt, in what way exactly? Do you get any specific error numbers/messages?
Have you tried Access repair program? Compact and Repair. If not, use it. But ensure that you made a backup, it is necessary because all the recovery tips can make the damage even worse.
Also try Jet Compact Utility. This tool created by Microsoft and it is much like Compact and Repair, but more successful in repairing.
If no one of above advice helps, then perhaps you need more powerful solution. In this case try to run a good third-party. I would recommend Recovery Toolbox for Access. It must help you. https://access.recoverytoolbox.com/
Try using Data > From Other Sources and select From Microsoft Query. In the Excel sheet, select the cell that you want the results to start in. Your MS Query would be pulling the data from your Access database.
Open the report is design view maximize the screen, in the open space right click. this will open the properties of the report as a whole. click on the all tab you will now look for the data source. you will see a drop down arrow next to the box that says table1. Hit the drop down box and you will see a list of all querys and tables selct the table you want. The report will now access a new data source. You will want to save the report as a new name or else you will not have two reports you will just have changed the first one.
Have you reached resolution yet? If not I would be happy to help otherwise, I would be interested to know what happened. It sounds like you need to call the date (today) for the appropriate balance to come in automatically - assuming you have a table holding this data. Thanks for rating FixYa!
before this u should know what is databse.
ms access has various objects likw table,form,query,report etc..
table is a object which stores the actual data and form is used to enter the data in to the table and display the data from the table, while report is object which is used to desplay your data in required formate.Query is used to fetch the data from the table in customised formate.for that u should have knowledge of SQL.
how to make a database in ms access and i want to know how to make queries using event handling
×