Search results

Thanks Rich. I did not see your reply until after I posted my reply. ;)

Answer to Question #2: Under the Table Properties, you need to specify "double" instead of "percent". The value will now show: 34.05%

Answer to Question #1: Each field has to have a value, even if it is '0'. I still need help on Question #2. Thanks,

QUESTION #1 I have 5 fields. The 5th field contains my sum. Example: TotalFruit=Apple+Bananas+Oranges I placed the equation in both in the AfterUpdate and Lost Focus in the field properties that I want the sum to appear. When I first created the form and placed the formular in the field...

How do I populate fields in my main table ... and write to the main table as well .... based on a value selected in a pull down menu that originates from another table?

Can I make a field 'required' on the form level and not thru the table level?

Can you be more specific? Access Preference? Or Windows itself? Thanks,

Hello. How can you change the color on a Tab Control Form? Mine is defaulted to Grey. Should I change it in my preference menu or is it something that can be easily edited like the rest of the forms? Thanks a million!

Hi. I had a similar situation in that I split my database. This is what happens when you split your database: a FE (frontend) and a BE (backend) copy will be created. Here's what you do: make a backup copy of the database itself. Split the database. Make a copy of the FE & BE for backup...

There's one more thing ... I would like the ability to see all forms, and reports created in addition to having the ability to create a new report. Does anyone know how to accomplish this task? Thanks.

Thank you! I do appreciate your help. ;)

Well said Autoeng! Thank you. Although, I do want to create a button that will reside on the switchboard to show all of created queries and give the option of creating a new query as well. In addition, I want to create a button that will reside on the swithcboard to show all of the forms in...

Yes and ... whereby they can see everything that was created as well. Just like in the Northwinds db.

Similar. I want a button to open the query window, the forms window and the reports window. I don't want to create a list of queries, reports nor forms. My goal is to hide the Table 'Window' and disable the toolbar functions. Thanks

To be more specific, I need to "write" the code to open only query, form and reports window. Thanks ;)

How do I program a button that opens the normal Query, Forms & Report windows? I have set up a switchboard to control what the users see. I have also hid the tables due to finding out that the users directly input data into the tables. I also found a thread that is similar to the resolution...

Thanks, I figured it out when I could only open the file but not the form, in addition to seeing an error in the path. Thanks sooo much for your help. PS: I have sent you a private msg.

Thanks. I did create the BE and the FE. Made copies of the FE and altered the db to only a switchboard and form. For the data entry users, I completed the work and the db works --- here's the new problem: I created the entire project under a different directory. After I placed the users...

Please check msgs.

PS too: I replied to your private msg.