Search results

I want to check if a condition is true for a particular field in each record of the subform and if it is true update another field in the same record. I want this to happen for every record in the subform but this should be triggered in the current event of the form containing the subform. You...

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...

No, how do I check that?

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.

Yes, but I would like to do it without a button, just automatically, so don't anybody knows the name of the event I have to use ?

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...

I don't know if my solution will work for you, but I had the same problem and I just added: Me.refresh after the lines of code that assign the combo box values to the bound fields in the AfterUpdate() event.

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...

Oh, thank you so much guys, it worked perfectly.

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...

Yes, it is already set in increment, not in random, and doesn't work

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...