Search:

There is no need to be sarcastic. I usually do mark my threads as resolved when i get solutions to my posts.

That's right..conn

Error 3709:The connection cannot be used to perform this operation. It is either closed or invalid in this context.
is experienced in:


Set MyRSSave1 = New ADODB.Recordset
sSQL =...

In fact I now have a SYNTAX error in the long sql :

sSQL = "UPDATE tblClients SET " & _
"ClientCode = '" & Me.ClientCode & "', ClientType = '" & Me.ClientTypeText & "'," & _
...

Sorry I previously posted about recordset because it wasnt working neither.

But now, it is kinda working..
The changes i make on my form are being saved - except for a few times, only...

Option Compare Database
Public conn As ADODB.Connection
Public MyRSProject As ADODB.Recordset

Private Sub imgSave_Click()
'insert the new details in the table tblTeam
Dim answer As...

Phone number is Text type in table.
It is entered in a textbox on the form.

Can an input mask for a phone number cause a data type error on updating with an SQL statement?

What is being passed is:

UPDATE tblProject SET ClientCode = '1625', ProjectDescription = 'Auditor Nomination to be reviewed', StartedOn = '15/01/2007', EndDate = '05/03/2007', Department =...

Like this ?


sSQL = "UPDATE tblProject" & _
" SET ClientCode = '" & Me.ClientCode & "'," & _
" ProjectDescription = '" & Me.ProjectDescription &...

I now have the error
No value given for one or more required parameters.
with


sSQL = "UPDATE tblProject" & _
" SET ClientCode = '" & Me.ClientCode & "'," & _
...

Hi, i've been (and am) having a tough time changing use of recordset to use of sql stts. E.g, the code below won't save the changes on the form textboxes in the table (but doesnt give any error)...

Yes of course, no need to check eof on inserting.
Insert was one issue.

Now, I wanted to know how u advise me to check EOF or access spacific fields for situations in my code where i am using...

jsc0624

How did u go about the migration to SQL server?
Would u be able to keep us (me) informed of the steps u undertake and the solution to this? ->since it is quite probable that I would need...

In situations where I am using an sql stt for example:

1. Check EOF

'check whether the user is adding a new staff or modifying
sSQL = "SELECT tblStaff.* FROM tblStaff WHERE...

The .Text part usually gives me an error that the control is not in focus and that i can't access it - that's y i was preferring not to use it.

if
MyRSSave1.Open sSQL, conn
should be replaced...

Hello all,
I have a strange error in an SQL statement saying that "Method or Data member not found" with one of the textboxes from which I am reading the value, despite that I have correctly typed...

Thank you all or your posts.

I am making the changes you sugested me. I am trying to avoid .Find, but i have error 3705 Operation not allowed when object is open with my line:


'do the save
...

The solution to the first issue seems to be the use of variables?

Why is everyone against the use of recordset methods? :)
In fact, it facilitates the task as concerned for me coz i'm lazy about...

RhinoBull thanks
The issue seems to be resolved when the line is simply removed.

1. This is quite puzzling and very annoying when having data validation codes not working as expected.
For example, i have a validation for checking whether either of Work OR Mobile phone was...

I did not check your lines of code. But you should be chekcing whether the user is adding or modifying exising record by finding whether the primary key on your form already exists in the table.
If...

Hello,
I'm getting error 3219 Operation is not allowed in this context. when close a recordset in my code (at the orange line)
I have never had this error before and can't resolve it. Here follows...

:D It's working correctly now -thanks

Set conn = CurrentProject.Connection
Set MyRSJunior = New ADODB.Recordset
'open the recordset.
MyRSJunior.Open "tblTeamBuilder", conn, adOpenDynamic,...

Thanks, it's working as expected

Hi all

I'm looking to declare a variable with which I would be able to pass value between forms (like a parameter)
I don't know if it should be declared public or global (it this exists in ms...

That's right i didn't set the recordset...................

Thanks.

Sorry, didnt post. i've declared:
Option Compare Database
Option Explicit
Dim strSQL1 As String
Dim strSQL2 As String
Dim conn As ADODB.Connection
Dim MyRSClient As ADODB.Recordset
Dim...

Hello I'm having error Object variable or With block variable not set (Error 91) at line in bold. myRSClient is supposed to simply search the corresponding clientname in tblClients for the clientcode...

headsbout2burst
I have a similar feature in one of my access applics. I got it from a website somewhere i dont remember. It uses a module for poping-up the calendar. It works with the on_click event...

Hi
Does anyone have good references of websites where I can get tutorials/examples about exporting and interpreting data from ms access to MS Excel?

Many thanks.

Hi ppl,
Working in ms access, i have tables storing details of assignments and people who are assigned for these jobs.

What i want to do now is to be able to export these data to an Excel sheet...

Now using unbound controls and sql statements/ADO commands.
Resolved

Can anyone help me correct syntax error(s) in the following code:



Runtime error : Syntax error in FROM clause.

Thank u

Hello
Yes the var is declared as public. I am trying to avoid referring to the var in the query and placing an SQL stt in code. Can anyone correct syntax error in the SQL:
strSQL = "SELECT...

I had indeed not opened conn.

Well now it's indicating to me that qrySearchClient
SELECT tblClients.ClientCode, tblClients.*, tblClients.ClientCode
FROM tblClients
WHERE...

OK I am trying the 'unbound' way.....

So, trying to display the last record contained in the table tblClient on event Form_Load, I get error 3709: The connection cannot be used to perform this...

Hi all

I have designed my forms based on queries so that i am able to make a search and display the result on my form.

However, initially my forms are meant for adding and modifying records....

Al42, I have deleted all records in my tables with which i have been testing the applic. I shall check if the problem still arises when i will input fresh data and will get back to you? Thanks so much