Search results

Great ! I made some minor adjustments and it works as I wanted. THANKS A LOT!!!

DataBase Hi The DB has no invoice nor payment data. I am using excel and data is becoming to much for excel. I am designing it based on what I have on excel and what I would like it to be. I have translated some of the tables and most important concepts into English so it is easier for...

I do not follow you. I am kind of new and green to access. Just in case this clarifies what I´m trying to do : I am desingning a Suppliers´s invoice database, that would use a form to record invoices received. There is a separated table for Suppliers that specifies the payment period for the...

The table and form names are in Spanish, but the principle is the same. Private Sub ComboPROVEEDOR_AfterUpdate() On Error Resume Next ComboSERVICIO.RowSource = "Select Tabla_PROVEEDORES.ServicioMaestro " & _ " FROM Tabla_PROVEEDORES " & _ " WHERE Tabla_PROVEEDORES.ProveedorMaestro = '" &...

I have checked the columns format and it seems it has nothing to do with it or it seems to be ok. The code was already posted in the Afterupdate event of the 1st Combo. Let me repet the situation just in case.PROBLEM: 2nd Combo is dependent of 1st Combo (with a code in Afterupdate event in...

Almost Works Hello I did what the link told me and it almost worked. I get the combo to be dependent on the other however in the form, after selecting the first combo, the dependent combo shows the posibilities blank. I checked and it works because in the table de 2nd combo chosen option is...

I am making a Invoice DB. I have made a combo for Suppliers which takes data from SuppliersTable and data is recorded in InvoiceTable. I have another Combo for Services which takes data from SuppliersTable and records up in InvoiceTable. And I have another field (PaymentPeriod) dependent on...

I am making a Invoice registration DB. In the Form I have made a entry “VAT =” calcultated as “ NetAmount + VAT%”. The result shows in the Form, “NetAmount” and “VAT%” which are manually entries are recorded in the table but “VAT” is not recorded in the Table. What could I be doing wrong?