D-Function help

[Guest]

Using Office 2003 and Windows XP;

1) Is there an opposite function to DLOOKUP in the sense of writing a value
to a single field rather than returning its contents?

2) Where in the Help can I find a full listing of all the available "D"
functions?

Thanks in advance.

 

[Michel Walsh]

1- DoCmd.RunSQL "UPDATE tableName SET
fieldName=FORMS!formNameHere!NameOfControlWithTheValueHere WHERE
primaryKeyField=FORMS!formNameHere!NameOfControlWithTheValueOfThePrimnaryKey"


to update a (one) given (through its primary key) existing record,


DoCmd.RunSQL "INSERT INTO tableName(NameOfTheField) VALUES(
FORMS!formNameHere!ControlNameHere ) "

to append a new record.




Hoping it may help,
Vanderghast, Access MVP

 

[Marshall Barton]

Using Office 2003 and Windows XP;

1) Is there an opposite function to DLOOKUP in the sense of writing a value
to a single field rather than returning its contents?

2) Where in the Help can I find a full listing of all the available "D"
functions?

2) All built in functions, objects, methods, properties,
etc, are explained in VBA Help. You can get to the VBE
window by hitting Ctrl+G in the Access window.