Search results

How to display Only One Record among many Hello friends I have a table having below fields. DrawingId DrawingNumber Revision 111 555555 0 111 555555 1 111 555555 2 111 555555...

Hello Friends During data entry I am running a Macro to update some fields in an other table. When I click the Command Button, Macro runs and my tables are update. Every thing is fine. But I want that when User finish Data Entry, required fields must Auto Update. For this, I tried to run this...

Hello friends. I am making a form to Select Some Records and then send it to Print. I want to use a Form in DataSheet View. Using ComboBox for Selecting a Record from thousands of records. Upon selecting from ComboBox other 5 fields must display. I want to continue it till the required...

ComboBox in Datasheet Veiw Form Hello friends I am making a form to Select Some Records and then send it to Print. I want to use a Form in DataSheet View. Using ComboBox for Selecting a Record from thousands of records. Upon selecting from ComboBox other 5 fields must display. I want to...

Demo Database for Time Limit Hello Friends I want to include a time limit when a Demo Database run. Suppose I want my database run for 15 days and then it must Locked or Not Accept the User. Any guidance for this trick. thanks irsmalik

Dear Mr Isladogs Yes, you are right... DrawingNumber is primary key in table and set to NoDuplicate. so what will be the solution.

Hello Friends I am making a database for Drawings Duplication Check. Fields are given below DRAWING it is Numeric SheetFrom it is Numeric SheetTo it is Numeric Suppose Drawing Number is 500 and Sheet From 1 is already entered...... if I try to enter same data it gives me...

Thank You so Sir Pbdaldy... Now it is working..... I realize... I call you again & again... but believe me... I learn a lot from you. Once again Thank You. irsmalik

No Sir Pbaldy........ this is your suggested line rs!FieldName = ctl.Column(1, varItem) Below is my line......... I think I am making some mistake..... rs!EmpName = ctl.ItemData(1, varItem) Please see the attached picture for code and its error message. My Selection form is also shown in...

Sir what would be the exact line ctl.Column(1, varItem) ? irsmalik

No Sir... Pbaldy............ it is giving compile error... Plz see the attached picture. My purpose is to Add EmpID EMPLName EMPFName thanks irsmalik

Sir PBaldy Sorry I could not understand your line. kindly correct below lines as per your idea. Purpose is to append / update record. Set ctl = Me.lstEmployees For Each varItem In ctl.ItemsSelected rs.AddNew rs!EmpID = ctl.ItemData(varItem) Also want to Add EMP Name, Phone etc. rs!OtherValue...

Dear Sir Pbaldy I have check multi select your web page Set ctl = Me.lstEmployees For Each varItem In ctl.ItemsSelected rs.AddNew rs!EmpID = ctl.ItemData(varItem) rs!OtherValue = Me.txtOtherValue rs.Update Next varItem ************* Plz guide me if I want to add 1 more item in this...

Hello Friends......... In the Data Entry Form..... I am using following fields by using Combo Box Company Name.......... Combo Box .. and get Company ID by using DLookup Region Name ............ Combo Box .. and get RegionID by using Dlookup Area Name................ Combo Box ... and get AreaID...

Hello Friends......... In the Data Entry Form..... I am using following fields by using Combo Box Company Name.......... Combo Box .. and get Company ID by using DLookup Region Name ............ Combo Box .. and get RegionID by using Dlookup Area Name................ Combo Box ... and get...

No Sir pbaldy... it is giving me word "whatever" I want to display the value of FAS, if it is Less then 10 Number like 9, 8 or so on. in query it must display.... Expr1: IIf([FAS2]>=10,"10") if less than 10 Expr1: IIf([FAS2]>=10,"10", iif [FAS]<10, [FAS]) any one plz correct my query. thanks...

Hello Dear friends I want give Numbers for my field staff on their performance. FAS is an activity.... If some one gain 500 out of 500, he will be given 10 Numbers. if less than 500, then how to show its performance in Query. I made below query. Expr1: IIf([FAS2]>=10,"10") it works fine...

No Sir.... my TDate field is Medium Date.... I want to fix it in my program. Every time when query run... it must display data 30 days before Current Date. irsmalik

Hello Friends I am making a query to retrieve Data 30 days before from Todate. I have already done this kind of work but I don't know why it is not working. here is the query SELECT DM.ClassName, DM.SizeName, DM.TDate, DM.FAS, DM.FM FROM DM WHERE (((DM.TDate)=Date()-30)) ORDER BY DM.ClassName...

Thanks sir PBaldy............ its working....