Recent content by HASAN-1993

And how do I make a Windows Service that adjusts the table

I honestly don't know because I only work in vba

I have a module that I made in the past, and I will send it to you later if you want

I thought about this solution, but the problem is that the table (customers online) when there is no internet connection, the query will not work at all

Ok. I have a program, the frontend in Vb.net language, and I do not have access, and the backend is ms access, and I have full access. Now the program is calling a query named Customers. All I want is when the program calls this query, is for the query to check a specific condition. If the...

As I have already explained, I do not have an option to run the Vba code except when opening the query itself because the program is in another programming language, so if I make a function QueryDef, how will I run it when opening the query

Ok, in this case, how can I run the code before opening the query

I searched and found out that this solution is not possible The whole idea is that I want Query when opening it, if there is internet, it opens a table, and if not, it opens another, exclusively when opening Query because the program is in another programming language and I do not have access to...

Passing the table name with variables. I have Query. I do it from the Query builder itself, not from Visual Basic Editor. But I want to pass the table name from a variable or from a module. Does anyone have an idea?

Ok now, I no longer have to disable my custom menu thanx

You are correct, but I used my Custom shortcut menu But the problem was that if the user placed the mouse between the fields and expanded the field, then he can, if you try that, you will know what I say

After a deep reflection I found the solution to whom it may concern Me.Mytextbox.ColumnHidden = True Me.Mytextbox.Enabled = False Private Sub Form_MouseUp(Button As Integer, Shift As Integer, X As Single, Y As Single) If Me.Mytextbox.Enabled = False Then Me.Mytextbox.ColumnHidden = True End...

There are several reasons that prevent me from using continuous Form is There a way to use datasheet View

I tried Private Sub Form_MouseDown(Button As Integer, Shift As Integer, X As Single, Y As Single) if me.txtbox.ColumnHidden = true then me.textbox.ColumnHidden = true End If But in this case, I can no longer move any other field

This option is not possible Because the field can be used if the user chooses this option But there is a condition for it to appear, an error that appears without the condition, so I want to Prevent the user