Actualization query

[slbenfica]

Hello,



How can I make an actualization query? When I go to query it does not appear that option. I am using the acess 2003.

Best regards

[pbaldy]

What is an actualization query?

[slbenfica]

I have a table with some columns. I would like to have one column that does a subtraction of two of the columns in the table. I have red that we have to make a query to "refresh " due to the fact that this last column does not exist in the input of the first table. The problem is that i don't find the way to do it. I am using the access 2003.

thanks

[pbaldy]

The query will "refresh" when you run it. If you were viewing it through a form, you could requery it as needed.

[slbenfica]

Hello,

Thanks for the help.
I manage to solve the problem by clicking on the rightmouse button in the structural view of the form and transform the form to an actualization one.
I have another question: I want to use the form to insert values in a table and i want to use list boxes but can´t find them to work. What is appearing in the table are the numbers and not the names that i have in the list box.
What am i doing wrong?

Thanks

[pbaldy]

Probably nothing. It is common in database design to store a numerical key value in related tables. In other words, if I have a employee table with an employee number and employee name, it is the employee number that I would store in related tables. I'd get the name by joining the tables in a query on the employee number field.

[slbenfica]

Hello,
Thanks.
I have another question: In the form, everytime I run it, i can change the value of the list box and the value on the table changes. I would like to each time i write a record, it saves in the table and i can't change it again. Can I use a button that does the "Update" in the table?

[slbenfica]

Hello,
I manage to do a program that is working.
How can I make it work outside Microsoft access, in another computer that may not be running access. Like an executable file.
Thanks

[pbaldy]

You can't. There is a free runtime version of Access 2007 available from MS. Previous versions required the purchase of a developer edition/tools.

[slbenfica]

Hello,
Thanks.
I have two more questions:
- Is it possible to do an executable that is located somewhere in the computer but not having to open the access or I have to open the access each time I open the program?
- I have a table connected to a form. In that form i input values that are added to the table. My problem is that i have lots of records in the table and in the form i have to go and look for the last record to add another one. How can i go directy for the last record?

Thanks

[pbaldy]

Again, no. An mdb or mde must run in Access. There's no way to make one into an executable that can run independently. I've seen methods of disguising that fact, but haven't used them myself.

I'm not clear exactly what you're after. Look at GoToRecord in VBA help and see if it does what you want, and/or try the combo box wizard, choosing the third option: "Find a record...".

[slbenfica]

Hello,
Thanks.
I solve the second question by erasing the rows on the table that are empty.
I have another question: I have a query that searchs in a table one value so that i can do a report about all the information on that value. I have a form that is linked to that query. The name of the value is written in the query. I know how to put the query asking the name to search but what i really want is to have a combo box with the values that i may choose to search in the query. How can i link the combo box of the form with the query itself?
Thanks

[pbaldy]

Try a criteria in the query of:

Forms!FormName.ComboName

Changing the form and combo names to their actual names.

[slbenfica]

Hello,

The program says i have a syntax problem. Do I have to use some kind of "" or [] or () in the expression Forms!FormName.ComboName ?
It is because the name of the form and the name of the combo box have space between the words and it says i have a missing operator...
Thanks

[pbaldy]

If you have inadvisable spaces in your names, you'll need to bracket them:

[Form Name]