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 Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by mru

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

Part and Inventory Search

Back
Top