I have a form with several tab controls for different nested forms, and one of them has a button to click and output query results. The button works fine, but the query is being output in a new window rather than inside the launching tab page.
Could anyone let me know how to open the query...
Thanks a lot for your quick reply. That should be the solution, but I am afraid I could not run the statement. Am I doing something wrong in DoCmd.RunSQL(queryStatement)?
----------------------------------
Private Sub ButtonSearch_Click()
On Error GoTo Err_ButtonSearch_Click...
I need to do something very simple: on a form I have a text box and a button, and I want to get the value the user enters in text box to search in a table (or query) and output only those records that contain such a value. I know it should be pretty simple, but I got confused with the VBA syntax...
Is there a way to detect on the client side if the Transport Layer Security (TLS) in user’s browser is enabled, with the help of JavaScript code?
We are using https and if TLS is not enabled, the user will not be able to view our pages. We want to detect the TLS state and give the user...
I need to create a standard set of search and select forms in my Access Database.
I have two forms perfectly working now; a search form which searches data according to some criteria and a data view form. For example, I search some person by the last name in my search form, and I want to move...
I have been trying to resolve a problem with writing data into a table. The code keeps giving an error..."Cannot append.."
I know the problem is with the data types in the destination table and I need to change something in this code to make it work. Any help is much appreciated.
Thanks
If...
Thanks for your answer.
The problem is that in the VB code there is a statement which uses IF NOT(...empty...) and the field should have a value in order to proceed. In the other fields the initial value is just set to 0 and it works. Only in one of the tables the same field is empty and it...
I need to set the default value of a field to 0 in a linked table, but it says, "you cannot modify it".
Could anyone tell me the steps so that I could modify the the initial value and also keep the links?
Thanks
Vard
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.