Search results for query: *

I've never used Infopath and am just learning about it. I'm wanting a way to easily create data entry forms for users to enter data into a SQL database as well as run pre-created reports or views of the data (possibly web based). Would Infopath be a good solution for that? The DB is SQL 2000.

I'm trying to use Worksheet_SelectionChange to identify if a user selects cells F4 through F30 to thus execute a macro but I'm having some difficulty with the syntax to define the F4:F30 range. Thanks for any help.

The company I work for is moving off of its current business software to a new one. The current application runs on SQL 2000. We want to leave the server and the application active just for referencing history data. What would be an easy and suitable way of rendering the database read-only...

I can't figure out why a vlookup formula will not work. I'm getting #N/A errors. I've used vlookup numerous times but never had this big of a challenge. It's almost like a data type problem. In the table_array, I have alpha-numeric data in column 1 and numeric data in column 2. I've changed...

Does anyone have any production experience with InDesign on a Mac MINI? If so, how does it perform? My reason for asking is that my wife, a magazine Creative/Art Director (MAC and Adobe CS products), is losing her job. She will be doing some freelance work soon so we've got to get outfitted...

Someone told me that AD user domain accounts could be added to local groups on a Win 2K3 server with said server not part of the domain but a stand-alone server on the network. Can anyone confirm that this is true? Thanks!

I'm using the following to connect to an Excel spreadsheet from VB6. Dim xlConn As Object Set xlConn = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=k:\clad\form 102\31 plate\237C1003-31.xls;Extended Properties=""Excel 8.0;HDR=Yes;IMEX=1""" When I RUN the code I get a TYPE MISMATCH error...

I'm developing a simple VB app to manage the creation of some MS Excel files. Nothing complex, just some List Boxes, File List Boxes & some Command buttons. I'm using the Shell function in a button to allow the user to open a selected file with MS Excel. I'd like to do the same for printing a...

I'm trying to put some data from one spreadsheet into another. I'm automatically getting the filename of the target spreadsheet and opening it with no problem. I just need some help finding that last row in the newly opened spreadsheet. Thanks -MP

I'm going to develop some code to write some data from a currently opened Excel spreadsheet to another. Is the best way to accomplish this to do a Workbooks.Open and Workbooks.Close or is there a way to write to the file with out opening it? Thank - Mike P.

I've downloaded the Daylight Saving Time OS patch as well as the Outlook DST patch from Microsoft & wanted to automate the installation to user's computers. I've never written any vbscripts but I do some VB and VBA coding. I figured that I could come up with a script that would reside on a...

I need to get some users names into the Recipients List that show up only in the Global Address List when using Outlook 2003. How can I accomplish this? Thanks - Mike P.

I just finished taking an SQL Programming class to get an understanding of SQL's coding syntax and capabilities. What I want to do now is take an existing Excel spreadsheet which I've developed and code it to do an INSERT into a table in our SQL Database. Currently the spreadsheet is coded...

I just finished taking an SQL Programming class to get an understanding of SQLs coding syntax and capabilities. What I want to do now is take an Excel spreadsheet and code it to INSERT some specific data into a table in our SQL Database. Currently I've coded the spreadsheet, with VBA, to email...

Does anyone know if the Excel Temp Files can be redirected to a different folder? I have a custom Excel VBA spreadsheet that users of a particular Domain group have read/write access to but I've removed the ability to delete. The problem is that since the temp files are located in the same...

I've got an Outlook (pop3) user who is receiving numerous copies of the same email. The Email account is set to not leave copies on the Exchange Server. Can anyone help?

I've successfully written some code to execute a certain task if the user clicks on a cell. This is done by have a conditional statement in the Work Sheet code. Private Sub Worksheet_SelectionChange(ByVal Target As Range) If Target.Address = "$B$13" And Target.Value = "" Then "code...

Using the following code my workbook gets emailed to the appropriate recipients from a listbox but I get an error after execution. Any idea as to why? Thanks! Code is: Private Sub CommandButton4_Click() Dim email_person Dim entry_counter As Integer entry_counter = -1 Do While entry_counter...

I'm using the following code to email the Active Workbook with email_person as a variable. I 'm getting an error and the email is unsuccessful. Any suggestions? ActiveWorkbook.SendMail Recipients:=email_person

I'm trying to use the following code to read entries in Column J (starting at row 1) of Sheet 1 and add each value to a list box until a blank entry is found. I can't figure out why it's not working. Help would be appreciated. Private Sub UserForm_Activate() Dim Insert_Name Dim Counter...