Recent content by TeddB

I tried "If IsNull(strVar1)" and it worked just fine. Thank you, ReluctantDataGuy. "A good man knows his limitations." -- "Dirty Harry" Callahan (Clint Eastwood)

I have the following code: strVar1 = Forms![frmQry_CaseSummary]![DevlName].Value If strVar1 = Null Then ..you know the rest... Debug shows that strVar1 = NULL, however the IF statement does not execute! What am I not seeing here??? "A good man knows his limitations." --...

Thanks Bob. Your function worked like a charm! "A good man knows his limitations." -- "Dirty Harry" Callahan (Clint Eastwood)

Have a text field containing many words. Need only last word. ex: mountain stream grass Have tried RIGHT function, but can't supply 'lenght' number because the lenght of the word varies. "A good man knows his limitations." -- "Dirty Harry" Callahan (Clint Eastwood)

Have a DB with a single field containing address info in it in the format: streetaddr,city,state,zip Need an SQL statement with string functions or VBA code to extract each element of address info and create descrete fields. HELP I'm stumped! "A good man knows his limitations." --...

I should have searched forum first. Solution previously given. hsitz (Programmer) Jan 21, 2002 I usually use a VBA procedure to run from the "Don't Save" or "Cancel changes" button. You can put this in the VBA slot for that command button: ---------------------- 'dirty...

Situation: A record is opened in a form for editing. Information in several fields is edited. Now, user decides not to keep changes and leave record in its original state. Since Access records changes to information when you leave the field, how can changes to all fields be undone? "A good...

Guys, I have done several apps in 2k and haven't encountered any problems. What do you know that I should be aware of? "A good man knows his limitations." -- "Dirty Harry" Callahan (Clint Eastwood)

Thanks for the quick response guys. I am going to encourage the client to upgrade the '97 users and make life eaiser ;-) "A good man knows his limitations." -- "Dirty Harry" Callahan (Clint Eastwood)

I have been given a project with will require creating a database with a few related tables (to allow "picklists" or "droplists") and a few forms and reports. Nothing that is very elaborate. I do intend to create a Switchboard. Should I encounter any issues with accessing...

I have been using a 3GL (now 4GL) rapid application development environment called Clarion. In my opinion, it's a great RAD. However, more of my engagements are requesting solutions using Microsoft tools (NO COMMENT!). Any advice from those of you having experience in this area will be truly...

I have been using a 3GL (now 4GL) rapid application development environment called Clarion. In my opinion, it's a great RAD. However, more of my engagements are requesting solutions using Microsoft tools (NO COMMENT!). Any advice from those of you having experience in this area will be truly...

I have been using a 3GL (now 4GL) rapid application development environment called Clarion. In my opinion, it's a great RAD. However, more of my engagements are requesting solutions using Microsoft tools (NO COMMENT!). Any advice from those of you having experience in this area will be truly...

My copy of Access 2000 (9.0.2720) is displaying the Short Date format as "mm/dd/yyyy" I installed a database on another computer with the same Access version (9.0 .2720) and it is displaying the Short Date format as "mm/dd/yy" ?!! Any ideas on WHY?

NEVER MIND- Excuse the ring... I found the answer in an earlier post from: Technochick (MIS) Nov 30, 2001 Thanks I found it. Here's the link for others that might be interested. http://support.microsoft.com/default.aspx?scid=kb;EN-US;q205041