Search results

i only want if first condition meet then stop the user at that point not go further postion. not check other condition . what i have write with first endif. code If IsNull(Me.total) Then MsgBox "You Can Not Enter Bill Without Any Products", vbInformation End If If Me.text.Value = "Sale" Then...

Dear Sir. i have attach a file.in this for obtaining the last record i am using this code which i read in microsoft article. Expr1: DLookUp("[MyField]","MyTable","[ID]=" & [ID]-1) Please Check my Query where is i am Wrong. i want to get the opening stock. example in my file. if you enter the...

Any Help any help about this thread

i dont understand dear wayne i don't understand what you are saying .is not possible. if possible what is the code. sorry for some misunderstanding

hello if my subform has no record and user click the new record button . then i want that a message appear "not allowed" and delete that record.or put a message that you must have to enter some data in orderdetailsub form. any help

showing , sign with first record thanks very much wayne it's working fine.but it's also shows the , sign with first value how can i remove that. your help is great thanks again

please see the attach file.i want that if user select a value from the combobox it insert automaticaly in the textfield and if select another value it's automaticaly insert with , sign. like that 246,247,248 how it possible. any help

Thanks For your help it's working thanks for your help.

Can somone help can some one help on my thread.

Month Vise Report what critaria i have to put in the query . see my attachment. i need some code for my attachment. thanks

Please See my AttachMent See my attach file. in that i have a sample table.and sample and a query .i want when the user click on search button the query shows the results of that month. any help greatly appreciated

i want to make a query which give the selective month data. Means if enter in parameter march it gives all records of the march i have form in which i have a combo for all months . january to december. i want when i click of march the report should only show the record of the month march or any...

I dont find the refrence i don't find the refrence for the date. Private Sub cmdNewRecord_Click() DoCmd.GoToRecord , , acNewRec Me.ctlPicker.Value = Date Cantfind Project or Libarary this message pop-up how can i solve that

Dear i don't know how to set a missing refrence for date. i download a example file dbdatetimepicker. in that a missing refrence Date. Cannot find the project or libarary how can i fix that . i am new so please give me detail answer

i want to make a query.i have form in which i have a combo for all months . january to december. i want when i click of march the report should only show the record of the month march.how can i do that .in query or report.

Any Idea to do that please see the attach file . any idea to that in query or in report. thanks

Please See my Attach File. there is a table stock . in that there is field Result Wanted.in that i explain what i exactly want to do.

Thanks Very Much For Your Kind Interest i am realy greatly thankful for your kind help and kind attention.i have solved the problem.one is by your query and other i have made a query which return the previous date balance and id.with date. then i made a report which is based on two query. at...

I have also this file before i have this file before i started the thread.but the problem is i don't know how to utilize this for my purpose.if you know exactly.please give me the example how can i bring the opening balance on top.and then ledger. if it is difficult in query i don't need in...

You Can Solve My Problem you can solve my problem. if you said that i will send a example file in which the result you are demanding . then i will be very relax.