insomnai
01-11-2009, 06:59 AM
To clarify a point before we begin, I don't want you to do this for me, but rather point out where I might learn to do this myself...
I'm new to the forums, and as much as I am searching, each answer is having me ask twice as many questions. If there is a link, or reference somewhere else that provides the answer i'm looking for, then that would be fantastic, but some insight would be a great start if you can help...
I have a particular requirement and what i'm wanting to do is use a form to add the following rather than input directly into a spreadsheet...
A1 = ID number i.e. 1, 2, 3 // automatic on new record being added
B1 = Timestamp // automatic as above
C1 = Name of caller
D1 = Address
button which adds current record to the customer list and start a new record
Ok, here is the more difficult bit, I need to see a filtered set of rows (records) in the form (a subform? is this right?) that allows me to select any record that has been added already and update them accordingly. I'll be eventually looking into colouring the backgrounds of the row depending on it's current activity...
E1 = Current Timestamp // on a button click, i.e. when a call is responded to..
F1 = Current Timestamp // on a button click, i.e. when a call is complete..
With these two record additions / edits above, I'll be refering to two more buttons to change it's status....
Reading all this, I realise that this may be a tall order and I might not get all the answers i'm looking for. To be honest, i would love to know how to do all this myself so links would of course be preferred.
I'm looking at the vbax userformexample form that I got hold of from a link I was given. This gives me a little look into how things are done. I just don't understand how to adapt it to my needs.
Many many thanks for giving this some attention and I hope to hear from you soon.
All the best
Insomnai
I'm new to the forums, and as much as I am searching, each answer is having me ask twice as many questions. If there is a link, or reference somewhere else that provides the answer i'm looking for, then that would be fantastic, but some insight would be a great start if you can help...
I have a particular requirement and what i'm wanting to do is use a form to add the following rather than input directly into a spreadsheet...
A1 = ID number i.e. 1, 2, 3 // automatic on new record being added
B1 = Timestamp // automatic as above
C1 = Name of caller
D1 = Address
button which adds current record to the customer list and start a new record
Ok, here is the more difficult bit, I need to see a filtered set of rows (records) in the form (a subform? is this right?) that allows me to select any record that has been added already and update them accordingly. I'll be eventually looking into colouring the backgrounds of the row depending on it's current activity...
E1 = Current Timestamp // on a button click, i.e. when a call is responded to..
F1 = Current Timestamp // on a button click, i.e. when a call is complete..
With these two record additions / edits above, I'll be refering to two more buttons to change it's status....
Reading all this, I realise that this may be a tall order and I might not get all the answers i'm looking for. To be honest, i would love to know how to do all this myself so links would of course be preferred.
I'm looking at the vbax userformexample form that I got hold of from a link I was given. This gives me a little look into how things are done. I just don't understand how to adapt it to my needs.
Many many thanks for giving this some attention and I hope to hear from you soon.
All the best
Insomnai