Search results

* IMPORTE indiv: name of the field that contains the payment amount

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

Dear "new_guy_tom" and "gemma"... unfortunately, none of your replies worked. The first one simply did not work since the form kept opening "almost maximized" (but still restored). The second one threw me a "end/debug message since the runcommand acCmdSizeToFitForm "was not available" or...

1) Did so; 2) (without saving) I switched to form view; 3) manually changed the form size; 4) right clicked over the pop-up title bar and saved the form; 5) closed the form; 6) reopened it and again it opens "restored" but all the way stretched to the full window (but not maximized). Am I...

I have already tried that, my friend; even saving in design view, changing to form view, resizing it; saving again... and so on. Is there any way to fix the size?

Auto resize = Yes Auto center = Yes Adjust/fit to screen = No Borders style = adjustable I read some people change the form size, then switch to form view, set the size we would like it to have, and then save the form... however, it did not work either. Also tried setting the form size and...

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

It only displays one, but the row source points to a query which has 6 fields. It is my understanding that I don´t need to display the whole 7 columns of the query in the combobox... that I can just display one, and reference the other values, such as I did with the "column(1)" reference...

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

Unfortunately neither max nor dmax worked... also tried with the right digits from the string without being successful. I know you are right but I would need to change not only this table, but also 3 more tables and the problem is that I use that number as a key many times. I can not change it...

Thanks for the prompt answer, however considering that I have it already stored in such a way, and due to the fact that when I sort it Access seems to recognize a min and a max value, I was wondering how does Access do that. I think I can also try calling the "receiptnum" higher value and...

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

solved... Re-setup the filter on load criteria and saved, closed and reopen de form... it´s working. On load: everything but "Ret IIGG" nor "Ret IIBB" When I click over "clean search": everything but "Ret IIGG" nor "Ret IIBB" Now if I put "Ret..." in the search bar, it shows me those records...

Now I think I did it right, went to the form design view and then "view code" and added Option Explicit Private strFilter As String Now when I hit the "clean button" it filters what I had filtered (which was another filter I was using) when I set that up... how do I set it up for filtering...

Well I have done so for 2 and 3... for 1 I don´t know if I did it in the right place: I went to the main menu in access, "create" tab, then "module" and when "Option Compare Database" appeared, I pasted the rest: Option Explicit Private strFilter As String was it right? cause you mention to do...

dim xxxx as (variant, string, date) is what I know...

Note: when I say "taxes" or "tax1" or "tax2" it is the same for instance... what I do have in the field is not actually taxes but "Ret IIBB" or "Ret IIGG" (which are local country taxes). These are the 2 f... values I don´t want to be displayed :P

1) filter on load property works, indeed: form properties, data tab, filter field: [form name].[PMNT_MEDIUM]<>"taxes" AND [form name].[PMNT_MEDIUM]<>"taxes2" form properties, data tab, filter on load: YES ======== 2) clean filter button, I replaced my "rudimentary" code with the easier...

I don´t know how to write it in the code for the "clean filter" button... It is a syntax problem, I am not programmer. Or perhaps I can create the button again with a different instruction: do a form reload (is this a requery? or a refresh?) so that it uses the "filter on load" property; Or...

Everything works, but when I "clean" the filter it does not "clean" the taxes... just puts a "" in the search bar, and calls the "search" button, showing all records. 1) I would like to auto-filter on form load based on [PMNT_MEDIUM] not equal to "taxes" but I don´t know how to syntax it when I...