Stewart,
Thanks, I just wondered if there were more statements/functions such as DLookup -- Seems like writing a short function to do the Recordset overhead stuff might be a way to shorten the code.
skbrede
Last Activity: Nov 7 '08, 02:27 PM
Joined: Nov 4 '08
Location: The Villages - Florida
-
Simple Methods for accessing table fields in VBA ??
Is there a simple way to read and store into fields in a table without having to form a recordset for simple single record tables - using VBA -
How to read and assign table values into single variables
Is it possible to read and or write data directly to or from local varibles in vba --
seems like it wouldn't be necessary to go throught the whole recordset thing to do something this simple -- Thanks in advance. -
Thank you both !! Problem solvedLeave a comment:
-
Access Dlookup Matching Problem
Has anyone else had trouble with Access Dlookup function ? It works fine with a numeric matche criteria, but will not work with a "text" compare!! Would appreciate any help anyone has. If not is there any other way to read a field from a table directly into a local variable ??
No activity results to display
Leave a comment: