Barry Stear
bstear at gmail.com
Fri Apr 8 12:26:51 CDT 2005
I copied the EVENT for inserting an picture from the Sample Database that comes with Access 2003 (NorthWind Sample Database) . However when I try to click on the button to insert an picture it errors out in the code at Sub getFileName(). It says that its not defined. It highlights in blue msoFileDialogFilePicker and has an Yellow Arrow next to Sub getFileName(). Here is the procedure. Sub getFileName() ' Displays the Office File Open dialog to choose a file name ' for the current employee record. If the user selects a file ' display it in the image control. Dim fileName As String Dim result As Integer With Application.FileDialog(msoFileDialogFilePicker) .Title = "Select Employee Picture" .Filters.Add "All Files", "*.*" .Filters.Add "JPEGs", "*.jpg" .Filters.Add "Bitmaps", "*.bmp" .FilterIndex = 3 .AllowMultiSelect = False .InitialFileName = CurrentProject.path result = .Show If (result <> 0) Then fileName = Trim(.SelectedItems.Item(1)) Me![ImagePath].Visible = True Me![ImagePath].SetFocus Me![ImagePath].Text = fileName Me![FirstName].SetFocus Me![ImagePath].Visible = False End If End With End Sub Anyone help me with this code or perhaps something else I can use. I want to be able to put an picture in my Inventory list. I know I can embed it but its nice to be able to do it from within an form with an button. Barry