Search results

assuming that you are using a query as the recordset with a join on the tables then try setting the forms Recordset Type to Dynaset(inconsistent updates). This will work in some situations.

A further option is to create a hyperlink address on a label, button or in code and follow the hyperlink.

I am not 100%, infact not 50% and may even be giving you total rubbish. I have seen suffixes c,f,d and r and suspect that they may relate to objects and controls, i.e. f = form recordsource, c = controlsource on a form control, r = report recordsource and d = controlsource on a report control...

use the previouscontrol property. There are examples in Access Help.

You can set a hyperlink path to the document.

try Dim myCriteria as string myCriteria = "[Id] = " & me![Id] docmd.openreport "myReport",,,myCriteria

try using selStart and selLength in the OnEnter event of the control, e.g. me![myControl].setStart = me![myControl].selLength

Create an unbound control in the report header. In the header On Format event place your code to process your variable, e.g. If variable = whatever myUnboundControl = "Whatever" else etc.

Yes. Look at help on the Fields collection.

Infact see Common Dialog posting by andm below.

Use the Active X common dialog control. Comdlg32.ocx

Try something like Public Function rstInpt(fldName as string)as Variant your code here to get data etc. rstInpt = whatEverData End Function your call to the function would be x = rstInpt

On your second Form set the default value of the required fields pointing at the associated fields on the first Form. e.g. =Forms![Form1]![myFirstField] =Forms![Form1]![mySecondField]

It may be that you have a missing reference library. Check that Microsoft DAO 3.6 Object Library is ticked. Hope this helps

From Tools on the menu bar select Startup and complete the Application Icon file path to a bitmap or icon file, e.g. C:\myFolder\myIcon.bmp

If you only want to open the document then set a hyperlink to it using a label or button.

if you do you mean a carriage return then chr(13) & chr(10) e.g. msg = "Line one of message" & chr(13) & chr(10) & "Line two of mesage"

There is a function FileDateTime that will acheive this for you.

It may be worth checking that the version number of the comdlg32.ocx on each machine is the same. I have had the same problem in the past. I cannot be 100% sure but I think I just deleted the control from the form and then setup a new control naming it the same etc. Hope this helps

In the last control of the first subform using the onExitEvent type me.parent![QLV].setfocus in the last control of the second subform using the onExitEvent type me.parent![X].setfocus where X is the name of the first control on your main form.