User Profile

Forest14 · Dec 27 '06, 07:26 AM

Yes, that's exactly what I'm looking for!

Forest14 · Dec 26 '06, 01:10 PM

I mean Field description which is displayed in the status bar when this field is selected. Sorry for misunderstandin g.

I was thinking about another mean of getting to the point:
for example: a text popup showing when hovering over the field on table or form view.

thanks!!!

Forest14 · Dec 26 '06, 10:34 AM

Table "positions" is made of 160 fields but there are no field definitions
I am looking to add automatically the definitions of these fields by importing them from table "defintions "
Table definitions includes the following fields:
"Field" which actually matches the "positions" table fields names.
and "definition "

THank you

Forest14 · Dec 20 '06, 05:30 PM

thank you guys for this great "cursus"
I feel like a genius at VB now :)

Forest14 · Dec 17 '06, 01:16 AM

Thanks for help.
Now you can enjoy the week-end.
Here is the code I used to requery the dropdown list of a combo while typing:

Code:

Private Sub Setnamecbo()
    Dim strcboSQL As String
    Dim strWhere As String
    Dim itemVal As Variant
    Dim accListcbo() As Variant
    Dim lngLen As Long
    Dim msg As String
    
   
    strcboSQL = ""
[namecombo].SetFocus

...

Forest14 · Dec 15 '06, 10:59 PM

Hello guys,
thank you for your posts, were really helpful.

Here is the code I could get to work:

Code:

Private Sub SetSQL()
    Dim strSQL As String
    Dim strWhere As String
    Dim itemVal As Variant
    Dim accList() As Variant
    Dim count As Integer
    Dim lngLen As Long
    Dim messqge As String
    
    strSQL = ""

...

Forest14 · Dec 12 '06, 10:01 PM

I don't get your first question, do you mean how do i get the info on the main form?
If your question is related to the SQL needed to update the subform, it is definitely part of my request!

The individual options names in the option group are:
-option1account
-option2allaccou nts

thanks a lot !...

User Profile

Profile Sidebar

Leave a comment:

Leave a comment:

Leave a comment:

Import table Fields definitions from another table

Leave a comment:

Leave a comment:

VBA SQL Where statement syntax

Leave a comment:

Leave a comment:

query from Form to Subform