Search results

tnx a lot :), it worked in one column it is number, in the other column it is text. do they make

I'm using a control on a form as a parameter for my query. I've defined the criteria in the query as [Forms]![myform]![myControl] How do I set this up so that the query returns all records which have a part of the myControl that is typed in [myForm]![myControl]? does this work for both...

There is an employee table where characteristics of employees are recorded. Just as an example, we want a query to show female employees, employees aged 30, or both. In other words, we need the query to show records based on two criterion, however if one criteria is empty that criterion...

I have made a database, obviously with some forms, reports, queries and tables. It's size is about 11 megabytes. So far, I have put fake data in tables to see how it works. Now I want to start the job from an empty database. Shall I simply clear the records in tables and start the job? I did...

I have made a DB in access 2010. I want it to be opened in a machine which runs access 2007. But it says: Unrecognized database format. i read an article here: http://msdn.microsoft.com/en-us/office/cc907897.aspx that attributes this problem to new features on 2010 that are not available in...

The criteria of a query is coming from a dropbox on a form. There are 7 selections in the dropbox. How can we enable the user to select all of them? In other words i want the user to be able to select one, two or even all of the options.

thank you, is there a simpler explanation for the second paragraph?

A query/table shows our monthly financial status. There are expenses and incomes fields. I want to make a new field named:”sumup”. I want this field to be the result of current month incomes minus expenses plus “sumup” from the previous month record. For example on June we had 3000 income...

a new question, I have inserted a button on the form to save the form data on a table. I did this through the “command button wizard”. I would like to know if there is an equivalent VBA code which acts the same, ie. Saves the data and goes to the next record, just like what is done in the macro.

i found the solution somewhere else, i should use "ïnsert" function

could you let me know how can i do that by query for example? i mean what kind of designs does it need?

Many ones here disapprove loock-up. I have no idea as i don't have much experience about access. However, i think you can run a select query on the Union query to extract and show the names instead of the IDs.

There is a table where data about expenses and incomes are recorded daily. we want to get a balance. Shall we run a query or report? If we get the balance for the last year we will have 365 records that will be very confusing. Can we run a query which shows the balance only at the end of each...

There are two separate tables: Expense and Income tables. Each record the Employee ID, date and amount of the expense or income. Employee ID is a foreign key, looked up from Employee table. Lets forget about some simple ways such as making two different forms to insert expenses and incomes. I...

On a form there are some comboboxes and textboxes. They receive their data from other tables. For example table1 and table2. I would like to push the record button and insert the data from combobox1 in to table3, Textbox1 to table4 and textbox2 into both table3 and table4. How can I design...

Thank you, How can i perform this? Shall i delete the ID field from the query in "field properties"/look-up/row source? should i create a lookup table?

sorry i did not understand much on that page. As far as i know, Access suggests that tables be related by ID-field of the parent table. So you mean, we simply use the desired field instead of ID-field in queries?

sorry, in fact i did a full outer join between two tables. However, it seems to me that the problem is not about the type of the query, but it is about how to show the names back instead of the ID numbers.

thank you this sounds great. Could you let me know where i should make this "Interface Form"? i could not find it on create/forms. moreover will this "Interface Form" have an isolated icon so that the user starts it easy?

The field “costumer-ID” on the “order table” is a foreign key from “costumer table”, field “costumer-ID”. I managed the consumer name to be shown in the “order table” field “costumer-ID” instead of the number. But when I run a union query using field “costumer ID” from “order table, only the...