Search results for query: *

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." --...

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." --...

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

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?

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.

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 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

While trying to run Scandisk on a WIN98SE machine, the utility continued to restart. I went to Selective startup and unchecked everything, rebooted and ran Scandisk again, only to encounter numerous restarts again. Examination of Running Tasks under System Information showed...

I need some code to enable a hot-key launchable (memory resident), screen scrape utility to capture a section of text from a predetermined area of the screen an preform an operation with it. Your help is greatly appreciated. Ted

I need some code to enable a hot-key launchable (memory resident), screen scrape utility to capture a section of text from a predetermined area of the screen an preform an operation with it. Your help is greatly appreciated. Ted

Is there a statement to determine if Autofilter is currently activated?

Help Wanted !! I have an Access query containing names of thousands of filenames, which need to be deleted from disk. Can this be done entirely from Access? If so, could you please give me a code example. Much obliged :-> Ted

I thought I could learn this language by tearing apart recorded macros. This helped. Then I tried using the "Object Browser" as a learning tool. This, in my opinion, made things as 'clear as mudd'. But, after seeing what some of you "Super Heros" know, I know now- I AM LOST...

After using an "Autofilter" to identify a group of needed rows, I want to create a Range containing only the visible rows. I have tried the following code, but receive and error in the last statement: Range("A1").Activate var_StartDate = "11-1-00" var_EndDate =...

Simple form with two TextBoxes, Okay, and Cancel buttons. If condition in TextBox1 is not met, I want to keep focus on it until condition is met or Cancel button is clicked. I have tried the following code for TextBox1: Private Sub TextBox1_Exit(ByVal Cancel As MSForms.ReturnBoolean)...