Recent content by bquan

Thank you so much. This did work. I can now get into my full menus. I have another question though. If I save one file with the full menus at start up as my working copy for administrators, and another with all the start up limitations (that I will distribute), then when they do data entry...

Hello All, I have a switchboard that comes up at start up and limits access to my tables and tool bars and menus. When I set up the administrator password and log on to the database the switchboard opens up with all the limitations. I want to have complete access to all menus and tool bars (I...

Thank you again for all your help. your explanation and the articles made things so much more clear.

Thank you so much! I have not idea what I did, I just followed your instructions, and it all worked. Now I can see the list of my queries and reports. Thank you very much!!! Do you mind explaining to me what I did and why? I do not understand why the "missing" was checked and what do...

Hello All, I have two different databases and in one the dialog boxes are working and in the other they are not. I did exactly the same thing in both. The error message it is giving me is: "Undefined Function 'Left' in expression. I followed instructions from an access book and the syntax...

Hello! I have 3 tables that are supposed to be related and I have put them on a form. Table 1 : has demographics info (dob, school, etc.) Pk is a client ID Table 2 : has address info for a particular client (they can have many addresses) This pk is autonumber Table 3 : has the address type...

Thank you so much David, I have not tried it yet and won't have time to for a few days. Unfortunately I will have to postpone this project until after my vacation and a couple of hectic days. I appreciate your help so much! I have saved your instructions and will try it as soon as I come back...

Thank you for your reply! I do store it by month. It is stored by month and by employee number (those are my primary keys) Actually, thinking about it, I am not even sure if I have stored it by month...the way I look it up is by either "billed time" or "non billed time" of each employee and...

Hi everyone, I have a database that is looking at employee productivity. Some of the fields are: month of the year, billed productivity (in percentage), etc. My boss wants me to do a calculation to find the difference in percent from last month and this month. So, he wants (March's billed...

I have run into several problems. First, I had a subform as part of several pages of forms. Data was entered in all forms and subforms, then I made several format changes, whe I tried to add additional data to a subform, a message on my status bar states that field is not updatable. Other...

Thank you so much for your help! I tried the queries and it worked!

Thank you for your prompt reply. But, where do I do that? I have tried to to it in the table, but when I open the form, it does not change it. Also, I could not find a place to sort in the actual form. Could you advice? Thanks

My forms have several fields where historical data for a client is kept. We need to update it often with a "open date (to certain program)" and a "close date (to that program)" I would like that once we look up certain client in the form, we see the most current "open date" to a program. Our...