Search results

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

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

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

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