Recent content by KDg

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).]