Search results

aha! it works. I humbly thank you sir!

alright, I have some values in a table, and I want to count them up. I thought I could do a text field that looks up a query something like SELECT count(*) from myTable Where title=[textfield1]; textfield1 is another text field on the same form. I thought that it'll take the value in the text...

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...

thank youuuu

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...

Thanks Roy, Pono1, I tried doing that Me.RecordSource = recordset It says type mismatch

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 =...

you the man! thanks so much

sorry but there is still the problem doesn't matter if it's on change or not. what do you mean .text property? how do I change it?

but then it won't be able to update as the user types?

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...

great thanks!! I don't know how to thank you man. Thanks so much for your time and generous help.

SELECT table2.name, table2.weight, table2.age, table2.height FROM table2 WHERE (((table2.name)=[Forms]![myform]![name]) AND ((table2.Active)=-1)); ----------------- name is a text field in the form. Thanks a lot for your help!

thanks a lot one question: how do I define the Query? is it CurrentDb() lets say my query is in [Queries]![myqueryname] or does it have to be a table? It is an access query in the access file.

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...