Search results

Hello all I wonder if someone could have a look at the following code and tell me where I am going wrong. What I am trying to do is create a total monthly sales figure which only includes '+' sales figures, in other words that doesn't include any credit notes/payments on account etc that may...

Hi all I have downloaded and looked through various db's and have searched this forum trying to find a way of populating a combo or list box with the values I want. I don't think it should be that difficult and thought somebody somewhere would have used it but can't find any examples. Anyway...

Hello everyone How can I get a 1 text box to display the current month and another text box to display the previous month ? Obviously at the begining of each month I would need them to update automatically. It looks really obvious and probably it is but I cant find a way to do it. Thanks mu

Hi everyone I dont know if this is possible or whether I have missed something very obvious but what I would like to do is this: I have a date entry form for posting invoices, in order to speed up data entry I would like to be able to just enter the invoice date eg 5 and then when leaving the...

Hi everyone I am creating a form that will allow me to allocate payments against purchase invoices, the account is selected via a combobox in the main form and the invoices are listed via a continuous subform. I have got the form working mostly how I want it to but I am having big trouble with...

I have a form which allows me to list an account's numerous invoices and then allocate a payment against them. The form is a continuous form and I have the following fields. The main field on the form is the 'amountpaidfield' field, then listed on the subform I have, among others, the following...

I have a form I am using to enter data, at the same time as entering data to the current record I may occasionally have data to be added to or entered into another record, but the main use is for data entry. I know I could open a second form to complete the task but my prefered way if possible...

I'm attempting to design a from that will pay outstanding invoices. Each account may have more than one invoice outsatnding each month, the amount owing is displayed via a subform (continuous form) and all the fields on the subform are locked apart from the 'payingnow' field. To speed up data...

I am attempting to design a data entry form for entering purchase invoices / credit notes. Most entries are purchase invoices so my default invoice type is INV ( pur invoice). This is no problem and is working well. I am having trouble however when the default is changed to CRE (credit note)...

I am working on a form that will allow me to enter purchase invoices, to speed up data entry i have been trying to get the defaultvalue of the VAT field to show the sum of a calculation, the calculation is the invoicenett field x 17.5%, The reason i want it to be the defaultvalue that shows the...