Access Pages

[blindlemonray]

Does anyone know if you can use controls on Pages like you can on Forms? i.e.

If Me.functions = "no" Then
Me.Text.SetFocus.... blah blah

Thanks in advance

 

[fneily]

Yes.
Since your question is rather vague with a specific, I'll supply my own example. Let's say you have a textbox for the user to type in an Id or password. In design view, you would right click the textbox, select Microsoft Script Editor. On the left of the screen, under Script Outline, you'd scroll down to the textbox name and double click on it. You'll see some events. You would then double click on "onchange" and type in some code such as:

Set rs = CreateObject("ADODB.Recordset")
sqlSelect = _
"SELECT * FROM LogonInfo WHERE EmployID = '" & EmployeeID.value & "'"
rs.Open sqlSelect, MSODSC.Connection
If rs.EOF Then
EmployeeID.value = "(Access Denied)"
Else
holdID = document.all.item("EmployeeID").value
EmployeeID.value = "(You May Edit)"
Hyperlink0.style.visibility = "visible"
If holdID = "Whatever" then
Hyperlink1.style.visibility = "visible"
Hyperlink2.style.visibility = "visible"
txtStart.style.visibility = "visible"
txtEnd.style.visibility = "visible"
Text0_Label.style.visibility = "visible"
Text1_Label.style.visibility = "visible"
End if
End If
rs.Close
Set rs = Nothing

You code DAP's using VBScript, not what you use for forms. Remember, you are not in Access, you are in Internet Explorer.

 

[blindlemonray]

Hi Fneily,

That is fantastic.. thank you . Hopefully it should not be too difficult to sort out.

My first example was something that I needed to do. Moving focus from one control to another depending on what first control is updated to i.e

If Me.dropdownlist = "no" Then
Me.anotherdropdownlist.SetFocus

Is the coding very similar?

Can you recommend any good sites for a bit of self teaching?

 

[fneily]

To set focus on a textbox, using my original post, you would type:
txtStart.select

You can look through these sites for DAP info:

http://www.kayodeok.btinternet.co.uk/favorites/kbofficeaccesshowto.htm

http://msdn.microsoft.com/library/d...hop/author/dhtml/reference/methods/open_0.asp