Search results

Aron, are you able to post an excel spreadsheet of the kind of data you are collecting to help me conceptualise what data you are collecting? mainly because you say there need to be 2 entry options in day 1 but 4 in day two? are you taking more measurements in day two than in day 1, or are you...

why don't you use a cascading combo system instead of VBA?

Oh no, what sad news. My condolences to his family and friends. He had helped me many a time. May he rest in peace.

oooo! i didn't know about synctoys... will have to check it out. thanks access guy! as for robocopy (from earlier in the thread) i had a look at the scripting required for it, and it's quite a bit more complex than xcopy... there are GUIs out there, but they don't actually explain any of the...

hellava lot less work than copying manually folder by folder. or in 50 mb chunks. one line's not a lot of work at all. i wrote a 900 line batch file to handle my backups, which i can run at anytime now with a bunch of options, so a one-liner is really quite a no-brainer. (edit: i thought you...

ok, i just looked up robocopy help via command prompt and i SWEAR it didn't look that flexible and feature-full last time! maybe i am confusing it with something else? anyway, i'll give it a go :-)

sorry, i probably should have said that "right-click|properties" is from windows explorer. @Galaxiom: i've heard of robocopy but never used it. i think i checked it out once and it didn't do something i wanted, so i stuck with xcopy. might be time to re-visit robocopy. thanks for the push :-)

i like the command prompt for this sort of thing. windows key + R cmd ENTER then i generally use something like: xcopy "C:\Users\Me\Music" "D:\BackupFolder" /C/D/I/K/F/S/Y >>"D:\BackupLog.txt" this will list each and every file that it copies in the log file. if you want to know what the...

hi everyone, i've posted my final excel manipulation code here. got it working! i only have to now start on the process of importing the data into access. i'm sure that will be just as fun. :-)

oh, i hadn't noticed the unprintable character... that would certainly make a difference. in any case, i have everything working (using late binding) up to the point of being ready to start bringing it all into access. here's all the final code (also attached as a zipped .bas file) for anyone...

and so my tuition continues - i now have about 15 tabs open in my browser defining, comparing, and showing examples of both "late" and "early" binding... thanks Banana - i strive to make my code as elegant, error-free and streamlined as i can...!

ta. i was worried it'd still go through the motions even if it isn't visible...

if you guys want to test this code on my file in your environment, i posted the excel file in my first post as an attachment. edit: and here's the latest required code. it has three modules. the module with the code we're manipulating here is called modImportPhoenix. the code asks the user to...

As a start, Access didn't let the code run at all, throwing an error at "Dim rng1 As Excel.Range" - Error "User defined type not defined". I tried something like that before, and access just wouldn't like any of my declaration types (Range, Excel.Range, ApXL.Range, etc etc) eventually i tried...

Hi Banana, yes, i've been working towards streamlining my code. have already removed any hint of "select" and now i'm sure i don't need my "activate"s either. i will only use 'select' if i'm trying to test (edit: i.e., testing my code) that i've got the right range or cells or something (edit...

Hey guys, thanks for all the help. vicodin, i got error 91 on yours, and when i broke up the code into smaller sections (to see which bits access/excel was unhappy about) i got error 1004.... (or the other way around?) Brianwarnock, yup, i'd originally tried all sort of variations on that kind...

thanks for your quick response. yes, this is the same excel sheet as i've previously posted about. i'll look into that. looks like it might help. yes, as far as i can tell from the files i've looked at, the number of relevant columns is fixed (it'd better be!) i thought about doing something...

Hi everyone, what i'm trying to do is manipulate excel data in preparation for import into access. i have progressed quite well, but i'm stuck on how to select a dynamic range from within access: i have some columns of data, which i want to copy to a new worksheet. They are columns A:I, but...

tell me about it! finding access code is easy. finding excel code is easy. finding access code to manipulate excel is not so easy! when i'm finished with my coding, i plan to put it up (maybe as a sample?) so that others might be able to use it (or bits of it, anyway).

thanks for all the tips, guys - i'm now ploughing along and learning lots about Excel VBA (and how different it is from within Access!). I've gotten further than i though i would in just a few days (though it took me a whole day to realise one part was not working because i simply mispelled...