Search results

I need to get a list of about 110 subfolders from within a folder. I searched high and low on this forum, but didn't see what I was hoping to find. I tried putting a little Function together, but it gives an error. Here's the routine, and I commented the line that gives me an error: Option...

On a VB forum I visit, they ask that if your "plight" has been solved to your satisfaction, that you edit your first posting of the subject at hand, to include "[RESOLVED]". For example: Posting: How do I spell Access? Solution put forth by member alphabeta: Here is your answer...

ghudson, Thanks for your suggestion...however, I'm running Access 2000, and I could not find anything within Access 2000 or my help files related to what you suggested. Do you kow if your suggestion is new to AC 2003? Is there maybe an equivalent in AC 2000? Thanks again!

Anybody?? Any takers? Please ????

No...not yet. I'll try that when I get home tonight. Thanks!

I know how to convert an Access database from a previous version of Access to a higher version of Access, using the shell command: x = Shell("C:\Program Files\Microsoft Office\Office\MSACCESS.EXE " & Chr(34) & strOLDDB & Chr(34) & " /Convert " & Chr(34) & strNewDb & Chr(34)) However, what do I...

Anybody??? Any ideas????

-------------------------------------------------------------------------------- I had a project that was using SQL, and then had to modify it to put a date into a field, going from MS Access to Oracle. Here is what the code looked like: strSQL = "" strSQL = strSQL & "INSERT INTO MasterPN "...

At work, I';m using Explorer, and at home, I log on through AOL and use Explorer once I'm logged in. It was working fine prior to the hijacking incident. Any ideas on what I might try at home?

Can't login from a different computer When I'm at work, I can log in to the forum and post items, etc. However, from my computer at home, it's a different story. At home, I sign on to the forum, get the message, "Welcome, Greaseman," and then am presented with a screen that tells me I have to...

Thanks to all of you who responded! I truly appreciate your ideas and suggestions. I'll give them a go and see what "sorts out." And, actually, this was only for a small table of about 3,000 records, so optimization wasn't a concern. What I ended up doing in the meantime was to zero-pad my...

It'll make it easier to export the data in a user-requested arrangement. Plus, I only want to have a small code module that'll take my input table, sort certain fields within the code and then "spit out" an output table all nicely sorted and arranged. I wouldn't think I need to have queries...

I know how to sort using queries, but am interested in how to programatically sort, using VBA. I did a bunch of searches on the forum, but didn't find anything. Does anyone have a suggestion or a small sample of how to sort one table's fields into antoher table? Thanks!

A "busted" forum?? So anyway...... what happened to the forum ?!?!?!?! I hope it recovers well! Hacking or hijacked.... they're about the same, and to think some yo-yo has to make it bad for the rest of us royally ticks me off!

I was wondering what happened to this forum yesterday...... and today, I'm wondering what happened to the code sample and other example parts of this forum? Is there anywhere I can go to , to find ut what happened to the overall appearance of the forum? Or, is it just me???????? :confused:

Bat 17, I got it figured out!! Here's the code I used: 'Using the FSO requires setting a reference to "Microsoft Scripting Runtime". 'Module-Level Variables/Constants Private fso As Scripting.FileSystemObject 'Change the following constants to the appropriate folder names Const cstrXLSpath...

Bat17, Quick question re: the code snippet you provided: On the lines, Set dbs = CurrentDb Set rstXLS = dbs.OpenRecordset("tblXLfiles") With rstXLS It looks like you had some sort of table with the names of your XL files in it. In my case, I won't be having a table with a list of file...

Cool! Thanks! What took you so long to reply???? :-) I'll mess around with it and see what comes out. Thanks again!

Does anyone out there know how I might do the following: I have a main folder which contains many sub-folders. In turen, each subfolder contains several files. I am interested in creating a text file that within each sub-folder will list certain files in that sub-folder. Example: "Main...

Sorry for my typos in my previous reply..... they hired me for my programming, not my typing or English! :D