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...
User Profile
Collapse
-
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... -
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... -
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? -
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.
... -
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.
No activity results to display
Show More
Leave a comment: