Search results

I'd like to disagree with raskew/bob, but i can't. There's some real lazy people about, the only thing to do is ignore them once it becomes obvious - if u don't wanna waste your time assisting someone that isn't interested in getting any better and only wants to sponge. NOTE - i'm not saying...

Hehe, unfortunately i think you may have used sarcasm in your post, probably won't get it. How'r pompey doing this season then? Seagulls 6th from top of the 3rd - that's success to us y'know. Anyone else getting hit by a pile of firewall messages while viewing this forum? - seems to trace...

nice try, but Pat's a little more mature than you and me. Flaming her for a reply a month ago is unlikely to get you a response. But i like your style anyhow

You'll regret it MG, that'll come back to haunt you - Drew [This message has been edited by KDg (edited 08-20-2001).]

Hi j, i don't know the proper answer to this but i thought i'd post as no-one else has. It seems that you can't delete rows over the connection ( at least no in 97, can't talk for the others ) although you can add new records and edit exisiting ones. I know you said you don't want it to be...

Hi All, i remember somebody posted a question like this a while ago but i don't remember any answer appearing, and i can't find the thread now. I also know i've posted that its better to use DateAdd in the past - but i don't know why, i think i remember reading that it's more accurate. Simple...

it might be a problem with the joins in the query - can you post the SQL here? ta Drew

hi Meister, my advice is please don't do it in code - i've inherited a db set up by someone that hard coded all these type of mappings and it's a total nightmare. Either you or the person that follows will curse the day you wrote it! The best way to go is to make a mapping table - eg you...

Hi Linda, Replace doesn't exist in 97 VBA but you may have some luck with the code on this post, regards Drew

Hi sanfoo, i guess Replace made its way into 2k, and i only have 97. However, as you can use any other function in a query i don't see why you shouldn't be able to use it also, i just can't test that. Rather than putting it in the criteria it should go in as a field. In the QBE grid you'd...

Hi Rich, this may not help as i'm not totaly sure of what you're doing. What i'm thinking is that you have a start date and want to go on adding 28 days to the date, translating each block into a number that starts with -1 and gets incremented to whatever Dim dtmEnd As Date Dim dtmStart As...

Hi Shacket, i think the way to go is probably the registry... you can get Dev Ashish's registry reader and under NT you'd be after the HKEY_CURRENT_USER\Software\Microsoft\Windows NT\CurrentVersion\Windows\Device entry. I've no idea under 2k or anything else. Seems to be one of those things you...

ie just tried with variants and strings in case that was knocking it off as i'd used dates originaly but it still works fine with either, all i can think is that you could try Forms(i).Repaint to make sure it is redrawing each form. I that doesn't help i'm stumped, sorry Drew

Hi, i just tried your formula and it worked fine - how are you setting compact and display? Drew

hi ben, I don't think this is a very good answer but here it is anyway... You can trap for the press of the button in the KeyDown event of any/all forms. They seem to run from 112 to 123 on my keyboard - i have no idea how this varies on different style keyboards. You'd need to set that up...

hi, i don't think there is an equivalent of Clipboard.Clear in access, but you could use something like http://support.microsoft.com/support/kb/articles/Q138/9/09.asp to send a small amount of data - which will then stop the message appearing HTH Drew

Hi, is there a way of getting the run command to run on the current DB ( i'm using 97) ? cheers Drew ps i came across this page which may be of some use http://home.houston.rr.com/jeffkohn/compactcurrent.htm [This message has been edited by KDg (edited 08-07-2001).]

Hi Louise, i've had a look and at the end of a long day all those IFs without statements are confusing me ( did you know you can use "If Not Isnull(Whatever) Then ..."? saves extra typing ). Here's the code i use to mail stuff out - you need to build your recipient mail string and send it...

DTs post from june is the most useful i've seen on the subject, if anyone has better please advise, you can get it here HTH, Drew

Hi Adam, unfortunately it's all a bit more complicated than that. Are you on 2k or 97?