Search results

Hi If there is a relationship between price and customers than maybe nested query will solve ur problem, it goes like: Select Balance from TblBalance where Customer= (Select Customer from TblCustomer where Customer="b"); Hope it gives u some idea. Cheers! Aqif

I believe changing format alone will not help....if u want yes/no values to be displayed than goto the lookup tab and change the display control to text box. Cheers! Aqif

Hi There are two ways to do that job 1. Make two Macros Use OpenForm and specify the where condition as [TblTenant]![MyField] = Forms![Cases]![MyField] * TblTennant is the name of tenant table. Then make a CloseForm action and I hope it will work 2. Write the code behind button...

Hi If u r creating a new table in Access then u can easily set the field datatype to "Autonumber". If u r linking ur form to Oracle database table and then u have to write a procedure for picking the maximum ID and then incrementing that. If u have experience with database triggers in Oracle...

Hi I am trying to work out a query but dont seem to find the suitable logic. Lets look at my exiting output from query Select Or_Date, Sum(Or_Amount) As Sum_Amount from MyTable group by Or_Date; Or_Date Sum_Amount --------------------------- 1-1-2001 25 2-1-2001...

Hi All I've got this unique problem now. Most of the people use " " to clear the text box or field. I've got a text box. I also have a button which clears the box. Problem is that when i use " " for clearing the box. It clears OK but when i try to enter data it leaves one space in the start...

Hi The best way for me to attach a currency symbols is to just change Format property of the field like "Rs. "0 or "US$"0 hope u'll find useful Cheers! Aqif

Hi All I've got a database which has got lots of yes/no type fields. I have declared yes/no datatype for these fields and using the yes/no control on the form. The problem is that when i see table..instead of storing yes or no it shows the picture of that yes/no control i.e tick box. If i...

Dear Ian: Ur answer is close to my demand. The thing is that the company only deals in 40 countries and its not possible that they will extend the countries list. How will i use the lookup function or smthng like that when i've declared 40 cases for 40 countries. Can u write the code in...

Hi All I want to create a function that will lookup the numerical value for thier text value like Val Desc --- ---- 1 Country 1 2 Country 2 3 Country 3 Note: I can only have a possible of 40 Countries. Rite now I am creating a countries table and then matching the values...

Hi All I've also got a unique method which has never made sense to me but it worked changing the current control color. You need to do following steps. 1. Fist give background and fore ground Color to text box that color which u want to see as active item background & fore ground color. eg...

sorryyyy Now i see the reply

Heyyy!!!! Why I m not seeing any reply.?? When it is showing Replies as 1 Aqif

You can do something like that: If Me.NewRecord = True Then Docmd.RunSql ("INSERT INTO EmployeesHistory (FirstName, LastName, Title) VALUES (Forms!Employees!FirstName, Forms!Employees!Lastname,Forms!Employees!Title);") else Msgbox("You are viewing an existing record now") End If I hope this...

Hi All I want to create a dynamic function which can work with any field. As an example I want to create a function calculating Tax Amount. Following calculation will be in the function Public Function Tax_Amt() Tax_Amt = Total_Amount - (Total_Amount * 2.5) End Function The problem is that...

Thanxx....it was of great help to me

Hi All I am using lookup function like this DLookup(" [Table1]![Field1] ", "Table1", " [Table1]![Field2]= [txtbox1]") its working fine for me but I want to use a variable name in criteria like Dim var1 as integer var1 = 1 DLookup(" [Table]![Field1] ", "Table", " [Table]![Field2]= var1")...

Hi All My suggstion is to perform calculation on "On Current" Event of the form. It works great for me. I dont see any fault with the formula. Cheers! Aqif