Question Fourm with excel

[Mahase]

Hi all New Member.
I don’t know how to explain this. please take a look at the attachment
I have a data base created and want to add a field (don’t know what it is called) that looks like excel..
Rows and columns.. Also a1 will carry over same dropdown every entry…
For example
Name date Comments
Under name I will have a dropdown I can pick with names..
What info I type in it will follow the record…
It is possible and if yes how do I go about doing this.

Thanks
M.

 

[ghudson]

I suggest you do this in the form that you setup for the user to access the table data. Bind your field to a combo box or list box in the form.

 

[Mahase]

I suggest you do this in the form that you setup for the user to access the table data. Bind your field to a combo box or list box in the form.

thanks ghudson..

I just can’t get it... is there any way you can write a how to for me... I am an idiot...

i am missing somthing...

 

[Galaxiom]

Unfortunately you are missing the basic understanding of databases.
First thing is to break the Excel thought patterns. Database tables look like spreadsheets but the similarity ends there.

You need an introduction to Access tutorial. There are many online to choose from.

 

[Mahase]

Thanks Guys..
i was able to solve and fix my last problem..

i have on more if you can help or turn on the light like you did.

the code that i am using:

Private Sub Check412_Click()
Me.AP_Line10_AS.Visible = False
Me.AP_Line19_AS.Visible = False
Else
End If
End Sub

All I want is when the check box is checked.. I would like those to fields to be disabled...
It will not work... don't know what I am doing wrong...

 

[Gunilla]

I don't really know what you try to do, but I think this might help you.
this is what you us

Private Sub Check412_Click()
Me.AP_Line10_AS.Visible = False
Me.AP_Line19_AS.Visible = False
Else
End If
End Sub

It looks like you have left something out.
This is how I would write it:

Private Sub Check412_AfterUpdate() (I would make it after update instead of click)
 If me!Check412= True Then
Me!AP_Line10_AS.Visible = False
 Me!AP_Line19_AS.Visible = False
 Else
 End If
 End Sub

Gunilla

 

[vbaInet]

Actually you would also want to make them visible as well and reference properly:

Private Sub Check412_AfterUpdate()
    If me.Check412= True Then
        Me.AP_Line10_AS.Visible = False
        Me.AP_Line19_AS.Visible = False
    Else
        Me.AP_Line10_AS.Visible = True
        Me.AP_Line19_AS.Visible = True
    End If
End Sub

Also needed on the form's On Current event:

Private Sub Form_Current()
    If me!Check412= True Then
        Me.AP_Line10_AS.Visible = False
        Me.AP_Line19_AS.Visible = False
    Else
        Me.AP_Line10_AS.Visible = True
        Me.AP_Line19_AS.Visible = True
    End If
End Sub

 

[Mahase]

Thanks Guys... will take a look and post back...

 

[vbaInet]

No worries. I hope it works out for you.