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 Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: Mannificent
- Order by date
-
look up next field, subtract and append
I didn't use the right headers for my sample, so I will try again: OK, I ran into a problem. The dlookup give me the value from the current record, I want it from the next record, how do I fix this? Here is my code: rst.MoveFirst Do Until rst.EOF vnum = rst.Fields(1) vmatch =...- Mannificent
- Post #5
- Forum: Microsoft: Access Modules (VBA Coding)
-
look up next field, subtract and append
OK, I ran into a problem. The dlookup give me the value from the current record, I want it from the next record, how do I fix this? Here is my code: rst.MoveFirst Do Until rst.EOF vnum = rst.Fields(1) vmatch = DLookup("[Mtr 1 Vlu]", "1r88", "[Mach Ser No_ Mainfr] =" & Chr(39) & vnum &...- Mannificent
- Post #4
- Forum: Microsoft: Access Modules (VBA Coding)
-
look up next field, subtract and append
Thanks, I get the idea and it sounds like a much better process. Would have liked some sample code, but I will try and figure it out.- Mannificent
- Post #3
- Forum: Microsoft: Access Modules (VBA Coding)
-
look up next field, subtract and append
Part No Serial Value Date MCBR 001R00088 G3U042022 8639009 2009-04-29 001R00088 G3U042022 8121497 2009-03-20 001R00088 G3U042022 7056211 2008-12-23 001R00088 G6U120297 2136304 2009-04-19 001R00088 G6U120297 1899563 2009-04-08 001R00088 G6U120297 1406969 2009-03-20...- Mannificent
- Thread
- Replies: 4
- Forum: Microsoft: Access Modules (VBA Coding)
