Month: May 2024
I have an Issue with event DropDown in combobox in Access’s form
n a form, I have a combo box that changes dynamically, i.e., during execution each time I select it. Everything works fine except for the DropDown, which does not “auto-expand.” I am sending the code I am using.
Thanks
Const MarcaSQL1 As String = “SELECT pres_marca.Marca FROM pres_marca;”
Const MarcaSQL2 As String = “SELECT pres_modelo.Descripcion FROM pres_modelo WHERE (((pres_modelo.marca)=[textomarca]));”
Const MarcaSQL3 As String = “SELECT pres_cisterna.descripcion, pres_cisterna.Marca FROM pres_cisterna WHERE (((pres_cisterna.Marca) = [Textomarca])) ORDER BY pres_cisterna.Cisterna;”
Private Sub Form_Current()
Seleccion = 1
Caracteristicas.RowSource = MarcaSQL1
Caracteristicas.Requery
End Sub
Private Sub Caracteristicas_AfterUpdate()
If Seleccion = 1 Then
Textomarca = Caracteristicas
Seleccion = 2
Caracteristicas.RowSource = MarcaSQL2
Caracteristicas.setfocus
DoCmd.GoToControl “Caracteristicas”
Caracteristicas.Dropdown
ElseIf Seleccion = 2 Then
Textomodelo = Caracteristicas
Seleccion = 3
Caracteristicas.RowSource = MarcaSQL3
Caracteristicas.Requery
Caracteristicas.setfocus
DoCmd.GoToControl “Caracteristicas”
Caracteristicas.Dropdown
ElseIf Seleccion = 3 Then
TextoCisterna = Caracteristicas
Seleccion = 1
Caracteristicas.RowSource = MarcaSQL1
Caracteristicas.Requery
Caracteristicas.setfocus
DoCmd.GoToControl “Caracteristicas”
Caracteristicas.Dropdown
End If
End Sub
n a form, I have a combo box that changes dynamically, i.e., during execution each time I select it. Everything works fine except for the DropDown, which does not “auto-expand.” I am sending the code I am using.Thanks Const MarcaSQL1 As String = “SELECT pres_marca.Marca FROM pres_marca;”
Const MarcaSQL2 As String = “SELECT pres_modelo.Descripcion FROM pres_modelo WHERE (((pres_modelo.marca)=[textomarca]));”
Const MarcaSQL3 As String = “SELECT pres_cisterna.descripcion, pres_cisterna.Marca FROM pres_cisterna WHERE (((pres_cisterna.Marca) = [Textomarca])) ORDER BY pres_cisterna.Cisterna;”
Private Sub Form_Current()
Seleccion = 1
Caracteristicas.RowSource = MarcaSQL1
Caracteristicas.Requery
End Sub
Private Sub Caracteristicas_AfterUpdate()
If Seleccion = 1 Then
Textomarca = Caracteristicas
Seleccion = 2
Caracteristicas.RowSource = MarcaSQL2
Caracteristicas.setfocus
DoCmd.GoToControl “Caracteristicas”
Caracteristicas.Dropdown
ElseIf Seleccion = 2 Then
Textomodelo = Caracteristicas
Seleccion = 3
Caracteristicas.RowSource = MarcaSQL3
Caracteristicas.Requery
Caracteristicas.setfocus
DoCmd.GoToControl “Caracteristicas”
Caracteristicas.Dropdown
ElseIf Seleccion = 3 Then
TextoCisterna = Caracteristicas
Seleccion = 1
Caracteristicas.RowSource = MarcaSQL1
Caracteristicas.Requery
Caracteristicas.setfocus
DoCmd.GoToControl “Caracteristicas”
Caracteristicas.Dropdown
End If
End Sub Read More
Action ‘terminate’- “Enter custom value” not working
ello,
the action ‘terminate’ provides the possibility to enter a custom value.
But every trial ended up with an error.
Can anyone give me a hint, how to use this?
Br.
ello,the action ‘terminate’ provides the possibility to enter a custom value.But every trial ended up with an error. Can anyone give me a hint, how to use this? Br. Read More
Microsoft Graph API: can’t filter by companyName
I am trying to filter users by the ‘companyName’ field and always receive a ‘400 Bad Request’ error. As suggested in many similar issues, I added ‘$count=true’ and the ‘ConsistencyLevel=eventual’ header, but still no luck. Is it possible at all to filter users in my tenant by this field?
betav1
I am trying to filter users by the ‘companyName’ field and always receive a ‘400 Bad Request’ error. As suggested in many similar issues, I added ‘$count=true’ and the ‘ConsistencyLevel=eventual’ header, but still no luck. Is it possible at all to filter users in my tenant by this field? betav1 Read More
Unable to get user details after Notification Bot is app installed
I’ve a Notification Bot, which is currently deployed to my organization, and all the users are able to see it and add to their teams app individually. I want to send welcome message to all users who’ve installed the app. I’ve an endpoint added in the bot framework which gives me an update whenever someone adds or remove the app in their teams app. But whenever someone is installing the app, I’m getting this error “Failed to acquire token”. I’ve tried to install the app from Admin teams to all users as well from particular user by going to “Teams store > Built for your organization > App > click on “Add””. But both of the options are giving me same error.
Here is the Bot permission given by admin in Portal Azure
I’ve added the Application Id as my BotId according to the documentation and BotSecret as well
Please help me in solving this problem.
P.S. I don’t know what this “d6d49420-xxxx-xxxx-xxxx-xxxxxx” resembles while the former one is my BotId i.e., “28c8b3b1-xxxx-xxxx-xxxx-xxxxxxxx”.
Thanks in advance.
I’ve a Notification Bot, which is currently deployed to my organization, and all the users are able to see it and add to their teams app individually. I want to send welcome message to all users who’ve installed the app. I’ve an endpoint added in the bot framework which gives me an update whenever someone adds or remove the app in their teams app. But whenever someone is installing the app, I’m getting this error “Failed to acquire token”. I’ve tried to install the app from Admin teams to all users as well from particular user by going to “Teams store > Built for your organization > App > click on “Add””. But both of the options are giving me same error.Here is the Bot permission given by admin in Portal AzureI’ve added the Application Id as my BotId according to the documentation and BotSecret as wellPlease help me in solving this problem.P.S. I don’t know what this “d6d49420-xxxx-xxxx-xxxx-xxxxxx” resembles while the former one is my BotId i.e., “28c8b3b1-xxxx-xxxx-xxxx-xxxxxxxx”.Thanks in advance. Read More
