Search results

Hi folks! How can I execute code for every record in a subform when an event in a form is triggered? Thank you.

I have some lines of code in the after update event of a text box that insert a new record in another table. One of that new record's fields is the foreign key of the current selected record in the form. The problem is that it must insert only one record and a second unnecessary record is...

Hi again! I am developing a database that supports a video store. I have a table named tblInvoiceDetails that is in a one-to-one relation with a table named tblLateFees and the foreign key is in the tblInvoiceDetails. When a customer rents a video and after some days goes back to the store to...

Is it possible to change the color of the value of a cell in datasheet view? I have a subform that is displayed in datasheet view and I want it to show some values in color. Thank you.

Hi folks! I have a textbox that gets the result of a subtotal calculation and I want another text box get the result of the first textbox plus the tax, but besides that, I want that result to be stored in the Total field of that form's underlying table. How can I do this? Maybe a solution to...

Hi folks! In an invoice form I have a lookup that finds a customer. Once a specific customer is found, a button appears. I want this button, when clicked, to open the customers forms, but showing the record of the customer found in the invoice form's lookup. I read that this can be done by...

Hi folks! I have a form that has a subform. This subform gets its data from a query that returns the data of all customers. When I run the form, the subquery displays the data from all customers. I don't want it to work like that, I want to display in the subquery only the data related to the...

Hi everybody, I am appending the information I have in one table to another. The first table's name is Videos and it only has 5 records. When I append the information from the other table which has some of the fields of the Videos table (but doesn't have a primary key), the new records in the...