Search results

hello, I made a text box and I am trying to assign an SQL query to it. I tried putting this in the "control source" =(SELECT 4) But it keeps telling me #Name? It's driving me completely instane!!! why can't I do an SQL query in the control source?? Please save the hair on my head and help me...

hello, I am using SQL INSERT INTO where I insert values from my form Me!value1 etc I have an autonumber in the table where I am using INSERT INTO, and when I exclude the autonumber it says that the number of columns does not match. I tried assigning a number manually in SQL and it works fine...

Hello, I have a record set I open with SQL, and I have lots of fields that are assigned control source names (which are columns in my table) When I open the record set from a table, science the control source names agree is there a way I can fill all those out instead of going: Me!fieldOne =...

Hello, I have a problem maybe you guys can help me with. I have a text field, and I did those code for it: Private Sub SearchRecord_KeyUp(KeyCode As Integer, Shift As Integer) dim strSQL As String dim search As String search = Me.searchField strSQL = "SELECT [Mytable].[mycolumn]...

hello, I have a list box and I use this to add stuff to the list. I loop through the recordset to add all the items to the list box i use this: Me!RecordList.AddItem Item:=rst("id") & ";'" & rst("name") & "'" This does not work, but if I put this down: MsgBox rst("name")...

Hello, I have a form and I have a button so people can open records to load into the form. The problem is that whenever they close the form it updates the information in the table. How do I stop that from happening? I want the information in the table to update only when they hit the button I...

Hi, How do I loop over elements in a query? what would the loop look like? thanks in advance.

Hello, In a microsoft access file I have a button. I put some VBA code in the button to create an html file containing some javascript. When the button is clicked, I want it to load the file and then delete it (both loading and deleting scripts are in sub mouseClick() ), but when i did that...

Hello, I have an microsoft access application, and in the VBA code I am putting a file in a directory. I know how to do that, but I was wondering how I can find the directory the access file is in. I want to be able to put that file in the same directory as the access file itself. The default...