Search results

yeap! that's what i thought would be the answer.... Thanks a lot :)

the thing is that each checkbox should have a diffrent value and at the end i should get the sum all of this values... Thanks for trying to help me :)

I want to get the sum of checked checkboxes. How can i add values to these checkboxes in order to get the sum of them? I tried to set the default value of the combo boxes to a number, and then to add them but i can't get a sum value. Any suggestions? Thank you in advance!

That works just fine! Thank you for helping me:)

I have a combo box that is based on another combo box (with a query). When i make a choice in combo1 i get the appropriate value on combo2 but when i change the combo1 value i don't get the changes on combo2. For example i have combo1 with values value1,value2 and on combo2 i have for combo1...

i used the windows login name and works. Thanks a lot guyz:)

but how you recognize which user is each time?

Here what i did. I defined a global variable Username to form1. When i assign this variable to form2 i can't get the value. I assign the value to form2 as follows: me!textfield=Username What do i do wrong? Thank you in advance.

Where should i define a global variable in order to be accesible from all forms?

Hide Menus: Dim i As Integer For i = 1 To CommandBars.Count CommandBars(i).Enabled = False Next i Unhide Menus: Dim i As Integer For i = 1 To CommandBars.Count CommandBars(i).Enabled = True Next i I hope that helps :)

docmd.open <main_menu> what do you mean by this line? When i say main menu i mean a toolbar menu, not a form. Is it possible to activate a toolbar through a form?

I' ve created an access appliaction and i want when user run the application to see only the username/password form (with no menus,toolbars,etc). After he inserts the correct username/password,he will be able to see the menus. If he inserts the wrong username/password he will get an error...

I have a table named "Currencies" with CurCode and CurrDescription fields and a table named "Exchange" with From ( it takes the value of CurrCode), To (takes the value of CurrCode,in my case this is always set to EURO) and Rate Fields. In a form with record source the table "Sales" I have a...

That works. Thanks :)

I have Table Products and Table Types. I've created another one ProductTypeRef where i save the references. For example: Products Id Description 1 Shoes 2 Clothes 3 Hats Types Id Description 1 Athletic 2 T-Shirts 3 Trousers ProductTypeRef IdProducts...

I have a field in a form and i need to fill this field with a query value. I created the query and i added it at Field properties ->Defaul Value as follows: [qrySUMApprovedArea]![SumOfApprovedArea] but i get no values at the field. If i set Form Recordsource to the query then i get a...

I found what the problem was. I didn't assign at form2.idno the form1.idno and that's why i couldn't get the right results. Thank you so much for your help :)

form2 is based on table2 and table2 has IdNo as a field. Table1 has idNo as well and is linked to table2 with one-to-many relationship. form1 is based on table1. i hope that helps...

yes the IdNo it's numeric. At form2 i get all the records of table2 without considering the IdNo as a filter.

this is the code...but i can't make it work... is there anything else i must do at form2? Private Sub cmdEnterFields_Click() Dim stDocName As String Dim stLinkCriteria As String stDocName = "form2" stLinkCriteria = "[IdNo]=" & Me![IdNo] DoCmd.OpenForm stDocName, , ...