Search results

Regional Settings If regional settings for these datatypes have been changed, what am I looking for to change them back? How do you change these regional settings in the first place? Thanks, Andrew

We'll find out about those limits.... I'm sure I'll hit them. As for mySQL: No. If anyone could give me any resources on how I can accomplish this, I would love it. I don't know how to use any database utility accept Access, though I'd be willing to learn. Thanks, Andrew

While I don't think I've explained correctly/well what I want to do, I think you're right. I started off with a small database of English words and their definitions. I then used MS Access to create a list of URLs to "Spider". The list was pretty easy - I first changed all spaces between words...

Interesting results: I did import into Excel, and did end up getting a record on each row. I decided to try something before continuing, though. Instead of creating a new field with just the first few thousand characters from the "Web Page Text" column, I saved the Excel file "as is" and...

Ok - Oops. Failed to mention one big problem...This might be the end of my project. I think that many of these 60 comma-separated text files may be corrupt. Whenever I import/link a text file, I get this message: "One or more rows of data in your file contain too many characters to import...

Exactly - This problem isn't difficult at all...I know how to do all of this - Even a workaround, duct-tape technique to search a memo field....But I can't do any of it if Access is limiting me. I'll let you know how your solution works out for me. I'm envisioning success...That's what...

The best way to explain what I'm doing is an online encyclopedia...But not as nice. (Yet) By using MS Access, Google, and a lot of my time, I have compiled a list of educational URLs. Basically, for almost every word in the English language, there are an average of 5-7 ".edu" addresses that...

Pat: You're solution sparked another idea- Is there any reason why I cannot just link the textfiles to the database, each as a separate table? This would not increase the size of the database by anymore than a few 100 KB per textfile. What are the drawbacks? Len (Or anyone else for that...

I have several CSV text files that add up to 3.12 GB. I Would like all of this data to be placed within MS Access. My plan would be to import each text file as a table and then design a union query. I know that Access is a superb program, but am I stretching MSFT's limits, here? 3.12 GB is a...

I have 17 different excel sheets with one type of data. Every excel file contains records of people's first name, last name, phone number, etc. The only problem is that there are record repeats. For example, FileOne.xls has the a record that is also located on FileSix.xls. If I import all of...

Thanks Thanks, I'll try that out when I get back. A problem that I may have further down the road: I need to be able to replace that first path (C:\My Documents\Test.html) with a web address. I've been reading a lot of the threads on this site concerning this, and they have either gone over...

I'm using this code: Option Compare Database CopyFile "C:\My Documents\Test.html", "C:\My Documents\AJICO\Test.html" End Sub Why do I get this error:? Compile error: Invalid Outside Procedure

Same issue, but I know my syntax is correct this time I'm having the same issue I had earlier, but I've checked by syntax over and over again and I don’t think that’s the problem. My database has a table in it, called “Words And Definitions.” It has two important fields: "Word" and "Meaning"...

Of course you’re right. Leave it to a novice like myself to overlook a simple detail. I wouldn't have even posted the question if I hadn't spent all morning attempting it. It turns out the expression I posted has the correct names, but the one in the query did not... *sigh* Sorry for the waste...

In query criteria, why does this work in Access 97, but not in 2000? Like "*" & [Forms]![English Words Filters only Words]![Field1] & "*" I'm pretty sure you can see what I'm trying to do - If the value of Field1 in the form called "English Words Filters only Words" is "whatever", the...

So, using a previous example: [This is a field value] & "" "This is regular text!" the man said, while silently thinking of the seven hills of Rome. "Why can I not just type it?" He continued to ponder" "" Would this work? Is this what you're saying?

Sounds Good I'll attempt to use single quotes instead. I don't want to sound picky, but does that fit with the official W3 regulations? I'll use single quotes if I have to (I think that's what I'll eventually do) but I would like to be as standard as possible. I know this probably me just...

I could work, but what about... That's how I did it originally, but I ran into some problems. The first was that I couldn't line the fields from my table up with the HTML that I had copied and pasted in. Then I decided to use a calculated field to do it, but because HTML uses quotations for...

Link I'll be happy to post a link on my site, as soon as I have it all together. The domain I've purchased is: www.betathought.com but the actual site won't go up until around December. I do wonder, though: When I click on "Support The Access World Forums...DVDs, Games, Etc", why does this...

I have a table with several thousand records. Each record needs to eventually have its own HTML file. (Like a product inventory at wal-mart.com: Each product has it's own page) Has anyone done anything like this with Access? My experience is that Access's "Save as HTML" capabilities are not...