Recent content by HCB

I failed to include the desired results. In the example of source data, there were two spreadsheets(tables in the DB). One is a Reference table containing 4 rows of 2 columns: Key - Unique numeric value for each type of care Type of care The other is the detail for each type of care containing...

I have a reference table and a detail table with multiple rows for each value in the reference table. A sample of each is attached. I need to build a unique table for each row in the reference table with the data in the detail table for the associated reference value. I am new to VBA...

thanks for your suggestions. I will need to study this as I need to learn a lot more.

I am new to VBA programming and I would like to run a pass-thru query (to SQL Server). I have the following code developed that compiles and executes without error, but I am not sure it does anything (at least not that I can see. I run the code using a Macro without error, but also without...

Not the same person, but a similar issue. I am new to VBA programming in Access and am trying to use a local (Access) table/recordset to a SQL Pass thru query. Local Table: One column (Patient_IEN) as Patient_IEN 7175551, 23613408104, 23613413153 SQL Pass Thru Sample: Select...

No. When trying to run the 2003 code in 2007 The quit command works (i.e. the database closes), but it does not open the master. After some research it appears that 2007 does not recognize DAO commands. That is the reason trying to do in ADO. Thanks.

We have just converted from Access 2003 to Office (Access) 2007 and I am trying to convert a script we had to ADO structure. The intent of the script is to move via form button from one databast to another. Below is the script from "Before" and "After". The intent of the test is to move from...