Search results for query: *

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

How are Shortcuts (Icons) added to the left pane of the OPEN dialog box for an application. By default; History, Desktop, and Favorites appear. I want to add a folder to the list.

Too far down in the forest to check the obvious [blush]! It's good to have folks available to "look over your sholder." As an independent (working all alone) contractor, this forum is a big help to me. A donation of $5 has been made to the forum, in recognition of our help. Thanks, Ken.

I created a workgroup, applied security and tested application. It works fine. Copied the MDA and MDW files to another computer. After logging into the database I am given the message "Database 'mydatabase' is read-only"... I'm confused- HELP!

Users are logging into a server via VPN and accessing their own Outlook accounts on that remote server. So, how can a file from their local PC be attached to a message being composed on the remote server? Thanks, Ted

Users are accessing their Outlook mail remotely via VPN. How can a file residing on their local PC be attached to an Outlook message they are composing on the remote machine? Ted