Search results

yes it is very simple, but i could not find a way to run multiple functions on one single button. This is not provided by the wizard.

There are many forms and queries on the database which are visible on the left pane. Is there a kind of shortcut available that can be put on the desktop by which the user can directly go to a specific form or report directly? thank you

There is a bottom on a form that has an action for example to print or to run a query. How can I add a close function, so that the window is also closed when it is clicked? thank you

Thank you, Your guide was really constructive. When I ran the above code I received the desired columns and records from table1, but the records from table2 are missing data for columns C and D, which are the common column between the two tables. Could you please have a look at this...

Yes, Thank you it worked. However I still need help. I used this hypothetical problem to depict a simple picture of the main problem. The mentioned code provides the columns i asked, but with no record. In fact, I want the rows from both tables to be put together. I was thinking to a union...

I exactly copied and pasted the code in the SQL query. This was the result: "type mismatch in expression"

Table1 has fields: A, B, C , D, E and I. Table 2 has fields: C, D, E, F, G, H. Fields C ,D and E are foreign keys. Can we run a query to result Table3 with fields: A, B, C, D, F, G? In other words we want a third Table with records combined of the first two tables. Obviously fields A and B...

There is a combobox on a form which enables us to select items from a field in a table ( for example Field: color, in the Table car-details). Color record examples: red, yellow, green, black, gray. How can we limit the mentioned combobx to select fewer records of that field? For example red...

I have created a form to input data into a table. The ID blank shows the next number automatically each time I click or type data in other blanks of the form. But it seems that the ID change is irreversible and goes up. I mean even if I clear the whole form or I cancel the data to be inserted...

For some items such as “date” we can make different names. However, I think it is still preferable to have one “date” field to show both types of activities. But this is not possible for all the items. For example we cannot have two kind of “employee names".

Primary keys are already defined for each table: “expense ID” and “sales ID”. Moreover, the two tables are related to other tables appropriately. For example, the “employee name” field is a foreign key related to “employee details” table. However, the “Employee Expenses” table and “Employee...

There are two tables. The first one is “Employee Expenses” ( EE), where “employee name”, “expense type” ( such as transport, print, advertisement), “amount” and “date” are recorded. The other table, is named “Employee Sales”( ES) and stores “employee name”, “sold product”, “quantity” and...

dear missinglinq, tnx for ur time, i put it in the “OnClick” part of the command properties. but pushing the <enter> button still changes the selection among the form records, while no record is saved on the referred table. could you instruct? rgrds

I have created a form to enter data into a table. I want the user insert the data and go to the next record by simply pushing the Enter button on the keyboard. I made a button and put this code in the “On Enter” part of the command properties : Private Sub Command394_Enter()...

tnx a lot dear sparks80 :)

Combo boxes A and B are looking up texts from a table which has three fields: field 1: Personnel Names (PN), Field 2: Personnel Dimension (PD) such as Height and weight, and field 3: Related Data (RD). So we have a unique triplet combination. For example: (John, weight, 88), or (John, height...

thank you guys for the instruction

I have added an unbound textbox namely “textbox A” on a form. I typed an expression in the “Control Source” property box, for example [textboxB]*2. Now textboxA shows my desired calculation. I want this calculation to be inserted on table “turn over” , field “my sum”. but this does not happen...