Search results for query: *

I have some code (see below) which executes a SQL Pass-Through Query which calls a stored procedure in a network SQL database. When I use the QueryDef.Connect property set to just qdf.connect = "ODBC;", the program prompts me with the expected input prompt, listing the available ODBC...

I have a dynamic SQL statement which appends a record to a local Access table. This is the statement: INSERT INTO tbl_Scoring_Results (DPS_Num, Svc_Request_Status_Date, Company, City, State, Overall_Score, Communication_Score, Professionalism_Score, Expertise_Score, On_Time_Score, Dell_Score)...

I have recently begun work on a project using MS SQL Server 2000 as a data source and am trying to understand the 'best' way to access the tables, ODBC or otherwise. How does one configure Access to use ODBC tables. I have written a considerable amount of VBA Access code and am pretty familiar...

Does anyone have a good example of using a Property Set Statement correctly to a user defined class.

Does anyone have code example of using a connection to a MS SQL backend database? I'm new at this and would appreciate any help there is out there.

I have a Collection Object called SvcTags to which I add a number of class objects called oSvcTag. The code executes fine in adding items to the collection, however, When I try to iterate through the collection of objects in a later step of the Procedure to view properties of the instantiated...

I have inherited a database which uses numerous nested queries to execute business logic. In drilling down into the database I have identified some of the logic in the queries, which is implemented using IIf() functions to test the values of fields in the underlying queries/tables against each...