Search results for query: *

Thanks Paul, I was hoping to avoid that process but it looks like it's the only viable solution. Frustrating. I have over 300+ spreadsheets to import and naturally, they are't all in the same format. About 5 different formats. The next step is getting things into first and second order...

I have a multitude of files to import. I've set up a subroutine to import them all to MS-Access using TransferSpreadsheet. It works reasonably well for my needs however, I have two challenges: When it runs, Access will generate import-error-tables but the name of the import-error-tables...

However, if I put the [Include] into a text box in the footer, it displaces values (-1 and 0). Very odd.

Okay. I opened the event and inserted into the VBA subroutine. I tried to view the report I ended up in the debugger. It doesn't recognize the [Include] field. Very interesting. I wonder if Access doesn't know how to handle Yes/No fields??? mike

Thanks Duane, Sorry but you lost me. I think you're suggesting that I can't use the "expression generator" to build the code? I tried what you sent and Access didn't like that either so back to the expression generator. Maybe I'm using the wrong terminology. When I click on the band within...

I'm having a heck of a time with using the "visible" parameter. I have a report band called "Include". It's based on a True/False field called [Include]. I'm trying to turn TEXT on/off based on this value. From what I've read, I think I need to modify the report footer band ("Include") and...

Thanks Kurio, That makes more sense. As I thought about it more and more about the subject, it was puzzling me why offer such an option in the router for the home user? It seems so odd. But as you've suggested, it is a way to do some segmenting and isolation. Now I just have to find an...

Thanks Jim, Actually, I read the manual several times before posting and it still doesn't make sense to me. The tutorials that I've read pretty much read the same. Big on jargon but weak on explanation. Here's my confusion. I'm trying to figure out how to configure the IP address of the...

Ok, I think I understand the concept of NAT but in the new Linksys E-xxxx routers, you can disable NAT. What does that do? Does the router now act just like a switch and passes the data through the Internet side to the LAN side without address translation? I must be missing something here. mike

Thanks. I think the RUNAS is what I've been looking for. Been doing even more research and looks like this syntax might work. RUNAS /USER:remotecomputer\Administrator "\\remotecomputer\program.exe -a -b -c". Going to give it a try later this week. Sure been a lot of changes in commands and...

I've been researching and the more research I do, the more confused I get. I have computer running in Workgroup mode. Someone has installed foreign server to allow me to run an application. I'm lazy and don't want to use a mapping. I want to build a command to use in the command line but I...

I called my friend today and he indicates that it's working. Hurray, the code above fixed the problem. I'm almost starting to understand this VBA stuff but I better not get too cocky. I'm sure there's a whole lot more to learn. Thanks for the advice and consult. Mike

I'm new to this stuff but this looks odd to me: ' THIS IS THE CHALLENGE If Range("A1:A1000").Value <> Me.acctnumber.Value Then MsgBox "Please Enter Correct Account Number" End If Checking a range of accounts against s single value? Would it be better to use a VLOOKUP function instead...

I went to another friend's house to test with Excel 2003 and found part of the problem. It now works on 2003 and now to test on 2007: Originally I had the following: Early_version = Val(Application.VBE.Version) < 6.5 If Early_version Then number_of_days = [atpvbaen.xls].NETWORKDAYS( ...

Thanks "anotherhiggins", I called my friend and he said something about the NETWORKDAYS being the problem. >>references....problem of missing references.... Okay, you've stumped me. Are you talking about "[atpvbaen.xls]."? I read where this is a library reference to Analysis TookPak. From...

I wrote a very simple VBA function in Excel 2000 and it uses a call to NETWORKDAYS. I had to enable the Analysis TookPak and it works well. I sent the workbook to a friend to admire however, he's using Excel 2007 and has problems with my VBA function. I added the attached code to resolve but...

Oh no! It can't be that easy. I spent way to much time trying to figure it out only to be this simple. Thanks Glenn, Much appreciated.

I've hit the wall. I think I've tried every possible combination and still can't get it to work. I've broken it down to the very simplest of tests and still can't get it to work. Can someone guide me to a solution? I'm having problems with passing the RANGE to VLOOKUP. My spreadsheet has a...

Thanks Combo, So, there is no "direct" way to rename the textbox. It looks like VBA doesn't have the means to create the array while instantiating the TB. So, you're advocating that we build a new pointer to the existing box. Kind of an interesting work-around. Thanks, mike

I'm using Excel and I have built a UserForm. On the UserForm, I've placed a MultiPage. I would like to put 20 Textboxes on each of the pages. When I drag a textbox to the userform from the toolbox, Excel automatically assigns the name to the new textbox. More specifically, it appends the...