Recent content by SyedAqif

Hi :) Can't u write something behind On Exit event of date Dim ChkDate as date Dim ItPrice as integer If Forms!MainForm!date < '07/01/02' Then ItPrice=Forms!MainForm!SubForm1!Price Forms!MainForm!Price=itPrice Else ItPrice=Forms!MainForm!SubForm2!Price Forms!MainForm!Price=itPrice End If I...

Hi :) Maybe I have not understood ur problem...but why dont u build ur form based on the query of current records and then set the primary key validation rule on the form itself. Maybe this will help u... Cheers! Aqif

Hi :) Try this, On the Control source of the Item Price write =DLookUp(&quot;[ItemPrice]&quot;,&quot;TblItems&quot;,&quot;[ItId] = &quot; & [Forms]![MainFormName]![SubFormName]![ItId]) Cheers! Aqif

Try using this ...maybe it'll help. I dont remember the exact code but it goes somting like that Forms_ddl('Create User :TxtUN identified by :txtPw') passing ddl statement on the form could be alternate approach Cheers! Aqif

OK :) 1. Logon to the database. (u'll be logged on with Admin) 2. Goto Tools-->Security-->User and Gps acc 3. Click on Change Logon Password 4. leave old password blank and set new password. Now on log on the access will ask u for the password. 5. Create other users and log on with them by...

Hi..will it be good to use Access built in security. Goto Tools->User and Group Accounts and set password for admin user. You can create new users and give customised permissions by going to User and Group Permission. This security is quite powerful..let me knw if u need some step by step...

What about making a database trigger which will insert the values in a seperate table. Call the trigger behind any table or even form. I always use this approach to log the users. Cheers! Aqif

You can write something like that and call them on Enter or On focus event of relevant controls Dim StrDateVal as Date If Me.RecordNew = True Then StrDateVal = Me.DateField1 Me.ActiveControl = StrDateVal End If Cheers! Aqif

I dont see y this is not working. Soemtimes popup form appears just like a rectangular tile having only min, max n close button visible. U'll have to stretch the form to see the actual size. Try to see if the form is hiding some distant corner of ur screen or not ;) Cheers! Aqif

well..this is a common problem which i never got over...but what i do is to open the report through a form and write my query like Where StartDate between Forms!MyForm!StDate and Forms!MyForm!EnDate If u'll open the report through parameters passed in form it will not ask u again. Cheers! Aqif

Hi :) You can write a code &quot;On Current&quot; event of form like this.: Dim StrPath as String StrPath=Me.MyfieldName 'field name storing picture path MyPictute.Picture = StrPath I hope this will work. Cheers! Aqif

Sooryyyyyyyy.............i was posting my thread also...and at the same time replying to ur so guessed it mixed up...regarding ur problem...what u can do is that have unbound controls or text boxes on ur report and write the same formula for calculated field as u've written in ur form. Cheers! Aqif

Hi :) I got a question regarding User Group. I have assigned the user group in the shortcut by adding /wrkgtp &quot;Path of work group file&quot; The problem is that When i open my normal access database having default user work group...and then open that particular database...it opens with...

I thjnk i understand the problem as i've worked in oracle sql plus for a long time. as long as i can see u can't use access sql editir as oracle sql plus editor :( but things will be different if u r using sql server. Cheers! Aqif

Hi :) When u'll c the properties of ur 2nd combo box, under data tab u'll find row source property. for that row source write ur query as: select StoreID,StoreName from TblStore where TblStore.GroupID=Forms!MyForm!Combobox1; On after update even of 1st combo box just write DoCmd.Reuqery...