Search results for query: *

Hi everyone, Is there a way to programmatically locate a database in a directory through VBA? For example, I have two Access 97 databases (front end and back end) that will be converted to XP shortly. As a process of the conversion, my company wants to eliminate any hard coded drive paths in...

Hello everyone, I've created a stored procedure that accepts various input parameters and builds a dynamic SQL statement from them. Here is the procedure: CREATE PROCEDURE dbo.sp_LPXCustomerLimitBrokerSearch @Status VARCHAR(2), @RegionCode VARCHAR(3), @LincsCode VARCHAR(5)...

Is it possible to pass an entire listview control into a class function? What I have is a form that contains a listview control. The listview has field values obtained from a recordset. I have a button on the form that should export the listview values into an Excel spreadsheet. I would like to...

Hi everyone! I have a search form where users can enter values into text fields. Currently I am assigning the field values into an object that passes the values into a class I created. The class function ultimately places those values into a stored procedure to retrieve a recordset. I want to...

I have a mini search tool where I have the users enter a client's name in a textbox and with each keystroke the record listing becomes more specified. The problem is when ever a user needs to enter a space in the search textbox the cursor just moves to the end of the word and hangs there. I...

I have a database that tracks work orders. There are 5 different types of work orders, each displayed on a separate form. For example, for a Radar work order there is frmRadar form, for a Video work order there is frmVideo form, etc. There is an additional form that shows a listing of all work...