|
-
Apr 11th, 2007, 01:51 AM
#1
Thread Starter
Lively Member
Access Database Error!!!!!
Hii Evrey body
i Have A probleme in my database ,when i click in add button and write the information (in textbox's) without minimized my app form it's work and save it to the database, but when i minimized my form to copying and paste it to textbox's it's not work and don't save it, i guess it's probleme of timeout but i put this code in my form_load.
----------------------------------
Adodc1.ConnectionTimeout = 0
Adodc1.CommandTimeout = 0
----------------------------------
so it's not work , please corecct this code to me or give me a solution
Thnk's
Milen
-
Apr 11th, 2007, 02:19 AM
#2
Re: Access Database Error!!!!!
So when you add the data in the text boxes and save it (uh when?) it works, but if you minimise your form, to copy data then paste it into your form text boxes the record is not saved or a blank record is saved?
Or do you put the data in the text boxes but then it doesn't save?
You probably need to send a .update or .save method on your data controls.
Good luck
Feeling like a fly on the inside of a closed window (Thunk!)
If I post a lot, it is because I am bored at work! ;D Or stuck...
* Anything I post can be only my opinion. Advice etc is up to you to persue...
-
Apr 11th, 2007, 04:11 AM
#3
Re: Access Database Error!!!!!
could you post your code for saving the record, so that we can analyse and help you better...
If an answer to your question has been helpful, then please, Rate it!
Have done Projects in Access and Member management systems using BioMetric devices, Smart cards and BarCodes.
-
Apr 11th, 2007, 04:18 AM
#4
Member
Re: Access Database Error!!!!!
yes what ganeshmoorthy is saying right.. u please post the code
-
Apr 11th, 2007, 04:38 AM
#5
Re: Access Database Error!!!!!
Did you try a reasonable Timeout period like 5 seconds instead of expecting instant data transfer?
 why can't programmers keep and 31 Oct and 25 dec apart. Why Rating is Useful
for every question you ask provide an answer on another thread.
-
Apr 11th, 2007, 11:46 AM
#6
Thread Starter
Lively Member
Re: Access Database Error!!!!!
Sorry, For my late i was studing in the university
This is my save code guys
-----------------------------------------------------
If MsgBoxEx2.Result = mbYes Then
Adodc1.Recordset.Update
Adodc1.Refresh
ARButton10.Enabled = False
ARButton7.Enabled = False
ARButton9.Enabled = True
ARButton5.Enabled = True
ARButton8.Enabled = True
c(2).Caption = Adodc1.Recordset.RecordCount
MsgBoxEx3.Show
Call Command3_Click
End If
------------------------------------------------
-
Apr 12th, 2007, 01:43 AM
#7
Thread Starter
Lively Member
Re: Access Database Error!!!!!
Is there any answer guy's PLz
-
Apr 12th, 2007, 01:47 AM
#8
Re: Access Database Error!!!!!
where are you assigning values to the recordset...are they bound controls..
If an answer to your question has been helpful, then please, Rate it!
Have done Projects in Access and Member management systems using BioMetric devices, Smart cards and BarCodes.
-
Apr 12th, 2007, 01:54 AM
#9
Thread Starter
Lively Member
Re: Access Database Error!!!!!
No Bound controls, i set automateclly option of saving
-
Apr 12th, 2007, 05:26 AM
#10
Re: Access Database Error!!!!!
Adodc1 suggests a bound control
Feeling like a fly on the inside of a closed window (Thunk!)
If I post a lot, it is because I am bored at work! ;D Or stuck...
* Anything I post can be only my opinion. Advice etc is up to you to persue...
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|