Search results for query: *

I am not sure if this is possible or not but here goes, I am trying to create someway of importing/transfering numerous records (10) into a continuous form, each record has the same basic data of date, payee and amount and will remain the same most of the time, they are monthly Direct Debits and...

Thanks Jo The help and advice I've recieved on this board has always been very helpful but never as thorough as this. mru

Hello JoanneM The only way I could think of sourcing the data was with a query, I didnt know if this was the best way or how I could write a query that would do it properly Thanks mru

Hi everyone Can someone give me some idea of the best way to make the following form work. What I intend to do is make a (continuous) form that will list all product suppliers. Thats easy enough but the data I would like to show for the suppliers comes in 3 columns which are: "sum...

Hi everyone. I have eventually got it working correctly by using a 'form.recalc' and the doevents. Thanks for your help MRU

Hi billpower and Darrylle The "purpaypaybtn" Button is on the footer of the subform, I had tried it on the main form first but found it easier to get working when placed on the subform. The main form is 'frmPurchasePayments' and the subform is 'frmPurchasePaymentsSub'. Thanks MRU

Thanks billpower, Here goes, the only field that affects the calculation on the main form is the (purpayamount) field, I have set up a hidden field on the sub form header (in order to make the calculations easier)called 'Paying', this is updated each time the field on the main form is updated...

Has anyone got any suggetsions ?

Hi billpower Thanks for your suggestion, I tried it last night, unfortunately it had made no difference. I tried placing 'DoEvents' in various places on the code but it didnt work. I looked up 'DoEvents' in the help file to check if there was anything I was doing wrong and read somewhere that...

Darrylle Yes the button works fine if you click it, but if you click it repeatedly and quickly the effect is the same as holding the keys down. Thanks MU

Hi Darrylle Thanks for your reply, what I mean is - I have a button on the form called '&PayInv'. I dont actually click the button what I do is press alt-P quickly or hold alt-P down. The code I have working is on the 'onclick' property. I hope this explains it better, Thanks again MU

Hi Everyone I have a form which I am creating which will allow 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 fields on the form are the 'supplierID' & 'amountpayingfield' fields, then...

Thankyou essnrv and johnwm for your help, Ive tried your suggestions but again unfortunately I cant get it to work. I created a new unbound textbox (my intention being to copy the entered date to the bound 'datepurchased' field, which has been hidden, after the date has been formatted) now when...

Thanks for your reply essnrv, I copied your Function and tried to apply it to my form but I cant seem to get it to work. All that happens when I enter 5 for instance is I get a message box saying ' The value entered isn't valid for this field' I've tried calling the procedure from the...

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

Hi LittleSmudge I am using DAO and using access 2000 the table name is 'tblPurchaseInvoice' the table primary key is 'purinvprimkey' the field names are 'suppidcode' 'purinvdate' 'purinvrefnum' 'purinvdesc' 'purinvcostnet' 'purinvcostvat' 'purinvamountpaid' and 'purinvpayinginnow' The two other...

Thanks for your reply LittleSmudge I have tried the code you suggested and can't get it to work, being new to access it is probably me, could you please give me a more detailed explanation as to the code I should write and where it should be placed. Thanks again MRU

I have a form with a subform which lists invoices, the majoriy of fields in the subform are locked, the only field which is not locked is the 'payingnow' field, because sometimes this form may contain 100 + invoices and thus alocating group payments can sometimes require a few attempts to get...

Thanks dz for your reply, I got the autofillnewrecord to copy the previous lines number into the current line and then used the first code you suggested in the field before the invoicenumber field to increase the amount by one. Thanks again MRU

I have a data entry form for entering invoices, I have the 'autofillnewrecord' module working correctly on the form for the account name and date fields. Is it possible to use this module or what syntax would I need in order to take the invoice number from the previous line increase the number...