User Profile

Collapse

Profile Sidebar

Collapse
crystalgal
crystalgal
Last Activity: Sep 20 '07, 05:07 AM
Joined: Mar 23 '07
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts

  • VB Command button return total count from another worksheet

    Help. I am using Excel to enter in daily numbers in worksheet 2. I want to use vb (w/in excel) to create a command button in worksheet 1. I want to enter a date in a cell and click the command button. I then want to use the date i entered into the cell to sum the total of numbers from worksheet 2 by filtering the numbers by the date.
    I want to enter 7/15/2007. I want to return the total count of all "Reg" jobs somewhere on worksheet...
    See more | Go to post

  • crystalgal
    started a topic Access: Multi person Entry Form

    Access: Multi person Entry Form

    Hello. I am tring to create a form that multi people use perhaps at the same time to enter daily counts for their production output.
    Scenario:
    There is 10 offices. I created 10 tables named after each office.
    Within each table I have Date, Scanning Total and Printing Total

    I want each person (office) to be able to log in and enter in their daily total.

    Should I create a form that has cmd buttons...
    See more | Go to post

  • Access: How do I send data from a form using outlook

    I have a form called CSR
    The data in the form is from a query. Within the form I have the following fields:
    ProjectName, Job Status, and CSR_Deliver which is a drop down list of names.

    I want to be able to select a name from the "CSR_Delive r" list click a commandbutton and the information for that record be copied to the body of the email. Using Outlook.

    I want the "ProjectNam e" field...
    See more | Go to post

  • crystalgal
    started a topic How can I multiusers open a database (share)

    How can I multiusers open a database (share)

    I created a database that contains 2 tables and 2 forms which allow data entry. I have set the database to "share mode" for the default open.

    When I have it open and someone else tries to open it they are prompted with " file lock".

    Is there anyway for more than one person to open a database at the same time?
    See more | Go to post

  • Thank you. Your suggestion are great.
    I have a subform and a command button. When I click the "Command button" It displays the data from a query I wrote into the subform.
    Problem -- I am unable to edit the text.

    I tried using a text box to display the data from my query but the control source only list fields.
    I want to display all records from a query and be able to edit with in the text box.
    ...
    See more | Go to post

    Leave a comment:


  • How can i display the data from a query into a text box HELP

    Hello. I have form which has a text box called "text7". I want to display data from a query "ProQuery00 2".

    Please help I have tried everything.
    See more | Go to post
No activity results to display
Show More
Working...