Recent content by Rafool

Hi, Is there a way to write a query to SELECT Table.* EXCEPT Table.Field1, Table.Field2, etc.? I have a table whose fieldlist will constantly change, but I need to call the whole table except a few fields? Thanks.

I've decided to import the data and clean it, then using a query to combine the two tables (input data and cleaned data) based on index. The problem is that I need to join inputdata.* and cleandata.* in a query (because I don't know what arbitrary fields will be in the inputdata table), but I...

Thanks for the help, PHV, that was what I was looking for. Unfortunately, my boss just made the specs much harder, so now I need some advice from anyone about the best way to approach this problem. I have code written that will take address information, parse it/clean it up, and output that...

Hi, I've seen a lot of posts on tek-tips about how to import files using TransferText or TransferDatabase, etc. But how do I simply open the Import Wizard (File, Get External Data, Import) from Visual Basic code? Thanks.

You guys are both incredible. Thanks a ton.

Upon closer examination of my data, it appears that there's good news and bad news. The bad news is that often the street number comes after the street name, e.g. XYZ Road 3, so I can't just use Val to pick out the first numerical values from the string, because it will run into the alphabetical...

Hi, I'm trying to clean up a large database in Access. I have one field for address, which needs to be broken up into Street Number, Street Name, and Street Label (St., Road, etc.) The problem is that the data is very dirty. So some addresses will be standard "456 XYZ Road," while others won't...

Hi, I'm trying to start a new web site on a relatively large scale, with a giant listing of lots of info (>1,000,000 records), and lots of information within each record. I need it to be relatively powerful but not overboard. And it will have some e-commerce functions in them. I don't even know...

Hi, I'm trying to start a new web site on a relatively large scale, with a giant listing of lots of info (>1,000,000 records), and lots of information within each record. I need it to be relatively powerful but not overboard. And it will have some e-commerce functions in them. I don't even know...

exsmogger: I know 10BaseT needs two full pairs and Merlin needs three, what I'm asking is if they can share a pair, i.e. if I can splice one pair and have a Merlin signal and an Ethernet signal on that same pair wires.

Hi, I currently have a Merlin (I'm pretty sure it's either a 420 or 820) running over 4-pair wire to each room in a building. Now I also want Ethernet (10BaseT or 100BaseTX) in those rooms but only have that one 4-pair wire in each room. Now if I remember correctly, Merlin uses 3 pairs, and...

I'm sorry to bother you with newbie questions, but I couldn't find the answer looking through the Tek-Tips forums. I'm trying to set up a Merlin Mail 2 (which I reset to factory settings thanks to the help of all of your out there who posted how to do it) on a Merlin Legend R7. The manuals have...