Search results

hi, if i want to check a field that it contains the text how can i do that example a field t1 if me.t1 ="what i have to put here" msgbox "Please enter number in this field" exit sub end if

hello what is the best way to use a unbound form. to save record through a button. append query can be used for that purpose. thanks

How can we secure the tables and queries. is there any way to secure the tables and queries. by making mde file we can only secure the forms and reports and modules but not the queries and tables. is there any way to secure the tables and queries. thanks for your help kashif

Hello Dears i have orders and orders detail form. i have populate form in which i search the code . i want to enter the record on double click event in the subform from populate form. can somone give me the idea how can i do that. my subform field name is Code. and list is attached with the...

Please Can Somone Help me. please see my attach file . i explain my problem on the report. Need Someone Help. thanks

Hello All Dears . And Request From The Experts. i want Help to Maintain the Tables. Please if you Can Give Me the Example what i want i will be greatly Thankful. i want to maintain 1.Sale 2.Purchase 3.Journal Ledger 4.Trial Balance 5.Balance Sheet. 6.Stock Report For this Puropose i am at the...

Hello Dear Sir i have a form in single view. i inform you about my problem. basically i want double entry.mean when i received money by our customer.one entry goes to that customer id and i want the other entry goes in cashin hand. table field dd id transictiontype debit credit when cusotmer...

Hello Dear i am in big big trouble please give me solution. see my attach file. in Searching Form Please give dates "09-10-04" and "15-10-04" and id "1" it's give you result remember date format i am using dd-mm-yy . after that give date . 01-10-04 and 15-10-04. the problem will in front of you...

i am using vbyesnocancel msgbox. what i have to do if user click on cancel.nothing done return to form. the code i am using undo the record.if press cancel. i want if user click on yes then go to new record. if user click on no undo the record if user click on cancel return to form. code If...

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...

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

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

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...

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.

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.

Hello Dear i have a ledger report.i am using overall sum in calculated field. i want to take balance in Opening Balance Field Before The dates i have given. Example. i give two date "5-09-04"" and "8-09-04" it gives me result and it's fine. the problem is that in" Opening Balance Field" i want...

I want to know what is the profesional approach to update stock.i am using the learning database northwind. in orders detail i create a field which dlookup the stock. i want to know how i update my stock. update query.or any other way. please any body can refer me a sample file in which the...

i am using a button to show the product by LinkCriteria method by a subform when i select product id ""1""" it brings up it's price """"12""". and if i want the detail info i click on the product detail button.and it's give us information form.where all products detail about that productid...