Search results

I have been searching for a way to hide the Database window. i would like to make my current DB as protected as possible, and a macro or something that would hide the Database Window would help. I have Access opening to my SwitchBoard on startup and from there the intended audience can navigate...

i have a login form where i used the attached DB from this link http://www.access-programmers.co.uk/forums/showthread.php?t=163000&page=2 (it is the very last DB on the last page, not to be confused with the ones near the beginning of the thread. Thank You HTC!). what i would like is to know at...

hmmm, that seems like a lot of hassle for what would ultimately be little reward. i appreciate the response, i was just hoping there would be something in the text box properties. thanks though.

i am willing to bet there is a very simple solution to this problem. i have a text box that people will be entering information into, and prior to their clicking on it i was the text box too read something like "Enter Info Here" in a grey text that vanishes upon selecting the box. i'm sure there...

thank you very much. that was exactly what i was looking for.

i have a form that will be used for data entry. i would like my users to open this form from the switchboard and have a blank new record be the only option they have. i have removed the navigation buttons from the bottom, so to prevent them from finding other's entries.

alright, i'm sorry. i now see where you are going. instead of counting null fields, i am counting how many times the ID is listed, which obviously equals the null fields. ugh, i should have picked up on that sooner, thank you very much!

Sorry PNGBill, i mean no disrespect as you clearly have a MUCH stronger grasp on queries then i, but i think you are missing what the goal on my second query is. if my first query pulls all the date from a table that shows the person's ID, the tasks that are incomplete (null fields), and the...

and i would enter this in the criteria?

so basically there is no way to tell a query to count null records with a specific null field?

I have a query based on a query. the purpose of the original query is to filter through a table and find all tasks that have not been completed (null values). this original query also has many ID's in it, along with the null fields (incomplete tasks), and the value of each task. when i create my...

alright, with your help this is where i'm at: i have queried my query, and i now have a new query that groups the people together, and totals the task's values. problem is, the field where it would show which tasks are incomplete (which is know to be incomplete because the field is null), shows...

the criteria for showing five comes from a text box unrelated to the text box that populates "1,2,3,4". if this new text box comes back with a date greater than today (sorry i just changed my approach on that, as opposed to anything but null), i hope that the text box where i have manipulated...

i'm sorry, i think you lost me

so with that said, the text box that has been returning, one, two, three, four. will not be able to display five like i was hoping because i cannot tie this code into it?

in my DB, not single task will be assigned to two people. the table i am querying has the taskID, the person, and the values in it.

=IIf(Len([Status] & "")=0,"",Switch([Status]=1,"One",[Status]=2,"Two",[Status]=3,"Three",[Status]=4,"Four",[Status] Not In (1,2,3,4),"")) that is my current expression, i then have another text box, formatted to show the date (__/__/____) where if anything is inputed, i would like it to return...

awesome! thanks!

sorry, that last part was supposed to be a question. qill i add this into the control source along with the rest of my IIf expression? if so, would you be able to script it for me?

that worked like a charm! thank you very much. now on to the next question. i now have a query that lists all the tasks that remain incomplete. each task has a specific value tied to it. what i want to do is display each person once, how many tasks they have left, and the total value of all...