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

Feb 21 '07 #1

Rabbit

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

Feb 21 '07 #2

JAMBAI

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

Expand|Select|Wrap|Line Numbers

1. "'"

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

Feb 21 '07 #3

Rabbit

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

Feb 21 '07 #4

JAMBAI

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

DoCmd.GoToRecord , , acNewRec

Thanks

Feb 21 '07 #5

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.

Feb 21 '07 #6

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.

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

Feb 21 '07 #7

Rabbit

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

Feb 21 '07 #8

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

Feb 22 '07 #9