=[currentproject].[Path] & "\" & [M1]
I've attached a zip file which has a folder with a database and images that demonstrates how images could be displayed. If you look at the form in design view you will see that it is a continuous form with five image controls and five textboxes which are bound to the table. The control source of the image control are of the form
Code:=[currentproject].[Path] & "\" & [M1]
where in this example the images gets the file name from the textbox name M1 and it is prefixed by the folder of the database by [currentproject].[Path].
So this just shows that they can be displayed but I hope you can see that the table structure is far from being in normal form. So if you do it this way and want to have your data in normal form (you should) I think you will have to create a table like this from your normalized data when the form is loaded.
but this file is not automatic , i have to make each item .
i want the grid to be generated automatically, like continuous form but virtually and horizontally
i appreciate your caring
Public Const grdform As String = "form1"
Public Const cols As Byte = 6
Public frmgrd(cols) As Form
Private Type rect
l As Long
t As Long
h As Long
w As Long
End Type
Private r As rect
Public Function GenGrd()
Dim f As Form, i As Byte
For i = 0 To cols
Set frmgrd(i) = Nothing
Next
DoCmd.OpenForm grdform
DoCmd.Maximize
Set frmgrd(0) = Forms(grdform)
r.w = frmgrd(0).WindowWidth / cols
r.h = frmgrd(0).WindowHeight / 2
DoCmd.Restore
For i = 0 To cols
If frmgrd(i) Is Nothing Then Set frmgrd(i) = New Form_Form1
frmfmt frmgrd(i), r.w * i, 0, r.w, r.h
Next
End Function
Private Sub frmfmt(f As Form, l As Long, t As Long, w As Long, h As Long)
f.Move l, t, w, h
f.ControlBox = True
f.ScrollBars = 0
f.RecordSelectors = False
f.NavigationButtons = False
f.Visible = True
'f.BorderStyle = 0 'design view only
End Sub
this is my data baseI didn't understand the third sentence.
Creating the layout is only part of the problem.
Do you want to interact with it somehow? If not, what is the point of it? If you do want to interact with it, how you want to interact with it could influence whether or not a particular solution is viable.
If you want somebody to code it for you'd need to provide your database.