Sur62
Posts: 22
|
| Posted: 03/12/2008, 9:34 PM |
|
How to store the userid and current data and time in Access database. In CCS Form i could bring this in the textbox but while saving in database the default values like CCGetuserid, date(), time() are not getting stored in database.
Can anybody help on this please.
|
 |
 |
wkempees
|
| Posted: 03/13/2008, 7:51 AM |
|
Quick answer:
Switch on the Custom Insert in the Properties of the form.
Just open the page and select the Form, now in it's Properties Set Custom
Insert Type to TABLE
Next press the [...] elipses for Custom Insert it will present a dialogue in
which you can
assign data to table fields, press the '+' to add the rules you like.
Walter
"Sur62" <Sur62@forum.codecharge> schreef in bericht
news:647d8aec2c1004@news.codecharge.com...
> How to store the userid and current data and time in Access database. In
> CCS
> Form i could bring this in the textbox but while saving in database the
> default
> values like CCGetuserid, date(), time() are not getting stored in
> database.
>
> Can anybody help on this please.
> ---------------------------------------
> Sent from YesSoftware forum
> http://forums.yessoftware.com/
>
|
|
|
|
csierra
Posts: 123
|
| Posted: 03/13/2008, 4:27 PM |
|
Dim SQL
Dim oConn
SQL = "INSERT INTO tbTableName (FieldName1, FieldName2) VALUES ('Value1', 'Value2')
Set oCon = New clsDB(Your Codecharge Connection Name)
oCon.Open
oCon.Connection.Execute SQL
oCon.Close
Set oCon = Nothing
_________________
Yes! I Can!!! |
|
|
|
wkempees
|
| Posted: 03/14/2008, 2:13 AM |
|
One more try, as it is hard to read and write the exact problem/solution:
In your first post you said that you
Quote :
i could bring this in the textbox
Did you do that?
Meaning if the form displays do you have (hidden or not) the UserID, date
and time
assigned to 3 textboxes?
Then my post is still valid, go to custom insert and in the list add your
database fields UserID date and time filling the correct one with each
textbox type Form.
"Sur62" <Sur62@forum.codecharge> schreef in bericht
news:647da4869c7bd6@news.codecharge.com...
> Thanks for your reply. wkempees i tried your steps but then also the
> Userid and
> Date and Time is not getting updated into table. Shopuld i change the
> parameter
> for these because we have given values in default value field i Forms.
> Since am
> newbies i donot know how to code it.
>
> Can you please help on this please.
> ---------------------------------------
> Sent from YesSoftware forum
> http://forums.yessoftware.com/
>
|
|
|
|
Sur62
Posts: 22
|
| Posted: 03/14/2008, 2:42 AM |
|
Thanks for your reply. wkempees i tried your steps but then also the Userid and Date and Time is not getting updated into table. Shopuld i change the parameter for these because we have given values in default value field i Forms. Since am newbies i donot know how to code it.
Can you please help on this please.
|
|
|
|
Sur62
Posts: 22
|
| Posted: 03/14/2008, 8:33 AM |
|
Thanks wkempees its working fine now. I had checked the hidden field after removing it its working fine.
Thanks for your help.Is there any good example for dependent listbox? Can you give me the link? I downloded the example from support.yesoftware but it says corrupted files.
|
|
|
|
