Search results for query: *

I'm running server 2003 with terminal services, active directory, and DNS installed. I've confirmed the DNS portion is working properly from the client XP machines. My active directory is setup as follows: Forest: mb.s Domains mb.s ->Default Domain Policy <block inheritance>...

Thanks for the additional info GVF and Harley! I've learned so much from all the help -- this site is incredible!

Everyone thanks for your input. I think I can work with other posts on char codes and the like to get what I want. I appreciate all the help! Stars all around! :)

Sounds like I can use both recommendations to get what I want. Skip...can you be a little more specific? Maybe I need to play with something else besides Sheets(1).Name for the input box -- then set valid input to Sheets(1).Name. Would I do something like... fourscore: myvar =...

Hi guys and gals! I hope this might be something someone can shed some light on for me! I've got an input box that opens up to rename an excel sheet. The trouble is...I get a run-time error if the user clicks cancel before entering in a name. The second message box (which verifies the users...

Hey guys- I was wondering if anyone had any ideas. I have set up VPN tunnels for two BEFVP41's. Subnets 192.168.3.0 and 2.0. My machines are all configured static, with the gateways on x.1. I wanted to selectively use IP ranges for my local and remote groups. However; unless I use the...

How do I modify this code to take the first 5 sheets in the workbook, or alternatively only use the worksheet names I specify. Thanks for any help!

This is a web driven report site. I do have to log in, and I do have full access to what I see on the screen. Yes my goal is to put this information into a database. If that means two separate excel files--- transaction list, and transaction details for each transaction then that is okay. I...

Hello- I have access to a web driven report site that has a list of transactions. Each transaction has a detail link associated with it. The site has a built in export to excel for the list of transactions....but not for the extra detail you can link to on each transaction. I need to pull...

This works great as long as the referenced workbooks are opened. Is there any way for the cell references to be assigned .xls files that are not currrently opened? I am aware of the links command in the edit menu. I'd like to be able to simply type a name of the file rather than drill through...

PVH - Works perfectly thanks! BobStubbs - Great robust example...nice to have something that is easily modified for other uses! Thanks for all of the help guys! I think I can put this one to bed now. :)

I would like to use something typed into a cell within excel to update other formulas within the spreadsheet. Basically I want to be able to update a group of formulas by changing a single cell. Is this assigning a variable or defining a name? This is probably really simple. I have one...

Would a simple redraw or refresh form command solve the problem?

I'm not sure of any DOS program that can directly open up Access files...but that doesn't mean it doesn't exist I'm using a DOS program now that was developed with Visual FoxPro. The data is stored in .DBF files. Access can link/create/edit these files with an ODBC driver found at Microsofts...

Not sure this solves your problem...would an IF statement that returns what you want if the field is NULL work?

I know this looks rediculous to you MichaelRed. I wasn't sure if I should start a new thread or not. To answer you question: I'm learning....albeit at a very slow and often interupted pace. I got started on this project over two years ago. It got shelved when we lost personnel and I'm...

I need a way of striping non numerical characters from say an invoice# field. At this point I just don't know how modify the code and create the public function. The code discussed so far: Private Sub Form_Current() Dim i As Integer Dim j As Integer Dim holda As String j = Len(Me![machine])...

Alvechurchdata, yes I could handle the cut/copy and paste method. Unfortunately I need to make this, "push button" simple for the masses. Thanks for your input though! Pbrodsky, thanks! I didn't even think about using VBA code in Excel to retrieve the specific data I needed. I forget that...

Hello- This is a very basic question. I'm looking for any ideas. I have an access query that I need to use to fill data in on an excel worksheet. This work sheet already has some headers and other stuff already created at the top of the sheet (like title and company info). I need to start...

Ok, I'll give that code a shot, and THANKS!!!! Just for my curiousity how would I use the code you gave using the REPLACE method? I must not be declaring something properly in the module, or something. I can't get it to work like the SQL and VB example above. I really appreciate the help...