Recent content by mu

Chris I tried both suggestions but only got #Name? The reason I hoped to calculate the total figure between the firstdate/lastdate fields is so I can easily change to previous months at the click of a button. I can now get round the problem using the line you suggested above that works as...

Chris Thanks for your reply, I have tried your suggestion and it works with =DSum("[saleinvtotal]","tblSalesInvoices","[saleinvtotal] > 0 and [saleinvdate] Between DateSerial(Year(Date()),Month(Date())-1,1) And DateSerial(Year(Date()),Month(Date()),0)") but I can't get it to work with...

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

Thanks pbaldy, i will give that a go

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

Thanks elana How quicks that, I'd only just got back to the forum page and its there. mu

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

Thanks for your responses guys and I will give your ideas a shot. With my limited ( but constantly improving ) VB knowledge I think I may be able to get something like what I want, if however anyone has something similar already working I would really appreciate some guidance as to the best way...

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

Thanks Elana Works great.:D

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

Thanks to both Fuga and Rich, the code Rich posted works fine. I think I may have been complicating things in my original idea.