Search results

  1. StacyStacy

    URGENT! Calculation Question

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

    URGENT! Calculation Question

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

    URGENT! Calculation Question

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

    URGENT! Calculation Question

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

    Populating Fields HELP-URGENT

    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?
  6. StacyStacy

    Required Field on a Form

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

    Changing color on a Tab Control Form

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

    Changing color on a Tab Control Form

    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!
  9. StacyStacy

    split database

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

    Assigned Button to Open Query Window

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

    Assigned Button to Open Query Window

    Thank you! I do appreciate your help. ;)
  12. StacyStacy

    Assigned Button to Open Query Window

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

    Assigned Button to Open Query Window

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

    Assigned Button to Open Query Window

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

    Assigned Button to Open Query Window

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

    Assigned Button to Open Query Window

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

    Multi-User Lockout When Running Reports

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

    Multi-User Lockout When Running Reports

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

    Multi-User Lockout When Running Reports

    Please check msgs.
  20. StacyStacy

    Multi-User Lockout When Running Reports

    PS too: I replied to your private msg.
Back
Top Bottom