Search results for query: *

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

Hi ;) In the begining of ur code it might be worth while by putting the form filter to null. Me![OrdersForm].Form.Filter = &quot;IsNull(CustomerID)&quot; i dont know whats causing the problem but my main guess is that some filter is attached to it... Cheers! Aqif

Hi :) I know my suggestion looks quite stupid :) but can't u build two queries.......n call them one at a time according to what type user wants n selects from the form. Just a suggestion. Cheers! Aqif

I think u want to attach a serial number type field. Just write a query like this: Table: Survival Fields: ID,Time,Status SELECT (Select Count(*)+1 from Survival where Time<E.time) AS SNo, E.Time, E.Status FROM Survival AS E; SNo Time Status 1 2.5 1 2 4.1 0 3 4.6 1 4 6.4 1 Good Luck :)...

Well....thats simple.....Just place the Subform on ur main form, rite click on the subform n choose properties. Then click on the data tab n u'll c LinkChildField and LinkMasterField. U'll also c a build button , click the build button n from different tables choose the link fields. Good Luck...

Welll :) One way is to just create a simple forms through wizard so that the links of ur forms with tables will be automatically created. Then right click on the text box u want to change to combo box. Then choose Change--->Combo Box. One the text box is changed into combo box then goto...