Search results for query: *

I have an Excel file with two worksheets. I would like to write a VBA macro that will search cell B in worksheet 1, if it finds an X (in cell B) cut the line (row) and paste this line at the end of the second worksheet. This should be done for all rows in worksheet 1 (looping) until end of the...

Shadow, Thanks for quick response. I have never used ActiveX but I'll learn. Thanks again.

I have a small VB program that displays a form,users enter the data and it stores the data in an ACCESS db. What I would like to do is to put this program either on the server or on INTRANET so users can access and fill out the form. I do not want to INSTALL the VB program on every user's PC...

Thanks for the help. Will try it.

I have a database on a remote computer and I am able to LINK my ACCESS db using ODBC to this remote db. I would like to import these tables instead of LINKing, I know how to import via FILE/Get External Data\Import. I have a VB procedure to loop through the table and write out to my ACCESS db...

While I was importing a table using DSL/VPN ODBC I lost the connections. Now I am at work (I did this remotly from home) and each time I try to open the ACCESS DB I get this error message: "MICROSFOT JET DATABASE ENGINE STOPPED THE PROCESS BECASUE YOU AND ANOTHER USER ARE ATTEMPTING TO...

I would like to be able to capture user ID and then use it in a select query (ACCESS) to filter data for just that user? i.e. select all records from a table for sales agent John. This application has many users retrieving data at the same time.

I have 3 modules in an Access DB all 3 open Excel workbook and either write to it ot read from it. Two of these modules open/read the same excel workbook. I use MSscheduler to start Access DB. After one module is finish I close and quit workbook, but if I check TASK MANAGER I see EXCEL is...