Recent content by ameedoo3000

Thank you very much sir My problem has been solved perfectly I wanted to know the same method for quiries but I will do it in a new topic so as not to burden you Thank you very much sir again

no But I decided to cancel it now... and the code is working very well Thank you very much... my problem is solved Thank you Answer the question Why do I want to clear the contents of a table that may contain 100 fields: I work in a school "Recording students' exam results in the academic year"...

Unfortunately, nothing happened or changed.

iam sorry there was an error

Thank you very much I would like to execute this code in the button click event How is this Table name "Students" First field "ID"

As I said before, I want to empty all data from the fields without deleting the records and keeping the number of records in the table as it is because it is linked to another data table.

Unfortunately, the method is very long, especially since there are many fields, perhaps more than 100 fields.

Hello everyone I want to clear the contents of all the fields in a table without deleting the records There is a code (SQL Update Field) but it updates each field separately and the table contains many fields Is there a way to clear all the contents of the fields without deleting the records in...

Hello everyone How do I make a waiting mark (animated) when any event is run in the form until it is finished?

Thank you very very much Finally the code succeeded in achieving my goal Greetings to all

Private Sub Command1_Click() Dim acc As Access.Application Dim db As DAO.Database Dim strDbName As String DoCmd.Minimize strDbName = "C:\Users\Ahmed\Desktop\b.accdb" Set acc = New Access.Application acc.Visible = True Set db = acc.DBEngine.OpenDatabase(strDbName, False, False, ";PWD=123")...

I have two Access databases (A) and (B). I open (A) and open the second database (B) with password 123 by pressing a button in a form in database (A). Database (B) opens but does not appear on the front of the screen and is behind the first database (A). In order to show it I have to press the...

Sorry for the inconvenience All I want is that I have database A and database B and both databases are open and I am currently on database A and I want to go to database B when I press a certain button inside the form without using the interesting button and tab I hope my goal is clear ...

Unfortunately this code did not achieve what I asked for and there is an error in the code. Is there another instead of using the Alt + Tab button?

hi every body I already have two Access databases open at the same time. I want to switch to another database through the first one using the vba code. thank you