Search results

thank you man good site

thank you for your time JoanneJomes now I found out the way to dectect subform field DCount("*", "qSumProductCost_subform", "RecipeID =" & [RecipeID]) = 0 thank you

Vista !! u mean window operation ? no I dont use vista I use windowXP I am pretty sure that its exactly the same file Moreover, when I run on a handy drive, it works (on the Admin user). the other hand, if i run database on a handy drive in different users (Not admin) it doesnt work. thanks

I have developed the database in Admin account When I went to present my database in another user (same computer) Some queries that calculate the cost dont work It shoe ###Error the same database I reopened in the Admin account It works I attached the pic of my design view query Need you guys to...

hi thanks for you answer JoanneJomes I will try thanks again =================================================== After I tried it doesnt work If Len(Nz(ProductID, "")) = 0 Or Len(Nz(ProductName, "")) = 0 Or _ Len(Nz(Qauntity, "")) = 0 Or Or...

yes thats what I want thank you man I have got another question. If I would like to put the field in the subform how can i do? cause when i simply put len(nz(Query1.fieldname1,"")) = 0 [Query1 is subform that I put in the main form. It doesnt work the error said variable not defined pls...

thanks for answer However, what are front end and back end ?

Hi guys I create the msgbox to warn the users that the fields to append are not complete the fields to the table My append query has 4 fields ProductID, ProductName, Quantity, Cost The problem is if i run the append query which are not complete 4 fields. the append query wont append the...

Hi guys I would like to create the backup button in mainform do we have any easy command line to create one just call the backup access windows. btw I want to lock main tool bar after I finish the database so user can not backup by clicking backup on the toolbar so i need to put the button or...

thanks man it works :)

thanks for your sample it works but when I compare 2 values which are food costs I would like to check there are the same values or not so I use the field value is not equal to [fieldname] other fields look good, except cost fields it shows the result opposit for example not equal toI would...

just the form shows the query (qUpdateItem) Thank you RuralGuy I have got the way to check it Private Sub Form_Load() If DCount("*", "QueryName") = 0 Then MsgBox "No items to be updated", vbInformation, "Update Items" DoCmd.Close Exit Sub End If End Sub

sorry i dont understand so any suggestion just want to show the user that there are not update items to be update I dont want to just show the empty form to users thanks

thanks but it doenst work

I have the update query that display the items that need to be update this qury are link to the form I need this form show the Msgbox "No items need to be update" when there are not data in the update query. Private Sub Form_Load() If (qUpdateItem= Null) Then MsgBox "No Ingredients to be...

Hi guys I have a problem about Conditional Formatting I compare 2 values which are foodcost I would like to check there are the same values or not so I use the field value is not equal to [fieldname] other fields look good, except cost fields it shows the result opposit for example not equal...

Hi Dallr could u pls go back to check on Unmatch query pls ? cheers

still can not do it could u pls check the sample file that i attached Conditional formating on Cost feild Expression Is [tProduct].[Cost]<>[tOrder].[Cost] thanks

I tried to add the Expression Is <> (queryB.ProductName) but It shows invalid syntax any idea ?

i could not find Conditional Formatting on the query view