Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Dlookup column on a form from a Combo Box
I am trying to lookup the second column in a combo box to auto fill a form using the AfterEvent Update Me.VendeurID = Me.PickCombo.Column(0) Me.FirstName = Me.PickCombo.Column(2) Me.Emailtxt = DLookup("[Email]", "[Vendeurs]", "VendeurID = " & Me.VendeurID) Me.Equipetxt = DLookup("[equipe]"...- Loopyl00
- Thread
- Replies: 9
- Forum: Microsoft: Access Forms
-
Create A report between two dates
I have managed to create a Report from a form that displays data per date In the query criteria for the date it references the form [Forms]![equipe_form]![Date de Vente] The report is based on the results of the query as per the information entered in the form so far so good However, I want...- Loopyl00
- Thread
- Replies: 8
- Forum: Microsoft: Access Forms
-
Adding a field that autoupdates from another table
I have created a combo box SELECT Vendeurs.VendeurID, Vendeurs.[Last Name], Vendeurs.[First Name] FROM Vendeurs GROUP BY Vendeurs.VendeurID, Vendeurs.[Last Name], Vendeurs.[First Name]; This successfuly returns the first name and last name, and i'm able to autofill a text box with the first...- Loopyl00
- Thread
- Replies: 11
- Forum: Microsoft: Access Forms
-
Ranking and Assigning a Value
Hello, I've been trawling the web trying to find how to build the expression to rank how many machines an individual has sold by date and to assign points for the ranks - so he who sold the most 6points, 2nd 4 points, 3rd 3 points, 4th 2 points 5th 1 point. This is how my query is set out...- Loopyl00
- Thread
- Replies: 0
- Forum: Microsoft: Access Forms
