Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: mru
  • Order by date
  1. mru

    Add mulitple records to continuous form

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

    Total by date

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

    Total by date

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

    Total by date

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

    Calculation problem

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

    Calculation problem

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

    Calculation problem

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

    Calculation problem

    Has anyone got any suggetsions ?
  9. mru

    Calculation problem

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

    Calculation problem

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

    Calculation problem

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

    Calculation problem

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

    Auto fill date

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

    Auto fill date

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

    Auto fill date

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

    selecting one field

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

    selecting one field

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

    selecting one field

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

    Previous row + 1

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

    Previous row + 1

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

Part and Inventory Search

Back
Top