Search results

don't be leaving already jamie, all boards could use some skilled coders like y'self. Come back , ask some A's answere some Q's. Experience of non-M$ languanges seems to translate to into VB etc far better than M$ translates into other langs. Don't be going so soon. If i helped u please give...

second bit first - If d = "" Or f = "" Then... or If d = "" And f = "" Then... rather than c style. For the declarations you'd end up with Option Compare Database Option Explicit Private Const strFilePath as String = "\\capt_kirk\conversion\data\caa" Private strFileName As String that is...

Hi again, first you can get filepath = "\\capt_kirk\conversion\data\caa" that you use in both sections of code into one. Up the top just under the Option Compare Database Option Explicit you could use Private Const strFilePath as String = "\\capt_kirk\conversion\data\caa" . Then you can...

if you did set up a button on a form then do it in there eg Private Sub Command492_Click() Dim strFileName as String strFileName=GetTheOldestFile("xyz","*.txt") if Len(strFileName) then DoCmd.TransferText acImportDelim, "spec", "table", strFileName, False / True Name...

Hi aqif, if you wanted to use F3 for example then set the KeyPreview event of the form to yes and on its KeyDown trap for the particular button that you are after. i believe that these are common to all keyboards, but i might only think that as i work in a corporate environment - ymmv. Just...

check out "setwarnings" in the helpfiles, i think it's what you're after, if not or u have any problems post back, HTH

if the tables have identical fields you should be able to do a UNION query to get them together. Depending on how complicated the single queries are you may need/want to do 2 seperate queries and then pull it together into one HTH Drew

I'm not sure what you mean by 'a typical problem' - surely only if the db isn't normalised? If all you want is to move a value over you should be able to do me.txtFieldName=Forms!Form1!txtFieldName on open of the new form?

Hi JaGa, sounds as if you have a structure problem, what you want can be done in code but if your at the start of this project then getting it right now will save lots of effort later. You should really have the tables structured so that you only store company name, adress etc once. You can...

ooh php - that's what i'm getting up to speed on at the moment - it's just so damn nice and powerful. I got the php cookbook and it's excellent, i really wish there was a vb equivalent. As you say it would be more efficient to call Getxxx once and keep it in a var, but it doesn't need to be...

aaah, that would be my lazy coding - if you change dtmDate=Date to dtmDate=Now then it should all work just fine ( no, really, this time it will...) hey, your diagnosis is pretty good for someone that's never coded before. Get that book and you'll be laughing in no time. The dtmDate is, as you...

hmm, i've copied my code out and copied you docmd and its working fine over here. Try putting a break mark ( click on the right hand grey bar in the code view ) next to you docmd line. Then go to view the form, click the button and the code should stop on the line u marked. Press f8 to go thru...

sorry, i'm really not the best at giving complete instructions! Okay, so you should have th whole of the GetOldestFile function in a Module. Then my personal choice would be to make a form and put a button on it. Go into the properties of that button ( right click | properties or double click )...

tell him to get u a training course, who the hell does he/she think he is. "here just program a db for me - but don't expect any help, you can use that internet thingy, right?" bloody PHBs. Anyhow, rant over but if your gonna enjoy that job i'd guess you'll probably need to spend some money...

sorry, what i meant was start to totaly new db - not touching the existing one at all for the minute. Then, in the new db get external data etc, you should have all the menus still available from there, [This message has been edited by KDg (edited 09-28-2001).]

Hi jh, i'm assuming you've got the import automated okay so if not post back. This is not very tidy but it does work so post the GetTheOldestFile function into a module and you can call it as i have in in sub h ( but hopefully with a more usefull outcome! ). As far as renaming/moving the file...

Hi NK, at worst you should be able to create a new db and go File | Get external data | Import and just grab everything you want. For the future - always use a backend and front end ( and keep a current back up of both ). That way you can lock up the front as much as you want and if you...

gonna be tough, it depends on how different the entries are - there's nothing to stop you picking up "British Telecom*" that should get both, but matching "BT" and "British Telecom" etc is a bit more complex. If you really need that too then post back as i think it will need some code HTH

hi, as you say the enter key is now being processed twice - first due to you code and then due to its regular method. You'll need to cancel the regular method if you want to stop it moving twice eg if keyascii=13 then lalala.setfocus keyacii=0 ' changes the value being passed to the...

<assuming you're not joking, or assuming you think ms is all there is> What RH have u got? 7.1 is good, if u fu i the install you may need a brain scan, it's less than tough. If you can get new ram or a new hd into your pc you won't have any problem at all. AND you get a proper web server (...