Search results

Hi Everybody I am doing some work in access. I need help to ease the job by some automation through "DlookUp" or "ELookUp" My task is very simple I have a form of passengers based on Passenger table which has different fields including FormNo Table two (ApplicationForms) contains only One field...

I have table of students with a field GroupID like diffrent nos of students in one group like 5 in Group A 6 in Group B and 3 in Group C What I want is that when I click or update Group ID the all student data under that Group is added to specific table. If we update Group A all...

:)thanks I will try and let you know with out come

Sir thanks for quick reply but I want this job to be done on form can we use Append query threough Form?

I am using Access 2007 I have two tables 1.Students with Group & Name fields And 2. Bus with Group & Name fields I have different students in groups for example 5 in Group B and 7 in Group A What I wish to do is when I enter the group like A on Bus form all the data (Name & Group) of...

Error in current record print command The following code works well in office2007 but gives error in officeXP as Access is closed and asking to save the back up. Is there any difference in CODE for XP & W7 Private Sub Command30_Click() Dim strDocName As String Dim strWhere As String...

Hi Mr John Big Booty thanks for advice & warning I dont understand why have issued a warning to me anyhow solve my problem If ROOM occupied from 13/3/2012 and shows OCCUPIED how to show it available automatically when the customer leaves and we enter a leaving date

I am facing a problem 2 tables LU Product and Sales Point I want the price from LU product populates when I enter the product in Sales point form The code I have written is as below Private Sub Price_AfterUpdate() Product = DLookup("Product", "LU Product"...

I am facing a problem 2 tables LU Product and Sales Point I want the price from LU product populates when I enter the product in Sales point form The code I have written is as below Private Sub Price_AfterUpdate() Product = DLookup("Product", "LU Product"...

Hi helpers I am facing a problem 2 tables LU Product and Sales Point I want the price from LU product populates when I enter the product in Sales point form The code I have written is as below Private Sub Price_AfterUpdate() Product = DLookup("Product", "LU...

I am facing a problem 2 tables LU Product and Sales Point I want the price from LU product populates when I enter the product in Sales point form The code I have written is as below Private Sub Price_AfterUpdate() Product = DLookup("Product", "LU Product", "Price=" &...

Hi All helpers I have a problem with VBA code of "DLookup" I am trying the following code which works well Private Sub Price_AfterUpdate() Product = DLookup("Product", "LU Product", "Price=" & Price) End Sub BUT when I apply with reverse order it does not...

Hi All Members My full name is Malik Mahmood Iqbal Taloker. I am from Pakistan and spent around 14 years in Kuwiat in car rental business. I am niether a programmer nor new with Access. I was suggested by a programmer friend to try ACCESS. Actualy my job was threatened due to delayed daily...