User Profile

overcomer · Nov 25 '08, 07:34 AM

hi,
you may want to check the record source of your subform. this should be the query name instead of the table name of your source table.

hope this help

regards,

overcomer · Nov 25 '08, 07:28 AM

hi

hi,

you may want to use cascading combo to look up the data you need base on employee id or employee name... here you''ll have to use a combo box.

you can check the concept in the link below.

Cascading Combo/List Boxes - bytes

regards,
cindy

overcomer · Nov 24 '08, 08:27 AM

elow

hi,

calling a function in vba is simple as the name of the function itself..

sub Proc_name()

function_name

end sub

overcomer · Nov 20 '08, 12:17 PM

please specify also where you will get the current user... from a field? from the workstation?

overcomer · Nov 20 '08, 12:00 PM

well if you like set the record source of your form with the name of your table.. by this the form automatically change it size base on the number of row in the record.

overcomer · Nov 19 '08, 09:17 AM

hi matt,

just a suggestion you could use the <combo_name>_af terupdate() event and to get the chosen value in combo box you could use this str_var = <combo_name>.va lue

where <combo_name> is the name of your combo box. Hope this helps.

one more thing... how do you populate the subform??? you said it is through query but how is it displayed in the form???

overcomer · Nov 19 '08, 07:24 AM

Hi,

thanks for the reply... i already have the solutions for both questions... thanks a lot... :)

overcomer · Nov 11 '08, 10:59 AM

you may want to browse the answer of one member here.... i'm also looking on ways to write data from access to excel...

http://bytes.com/forum/thread852979.html...

overcomer · Nov 11 '08, 10:54 AM

thank u so much... ^_^

overcomer · Nov 11 '08, 08:12 AM

please try the logic below:

Code:

If CheckBox.Value = 0 Then
    str_sql = "Delete from table where field1 = " & buro & " and field2 = " & dienst
Else
    If CheckBox = -1 Then
        str_sql = "Insert into table(field1, field2) values(" & buro & ", " & dienst & ")"
    End If
End If

Docmd.RunSQL str_sql

overcomer · Nov 11 '08, 07:36 AM

if <> does not work.. please provide the sql of the query by going to the design of the query... then Go to View > SQL View. there you could find the sql.

:)

overcomer · Nov 11 '08, 07:33 AM

Hi,

please try to use <> as not equal before the 'Criteria'

sample:

<> ProductSold

overcomer · Nov 10 '08, 09:23 AM

actually i would like to mimic the autoform funtionality of ms access to make a flexible form that creates objects at run time. anyhow, i already got the idea and understand how to do it.

thanks for your reply.

overcomer · Nov 10 '08, 08:34 AM

please see if you have just forgot to specify the property of the text you are trying to setup:

to change the caption textbox.caption = "new value"
to change the value textbox.value = "new value"

overcomer · Nov 10 '08, 08:15 AM

Hi,

Can you give us the exact SQL of your query so that we could check if you miss a condition.

Regards,
Cindy

overcomer · Nov 4 '08, 08:35 AM

Thank you so much Fish... it is really a big help...

User Profile

Profile Sidebar

Leave a comment:

Leave a comment:

Leave a comment:

Leave a comment:

Leave a comment:

Leave a comment:

Leave a comment:

Left Padding of "0" in String

Leave a comment:

Leave a comment:

Leave a comment:

any idea about VBA code that open, writes data in EXCEL/WORD file???

Leave a comment:

Leave a comment:

Leave a comment:

Leave a comment:

Leave a comment:

Leave a comment:

How can we create an object (edit box, checkbox) at run time ??

Code behind AutoForm