Search results

so with what you said about select[field], i place the field into a form that is where the task results are inputted. if there is anything entered at all, the task is complete, if the field is empty, the task is still ongoing. i would like my new text box to simply total the amount of incomplete...

do you believe this would be a parameter query?

thank you, that did it! BTW, i have a question posted over on that IIf function thread, if you don't mind taking a look boblarson.

i have a DB with a form in it that has many text fields. i have a command button on this form that can clear all data entered in these text boxes, but not delete the record itself. below is an example of my VBA coding: Private Sub Clear_Current_Record_Click() Dim intResponse As Integer...

unfortunately i am not able to upload the DB. sorry

so there is pretty much no way to setup codes with a filter or something pulled ffrom the table, like if [whatever field] is null, display, something like that?

i will have to create that query now then. that is too bad, queries are my weakest skill in access, i never got the hang of them, but hopefully i can make something happen. thanks.

ok, the value in question is a date formatted text box. if that makes any difference at all. and this will also hopefully be added into the string of the previous expression, except the value i want to analyze is coming from a different text box

is there any term or anything to use in this switch that is just generic? what i am looking for is something like below: Switch([Example]=any value at all, "Example" ?

I have a DB with a long list of people with assigned tasks. thoughout the course of the day these tasks get completed. what i would like to do is create a form that will essentially show the progress. each person has an idea, example: 1 - bob, 2 - bill, 3 - bruce, etc. i would like this progress...

thank you boblarson, i firgured out my problem, just a few repeating records, causing the computer to get confused. you have been a huge help! i will surely be posting other questions here hsortly, and i always appreciate your assistance.

i have heard in the past on other boards about Me.Dirty=True being in the code when you access a subform from a switchboard or something to that affect?

it all works as a standalone form, just when i use it as a subform it stops working

sorry, i cannot upload at this time. i appreciate the help thus far, but i understand if there is nothing more that can be done. something else worth noting, some of these switch aren't taking effect when i access the form from my switchboard. if i exit the switchboard and enter the form the old...

big time oversight. thank you. so now what i am getting is some null fields come back with "none" and other's still come back with "#Error". you are really helping me out here though, sorry for being a pain.

i have the below expression that is giving me an error with the syntax: =IIf(Len([Example] & "")=0,"none",Switch([Example]=1,"Example 1",[Example]=2,"Example 2",[Example]=3,"Example 3",[Example]=4,"Example 4",[Example]=5,"Example 5",[Example]=6,"Example 6" [Example] Not In(1,2,3,4,5,6)...

boblarson, your help is always appreciated, but sadly i may be missing something. i added the NZ at them beginning and the repeated "none" at the end, but then it gave me the "#Error" in every field...

thank you very much. that did the trick. now i am running into some text empty boxes say "#Error" and some do not... kinda weird.

i have been typing this expression into the Default Value box within this field. would it be possible that is the wrong place?

unfortunately this switch function is not working for me :(