Recent content by scottappleford

  1. S

    Make a record of a excel cell

    Thanks for your help i will have a play about and see how i get on
  2. S

    Make a record of a excel cell

    Hi sorry to be pain - can anyone help me with this one please appreciate your help
  3. S

    Make a record of a excel cell

    hi yes this is correct please it copies the content of M3 (this is calculating based on a fomula) and copies it to column P is fine and keep a history - so copies to next available cell in column P - can start at Cell P1 many Thanks
  4. S

    Make a record of a excel cell

    Hi I have a formula constantly calculating in Cell M3 I would like to make a record of this every 30 seconds in column P Thanks
  5. S

    copying code

    Hi again i have selected view code, selected worksheet from the drop down but what event do i need from the right drop down. thanks scott
  6. S

    copying code

    Hi thanks the help one of the cells in the row is a date the acct closed and i just wanted the account closed sheet to be sorted by date - if that makes sense? thanks again
  7. S

    copying code

    Hi if you can help i would be really grateful I have worksheet with 6 columns for each row of information. If I type say the number 3 in the status column, then the row of information should transfer to a separate 'closed account' worksheet, and automatically filter by date. There are formulas...
  8. S

    IF Function

    Hi I was wondering if anyone could help. I am trying to write a formula and not sure whether the IF function is the correct one. I would like the following: If say cell A1 has a range of -10 to 10 then Cell A2 will return a 0, if it is between 10 and 15 retrun a 1 and if over 15 then return...
  9. S

    Vlookup help

    Hi I would like some help with the Vlookup function and I will try to explain as best I can. I have sheet that lists company names in one column and then costs in another column. e.g company 1 - 1200 company 2 - 1300 company 1 - 1000 company 4 - 300 company 1 - 600 etc On another summary...
  10. S

    more than one if statement

    Hi I would like to specify more than one criteria of an if statement. e.g, if = ? then ? but i would like to add more critreria as i have more than one selection in my combo box. Thanks in advance
  11. S

    Refreshing form - please help

    me.refresh on the form using the on activate event. that little bit of code took me all day to work out - sometimes things seem so hard and it is as simple as that. i was opening form, moving focus, requerying, closing forms etc etc. thanks
  12. S

    Refreshing form - please help

    Thanks that works for a control on the main form as i refrsh the form and the new employee shows in the combox box. but i can not get the subform to refresh. also if the Purchase order form is not open when the employee form closes it causes an error. e.g. someone might want to see a list of...
  13. S

    Refreshing form - please help

    Hi I double click a combo box which takes me to a new form. e.g. a purchase order form does not have an employee so they need to be added. When the employee form is closed i would like to refresh to combo box so the new employee appears in the combo box. Please help Thank you
  14. S

    Passing criteria to a query

    Hi I have recently started using queries to base my forms on. Even for basic forms i am using the query as the record source. If for example i have a standard query with no criteria e.g. a employee form. How would i then use that query to create a report that filters for example a list of...
  15. S

    forms based on a query

    Thanks for that clarification - as always after asking people on here - it all seems clear. Onwards to the next step in my access development - this is fun! All the best
Top Bottom