I am new to access,I have design an employee form & some tables.Kindly let me know how can i add records from form to database,I am not able to write anything in the text box,in the emloyee form I have taken fields from multiple tables.I'm also trying to insert a picture into a form in the exact same way that the Northwind sample database does in the Employees form.I'm getting an error that
runtime error 2135
this property is read only and can not be set
This error points to the following subroutine and
highlights Me![ImagePath].Text = fileName
' Displays the Office File Open dialog to choose a file
' for the current employee record. If the user selects a
' display it in the image control.
Dim fileName As String
Dim result As Integer
.Title = "Select Picture"
.Filters.Add "All Files", "*.*"
.Filters.Add "Bitmaps", "*.bmp"
.Filters.Add "JPEGs", "*.jpg"
.FilterIndex = 3
.AllowMultiSelect = False
.InitialFileName = CurrentProject.path
result = .Show
If (result 0) Then
fileName = Trim(.SelectedItems.Item(1))
Me![ImagePath].Visible = True
Me![ImagePath].Text = fileName
Me![ImagePath].Visible = False
I'm hoping that someone help me .Thanx in advance.