Thanks for the reply.
I didn't make myself clear.
I want to do this in code not thru the dialogue box.
If this is what you are suggesting then I do not understand what you mean so would appreciate expansion
I would like to set the value of the "Replace text as you type" tick box in the Tools>AutoCorrect dialogue box.
Can't seem to find a property to do this.
Would appreciate any feedbacl/solution from anyone
Thanks
I want to be able to view an external object on my form. For example, a WORD or WordPerfect document or Excel sheet
Any suggestions would be more than appreciated.
Have tried your suggestion as in the following with no success.
Private Function RefreshEmployee(EmployeeID As Long)
On Error GoTo ERROR_HANDLER
Dim stLinkCriteria As String
stLinkCriteria = "SELECT * from Employee WHERE [Employee id]= " & EmployeeID & ";"
' the following...
I have since found that the CuurentRecord becomes available in the On_Current event. I still have concerns as to why in some instances currentrecord is set to 1 when no record is selected with the form.
Loading a form with an empty dataset seems to have a setting of 0.
More info later
When a form is opened and the object recordset contains no records, a new record instance is created. It becomes real as soon as a field is initialized either thru a default value defined in the table or direct setting.
As a result blank records can be left in a table in the event of Exitting...
I open a form with a criteria which selects a record.
When in this form I want to change the current record
Is there a way of changing the record without closing the form and reopening. e.g
In form then
strlinkcriteria = NewEmployee
Docmd.close
Docmd.open "Employee", , ...
I have not tried what you are doing however we have integrated Groupwise Mail and tasks into our recruitment system without any problems. A bit of a pain but if you want the code for this please e-mail me at
andy@mtechnologies.co.uk and I will happily send you the VB module that you can...
Drew
If you wish to send me (andy@mtechnologies.co.uk) your e-mail address I will return you some code which will allow you to do exactly what you want.
Andy
We have a multi-user database, where users are encountering Error 3167.
After acknowledging the error the system continues as expected.
No delete facility is available to the users.
The error is occurring when a search is done OR a save and even the print option is taken.
There are NO deleted...
On a continuous form, if you select a field in an given row, is there a way you can set the backcolour of that row to a different colour than the other rows.<br>
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.