List of commands/statements/conditions to help build

[james_IT]

Hi All

Is there a full list anywhere of all the DoCmd. or statments or conditions that access uses anywhere? For example, a list of Else statements to be used with IF. Or a list of DoCmd. or a list of what IF can be used to look for/find.

I think it may be useful in answering many questions that people ask on here and would help people build there own code instead of asking others to build it for them.

Thanks

James

 

[namliam]

In the access help??? Quite a few questions on the forum IMHO are from people not wanting to go into the 'hormal' help.
and/or search! Searching on the forum can yield a surprising number of answers, if you use it...

 

[james_IT]

In the access help??? Quite a few questions on the forum IMHO are from people not wanting to go into the 'hormal' help.
and/or search! Searching on the forum can yield a surprising number of answers, if you use it...

Hi namliam

Of course MS Access help can help with certain things but i dont think there is a proper list, like a glossary of these kind of things. Searching the forum can help but it difficult for people to search for something if they dont know what they are searching for. For example if someone doesnt know the IF statement or ELSE statement that is applicable to their circumstance, but reading through a list with an explanation of each one may help?

 

[gemma-the-husky]

in A97 help, you can get a list of the action constants for docmd, with a very brief usage comment. I can never find my way around later versions.

eg in AXP, entering docmd in help index, just seems to take me to "gotopage"! command


---------------------------
i dont understand the "if" query

basically constructs are either

if conditiona then
.. do something
.. do something
end if

or

if conditiona then
.. do something
.. do something
else
.. do something else
end if

generally any statement can be carried out with a if then/end if block. Transferring command to a label outside the block is also permitted, and statement execution then continues sequentially.
if and other statements can be nested inside an if statement, as long as this basic construct is adhered to

 

[namliam]

I would buy a book or do a basic course to get to know the basics...

I mean if someone dont know what an If then else is....

Offcourse using the "right" terms like "cascading combobox" is hard.... but you learn as you go I guess.