Search results

My app includes a Combobox which is bound to a query for a list of values, and it gets a default value from another query. if there is a default value than I can select a value from the drop down list but if there is no default vaqlue than I can see the list of values in the dropdown but canot...

I was able to do what you suggested and the data in the combo box does change but since it is bound to the lookup table (Query2) it updates the lookup table, how do I prevent that update?

I am a little bit confused, I am working with two queries, Query1 is the main quey which has the forign key. Do I need to set the "Default Value" property of the combo box to the forign key in the main query and the "Control Source" property to the field in the query?

I have the following scenario: 1. A form which is bound to a query (Query1) 2. Several txt boxes which are bound to fields in the query (Query1) 3. Several combo boxes which get a list of values from another query (Query2) and a default value from Query1 When I click on the arrows at the...

Thank you for your help, I got it to work. I do realize that the way it was written it updates all the records, the code which I posted was just a test code for the combo box The Syntax is: Eval(" Forms.Devices.Combo40.Column(1)")

Any syntax other than what I put there results in a syntax error when I save the query so I assume that it is correct. You are are right about using the Eval() because when I run my form I am getting a popup which asks for the value for that parameter. How do I use Eval() do I need to write VB code?

Thanks, works like a charm. I am using a parameter from the same combo box as an input for a query but getting an error. The query which loads the combo box loads it with two columns and the ID which is used for the query is the second column, I guess I have a syntax error, please help UPDATE...

My application includes a Combo Box which gets it's values from a query, when I close the form it inserts the value which is in the combo box into the table from which that data came from. How do I prevent the insert?

Access 2003 VBA My project includes a form with a combo box, text from the combo box is an input to a query. when I run the query in design view it prompts me for the parameter name and the results are correct, when I run it from the form using the input from the combo box I get error 3061, too...

Yes, I can join them in a query.

Yes I can I ma going to try it in a few minutes, is it going to work for more complicated queries which involve more that on table?

One last thing, I run a query in my VBA code and it returns a single value, how can i assign this value to a string? resultString=DoCmd.OpenQuery "qrySerialNumber"

Eureka, that was the problem, control source was set to a constant. Thank you for your help

I need to display data stored in a SQL 2005 server on an Access 2007 form. I have a bunch of stored procedures in the SQL server that I would like to use but I cannot figure out how to call them from Access. Please help me with that (link?)

The VBA code that I am using does not even access the database, it attempt to write a hard coded string into the text box, I suspect that it has to do with a property of the text box but I do not know which one it is.

I am using Access 2007 and txtSerialNumber is a text box control. I am not sure what you mean by "can you put values in it from the keyboard?" I tried to type data into the text box from the keyboard and I am not able to do that. Maybe I can get two for the price of one, I am using that Access...

I need to populate a textbox with some data after a selection is done in a combo box, I get an error when I try to enter eny data into the text box. the code below is a test code which gives the error. Private Sub cmbServerName_AfterUpdate() txtSerialNumber.Value = "5" End Sub The error is...

Thank you for the your help

I am new to access so please bear with me. I am using an Access form to display data stored in an SQL2005 database. I was able to successfully connect to the database using ODBC and my form has a combo box and a text box. I wrote a query in Access which runs successfully against one of the...