Search results for query: *

Thank you. It works well. When you say "building criteria in a query" is that an option when creating Queries? because I definately would like to be able to pass variables to Queries, but haven't figured that out yet. Steve

Hello, this is the first time I have ever manipulated the data associated with a FORM, with VB (I know VB very well, just not the ACCESS interface) I want to take the Value in a field VENDOC_DOC_Path, and pass the value to a shell command to launch the file outside of ACCESS, when a button on...

Thanks for the help. This is just what I was looking for. I needed the basic starting points to get the ball rolling. I'll look into these passthru queries, because I do have linked MYSQL tables that will ultimately be the backend of a PHP enabled web frontend. I populate the data into...

thanks - I can definately use DAO if needed, how is the assignment done in the first code example? dmax("DATE_INVOICE", "TBLINVOICE") or does access just understand which tables are local to it, and the command accesses the table directly i.e. dim dtDate dtDate = dmax("DATE_INVOICE"...

Hello, I am new to ACCESS programming, but not to VB, I am familiar with Recordsets, and dealing with resultsets using ADO, but not with the inherent ACCESS commands. Based on a button being pressed, I am trying to pass SQL to a database table with invoice data, (Dates and Value pairs) and...