Joined
·
1 Posts
Hiya, after some help with access........let me begin!
I'm working as a receptionist, just temping and they don't have any way of logging all calls other than pen and paper! So, me being the genius that I am, have created an Access DB to log calls.......
The plan is then to just email the individual with the phone message.....I've set up a macro to do this....no probs there......
Problem is that there are some fields that the recipient doesn't need to see....so I've created a button that takes you to another table with the unneccessary fields taken out.....then on this table I've got a macro that sends the record to the recipient.....only prob is that it sends all the records....not just the most recent, which is what i want it to do.
Any suggestions? Think i need to filter the records so that only the most recent is shown, however I don't know how to do this
Please help!!!!?
I'm working as a receptionist, just temping and they don't have any way of logging all calls other than pen and paper! So, me being the genius that I am, have created an Access DB to log calls.......
The plan is then to just email the individual with the phone message.....I've set up a macro to do this....no probs there......
Problem is that there are some fields that the recipient doesn't need to see....so I've created a button that takes you to another table with the unneccessary fields taken out.....then on this table I've got a macro that sends the record to the recipient.....only prob is that it sends all the records....not just the most recent, which is what i want it to do.
Any suggestions? Think i need to filter the records so that only the most recent is shown, however I don't know how to do this
Please help!!!!?