Hi NeoPa. You replied me as usual. Thanks.
I tried the same but not fruitful. One thing more I noticed that my visual basic is also not opening. I am thiking that this problem maybe due to corruption of system tables like MSysObjects etc. What's your opinion? I tried to import all objects by creating a new one but in vain. I also tried some third party softwares like Stellar. It recover my tables and queries but other objects e.g., Reports,...
Aftab Ahmad
Last Activity: Jun 26 '25, 03:33 PM
Joined: Jan 6 '15
Location: Dera Ismail Khan
-
'Id' is not an index in this table
Hello developers!
I was working on project since 1 month and it is going to finish in 2 to 3 days. My MS Access Database is saved in my flash drive on which I was working. Suddenly, the flash drive is disconnected without any reason and my opened Database is getting error as "'Id' is not an index in this table." I have more than 69 tables in this Database. How can I fix this issue as it is not indicate the table name which is not... -
Thanks NeoPa. You alwasy reply me. The issue has been solved by using a third party software named "Cimaware OfficeFix". Although, the all objects other than tables have not recovered however, as I said earlier, my records are important. So, I recovered the records through said software which is sufficient as I have a blank database of this project in which I have easily import all data. Thanks again....Leave a comment:
-
No. That's not what I meant.. Maybe this is due to my bad English as it is not my native language. My problem is simple which is how can I fix the subject error i.e., "The Microsoft Access database engine could not find the object "MSysDb". Make sure the object exists and that you spell its name and the path name correctly. If "MSysDb" is not a local object, check your network connection or contact the server administrat...Leave a comment:
-
Aftab Ahmad started a topic The Microsoft Access database engine could not find the object "MSysDb".in AccessThe Microsoft Access database engine could not find the object "MSysDb".
Hope all doing good. So, I have a Database of Microsoft Access which was working perfectly till yesterday. It was closed properly. Now, whenever I want to open my that very database it gives me an error of "The Microsoft Access database engine could not find the object "MSysDb". Make sure the object exists and that you spell its name and the path name correctly. If "MSysDb" is not a local object, check your network connection... -
Want to calculate balance
Hello experts!
So, I have a report called Ledger attached herewith.
My problem is that I want to calculate balance by subtracting or adding (according to the stituation) with previous record on each row like in first row (if you peruse the attachment), balance is (5,500) which is correct. In second row, it should be added with Debit amount i.e., 7,000/- which will give result as 1,500/-. What should I do for that very... -
How to disable "Do you want to allow this website to open an app?"
So, I have written a code for a cmd called "Send WhatsApp Message" to open and send WhatsApp messaage. The code is given below.
...Code:Dim IE As Object Set IE = CreateObject("InternetExplorer.Application") IE.Navigate "whatsapp://send?phone=" & Me.Mobile & "&text=" & "Welcome! Admission of " & " " & Me.StudentName & -
OMG! Thanks NeoPa. I completely understood. Now, its working fine. Thanks againLeave a comment:
-
Where Clause with Multiple Criteria
Well! I have a list called List537 and I want to show two number of columns in it, after entering my value (number) in an unbound text box. I know how to get data source in the list with a single WHERE clause however, I want to use multiple criteria to get accurate results. I have a table called "Objectives " where two columns are exists i.e., Number and Question. I want to show them in a List537 wherein quantity of bounded columns are two... -
Ok. Problem solved. Find the code written in my diary.Leave a comment:
-
MS Access VBA Password
Hello friends!
I am here again with the problem about MS Access VBA Password. I have lost my MS Access VBA Password. Is there any way to recover or remove it through VBA Code or macro not using any third party tool or software? -
Thanks NeoPa. It works...Leave a comment:
-
Run Time Error (Type Mismatched)
Hi Experts,
I have a DataSheet form where I want to search my record using an Unbound Textbox. I have write AfterUpdate code for Textbox which is as under:-
...Code:Private Sub txtSearch_AfterUpdate() Me.RecordSource = _ "SELECT * " & _ "FROM Students " & _ "WHERE (fncSearch([ID]," & Chr(34) & Me.txtSearch & Chr(34) & ",'Students')=True);" -
How to get HDD Serial?
Hi!
How I can get my Hard Disk Serial using vba like in picture. I have Access 2019 64 Bit. Also, either this will be change after installing new windows or not?... -
Connecting Biometric Device to Database
Hi
I would like to use a fingerprint scanner for school attendance. The data could be stored in access.
Does anybody have any info on this? What software / scanner will send data painlessly to a database? -
Open Database as Read Only
Hello friends!
I have a database where in many users have been entered. I want to open database in read only mode if my user is rather than admin. Is this possible? -
Can I run an append query by some condition?
Hi Friends!
I want to run an append query by stating a condition i.e.but nothing find after DoCmd.OpenQuery "QueryName" . Can someone help me?Code:DoCmd.OpenQuery "QueryName", "[ID]=" & Nz(Me.ID]
-
Invalid Use of Null
Hello!
I am getting error as Run-Time Error '94' Invalid Use of Null on my code
What should I do?Code:DoCmd.OpenReport strReportName, ReportView, , strReportFilter, acWindowNormal
-
Thanks Twinnyfo its workingLeave a comment:
-
Got nothing after calculation
Hi friends!
Please quick reply required.
I have set my formula in a query for the fields mentioned in attachment as
As you can see I have some fields as blank, thus my balance is not calculated. Please help...Code:Balance: [Receipt]+[Return]+[Previous]-[Sale]
No activity results to display
Leave a comment: