Search results

Hi, I would like to display the sum of all the payments referred to an invoice, in an unbound field in a form. The invoices are stored in the table FACTURAS, and the payments, in the table REC-COB. The main form is bounded to table FACTURAS and it has a subform bounded to REC-COB. The INVOICE...

Hi everyone, I am having issues with a split form which modal and emergent (pop-up) properties are set to yes. When I open it, it is maximized or out of the size I had setup; although I saved it trying to "freeze" the height and width. Does anybody know how it works? Thanks a lot, regards Rod

Hi, when I attempt to use the me.field = me.combobox.column() method to retrieve info from another query,it only works if I use column 0 or 1... it doesn´t work with higher columns number. - field name: cbofi - row source: listado-unico-fi <-- it is a query with unique values and 7 fields in...

Dear all, I have a text field with receipt numbers in the format 0001-00000### and I would like my data entry form to default the max existing value + 1. If max value is 0001-00000201, then the new record should suggest 0001-00000202. The problem is that if I use the "max" function, it does...

Hi everybody, hope you are doing fine. I have a continuous form based on table "INCOMES" that shows all the payments received, which mediums can be (field "PMNT_MEDIUM"): - check - transfer - taxes - cash Table "INCOMES" is filled using another form, but in this particular form I just want to...

Hi everyone this is Rod, I have a continuous form in which I put a command button for each record called "detail". I would like to click on the "detail" button and make it open another form containing all (and only) the info on this record. At first I refused to use an "id" to link both forms...

Hi everyone this is Rod, I am using MS Access 2007. I would like to display a report based on the table called "expenses", filtered by: - "from" (datefrom field) and "to" (dateto field) date on "payment date" field; - multiple criteria on same field called "payment method" (I would like to...

Hi everyone this is Rod. Hope I can contribute to the inquiries people post in this forum; hope you can help me too. Pleased to meet you all.