Search results for query: *

Look, I used find to look for "Time" and it gave me nothing as I didn't select the 'Current project' option, the 'current module' option was checked by default. To be honest most the vba that i write is only in 1 module anyway so it wasn't the first thing i would have thought of. I did try the...

Skip, Firstly, if you read the thread you will realise that I hadn't seen the enum declaration at first, so no it wouldn't have given me a hint before posting. Had I reasised that i had declared this variable in a different module then yes, of course it would have given me a hint and i wouldn't...

ah, yes, i had Time declared as a public enum with a value of 9. i didn't see it as it was in a different module. I have changed the public to private and now all is well! (bad naming of variables i know!) Thanks for your help. much appreciated as always. jimlad "There's this thing called...

Just tried Time$ and got a compilation error... "Type-declaration character does not match declared data type" jimlad "There's this thing called being so open-minded your brains drop out." -

Hi, Hopefully this is a simple one but i can't fingure it out for the life of me. i have this simple line... msgbox Time which returns the single digit of 9 instead of 9:10:11 the same thing happens with the date function. This is only happening with excel vba. When i try it in Access it is...

Try this replacing "YourForm" with the name of your form... Forms("YourForm").Move Left:=100, Top:=100, Width:=10000, Height:=5000 jimlad "There's this thing called being so open-minded your brains drop out." -

Hi, I don't know anything about stored procedures but if you can refer to a text box on a form from them then this will work. create two new text boxes on your form. promp the user for the parameter details and store them in the 2 text boxes refer to these text boxes from your sprocs instead...

followed Remou's link, worked a treat thanks. Thanks for both replies. jimlad "There's this thing called being so open-minded your brains drop out." -

oops, wrong forum sorry. I've reposted in Microsoft: Access Modules (VBA Coding) forum. jimlad "There's this thing called being so open-minded your brains drop out." -

Hi, I have a text file which contains a null character which when trying to import into the database causes all the data after this character to be truncated. I am trying to automate a process which will import this every day and the null value will always be there. Please could someone...

Hi, I have a text file which contains a null character which when trying to import into the database causes all the data after this character to be truncated. I am trying to automate a process which will import this every day and the null value will always be there. Please could someone...

Thanks for that link jadams0173, i've seen that thread before but forgot all about it. Awesome tip which works brilliantly. jimlad "There's this thing called being so open-minded your brains drop out." - Richard Dawkins

No Microsoft Access Obj. Libs at all? are you looking in the vba editor under Tools/References? Maybe the link to the reference is broken? This may help? http://allenbrowne.com/ser-38.html jimlad "There's this thing called being so open-minded your brains drop out." - Richard Dawkins

Hi, Do you have a reference set to "Microsoft Access 10.0 Object Library"? I put the code into a brand new db with only refs to the above ref and to "Visual Basic for Applications" and it compiled ok jimlad "There's this thing called being so open-minded your brains drop out." - Richard Dawkins

Thankyou, thankyou, thankyou! Everyone is so helpful, it's much appreciated. jimlad "There's this thing called being so open-minded your brains drop out." - Richard Dawkins

Hi Andy, Is this any help? http://www.tek-tips.com/viewthread.cfm?qid=967205 jimlad "There's this thing called being so open-minded your brains drop out." - Richard Dawkins

Very helpful, thanks SQLSister jimlad "There's this thing called being so open-minded your brains drop out." - Richard Dawkins

Thanks Jeff, Your advice is much appreciated jimlad "There's this thing called being so open-minded your brains drop out." - Richard Dawkins

Thanks to you both for your help, Alex, I didn't realise that sql server express was free, that's great, i'll download it. Jeff, forgetting i've ever worked with Access sounds great! the only reason that i've mentioned this though is because i've seen many jobs where they want access front...

Great thanks, i'll check out these courses when I get time. I'm not sure what specifically I need to learn. Like I said, I know some JET SQL (from ms access) so I can use the basics (SELECT, INSERT, UPDATE, DELETE etc). I really need to learn 2 things... 1) The sql server environment as apposed...