Search results for query: *

I have a text file (computername.txt) that has 50 computer names. I want to read each computer name from the text file one at a time and perform an action on each machine. The computer names were originally in an excel spreadsheet and I just copies and pasted them to notepad. Not sure if I...

Why will my form not open in datasheet view when I use the openform command? The default view of the form is datasheet, but it always opens in single form. Please help.

Okay GURU's I need your help again. I have a form with a subform that holds steps to take to complete a task. At times we need to add a step in the middle of an existing task. What I would like to do is be able to click a button (add new step) that would allow me to add the step with the...

I am pulling in a phone number from a database that has multiple formats (ex. (123)555-1234, 1235551234, 123/555/1234). I want to remove any thing from this field that is not a number. Is this possible??? Thanks for the help, Paul

I have a field the user is inputting their phone number in and I do not want any dashes. How can I remove dashes if they exist or prompt user to reenter without dashes? Thanks, Paul

I did a search, but did not find exactly what I was looking for. I am trying to only pull the user name from the Request.ServerVariables("LOGON_USER"). The first 11 characters is the domain and a slash. All I want is the user name. What is the best way to do this? Thanks, Paul

I am trying to insert several records into a table. The code is inserting the correct number of records, but it is entering the same data for each record. Could you guru's give me a hand with this code?? rsEntries.MoveFirst Do Until rsEntries.EOF For i = 1 To rsEntries("expr1")...

I have a record in one table that I need to duplicate "x" (x will be determined by a field in the table) number of times and insert into another table. Any suggestions on the best way to do this.

I need some help returning a random record in Access 2002. I have tried the following solution form Microsoft, but continue to get "Type Mismatch" error on the Set MyRS = MyDB.OpenRecordset(RecordSetName, dbOpenDynaset) line. The goal is to have the program determine a winner from a drawing...

First, let me say I am new to JavaScript... I have four fields that I need to check to see if they are blank when submit button is clicked. If so, then pop up a alert box telling user to populate fields. Here is my form: <FORM action="SaveData.asp" method=POST> <table> <tr><TD>First...

I am having problems connecting to a db on a network drive with a password. The web page works fine for me from my machine, but not from any other machines. Is it possible to access a db on a network share with a passoword? The error message that is being displayed is database already opened...

Okay...I have a field that needs to be populated with the current month. The catch is that it needs to go from the 10 of the current month to the 9 of the next month. In other words, today is June 1, so the month field should still be populated with May. Then on June 10, it should change to...

This is what I am trying to do: User enters their data on the date entry page and clicks the submit button. Next I want to query the database (access db) and see if a record already exists and if not then insert the new data. If the record for this person already exists, then redirect to...

Is it possible to create a list box and have it populated from an Access DB? The problem is my drop down boxes are too long and are taking up the whole screen (the real problem is users using 800x600 resolution). So I thought I would create a list box that only displays one row and they can...

Okay..I am giving up. I have a form that I want to be hidden when access is open. I am setting the visible property to false, but the only what this works is if I open the form from design view. In other words, the form has to be loaded before I can hide it. I have tried to setfocus then...

I have the following input field that I need to redirect to the parent window. Can I do this from the value field? <input type="hidden" name="Redirect"value="http://homepage.html"> The code I have now is redirecting the page, but it is opening the the whole site in the frame, so I now have...

I am saving the users data to an Access DB then pulling out the submitted data and emailing to them their submission. Right now the user clicks once to submit data to the database. This event calls savedata.asp, which saves the record to the DB then pulls out the data and displays it in the...

What are the steps to create an unbound form? I thinking this may help the speed of my DB, but not sure on how to get started. Maybe my question should be how do a create a record set for a unbound form?? I think I understand how to create the recordset, but the connection part is what I am...

What is the best way to just pull the Month and populate a text field?

Do you all see anything wrong with this code: 'Create ADO connection object Set adoCon = Server.CreateObject("ADODB.Connection") 'Set active connection adoCon.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & server.mappath("Database\DB.mdb") strSQL = "INSERT INTO tblData (FName, LName...