Recent content by Mainman
-
M
Creating a select all button in an access front end using VBA
Now I just have to figure out how to unselect them :) -
M
Creating a select all button in an access front end using VBA
SQL Server indeed, and they are linked. -
M
Creating a select all button in an access front end using VBA
I have added ADODB connection, so I think they should be connected. However I still need to tick a single line after hitting the select all button, in order for the select all to work. Private Sub Check45_Click() Dim rst As ADODB.Recordset 'sel = "0" If Check45.Value = True Then sel = "1"... -
M
Creating a select all button in an access front end using VBA
This is the table name in SQL -
M
Creating a select all button in an access front end using VBA
I have removed the set rst, but the issue still remains Private Sub Check45_Click() 'Dim rst As ADODB.Recordset 'sel = "0" If Check45.Value = True Then sel = "1" docmd.runSql "UPDATE machines.table3 set selected = 1" End If Me.Requery End Sub does not run, there is an error... -
M
Creating a select all button in an access front end using VBA
I am creating a select all button using VBA for an Access form. The Access front end is connected to an SQL back end. It is working, with limitations: When I tick the select all box I still need to tick a single item to select all items. The code I have implemeneted is the following(me.requery... -
M
How to place inserted values from one field to another based on selected combo box values in a different form
Ok thx for pointing that out. I'll continue here then. I'll attempt to issue a change event which will update it in the SQL query and see if that'll work. -
M
How to place inserted values from one field to another based on selected combo box values in a different form
Hi, Thanks! The first form would still be open when the box value would be inserted so any update would just show immediatly within access(the underlying database is in SQL. The access forms allow for data entry in SQL). Would adding code in the change part within the event procedure of the... -
M
How to place inserted values from one field to another based on selected combo box values in a different form
I have created a combo box in a form. The user can select two options. If a specific option is selected, values earlier inserted in a specific field of a different form should be automatically removed there and inserted in the column which is selected in the other form. Does anybody know how to...