Single Quote in DoCmd ?

[JAMBAI]

Hi,

Is there a way to handle single quotes when inserting the records using the below do command. Or do I need to write Insert sql.

DoCmd.GoToRecord , , acNewRec

Thanks
Jambai

[Rabbit]

I'm not quite sure what you're talking about but you can get single quotes by using:

"'"

[JAMBAI]

I'm not quite sure what you're talking about but you can get single quotes by using:

"'"

This will helpful for me only when I insert the records using insert sql statement.

Here I am trying to insert the records using DoCmd.Forms fields are bound to the table.

Thanks

[Rabbit]

What DoCmd function are you trying to use to insert records?

[JAMBAI]

What DoCmd function are you trying to use to insert records?

DoCmd.GoToRecord , , acNewRec

Thanks

[Rabbit]

DoCmd.GoToRecord , , acNewRec

Thanks

This will take you to a new record, it doesn't insert a new record. A new record is inserted only once you have begun to enter information and it is updated to the table. Whatever you type into the text boxes is what will be stored.

[JAMBAI]

This will take you to a new record, it doesn't insert a new record. A new record is inserted only once you have begun to enter information and it is updated to the table. Whatever you type into the text boxes is what will be stored.

The below code was created from the button wizard.

Private Sub Command34_Click()
On Error GoTo Err_Command34_Click
    DoCmd.GoToRecord , , acNewRec
Exit_Command34_Click:
    Exit Sub
Err_Command34_Click:
    MsgBox Err.Description
    Resume Exit_Command34_Click
End Sub

I need to check for existing record before the record is inserted into the table, I am solved the problem with single quote check,

Thanks
Jambai

[Rabbit]

How do you determine if a record exists? Is there a primary key?

[MMcCarthy]

The below code was created from the button wizard.

Private Sub Command34_Click()
On Error GoTo Err_Command34_Click
DoCmd.GoToRecord , , acNewRec
Exit_Command34_Click:
Exit Sub
Err_Command34_Click:
MsgBox Err.Description
Resume Exit_Command34_Click
End Sub

All this code does is to move the form to the add new record postition. You must have clicked on the wrong option in the wizard.

I need to check for existing record before the record is inserted into the table, I am solved the problem with single quote check,

Sorry Jambai you will have to explain this better as it doesn't make sense to us.

Mary