asimoes
asked on
snapshots
Can I relate a snapshot from a table to a dynaset in another table?
thanks
Alberto
thanks
Alberto
I don'y understand your questionm can you provide more details?
ASKER
As I see it, a snapshot is some information retrieved from a table that cannot be updatable and a dynaset can be updatable.
Well, in the relation of this two tables can i retrieve information of the first one (by a snapshot) for some fields (that I don't want to update) and relate them to the second information of a second table that I must update ?
Another question: How can I format a text box for currency?
Well, in the relation of this two tables can i retrieve information of the first one (by a snapshot) for some fields (that I don't want to update) and relate them to the second information of a second table that I must update ?
Another question: How can I format a text box for currency?
I don't understand what you mean by 'relate'. Are you planning on opening up a 3rd recordset equal to a join of the two tables? Are you going to loop through one table, finding related values in another table? More information would be helpful.
Also -- you probably want to post the text box question seperately.
Also -- you probably want to post the text box question seperately.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Hi asimoes,
Regarding the second question, try this one.
MyStr = Format(5459.4, "$##,##0.00") returns $5,459.00
Also go to keypress event of text box and write code so that it allows only numbers to be keyed in the text box.
Regards,
mskannan
Regarding the second question, try this one.
MyStr = Format(5459.4, "$##,##0.00") returns $5,459.00
Also go to keypress event of text box and write code so that it allows only numbers to be keyed in the text box.
Regards,
mskannan