Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Wanet Telecoms Ltd on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. jvhazelbaker

    Using Access Forms With Web Page

    I am looking for a web development tool that allows me to use the same basic layout as used in programs I have created in Access. I have researched Dreamweaver and other such programs and have not found anything that allows the use of combo boxes or provides the ability to link data between main...
  2. jvhazelbaker

    Code to Open Document in Word

    I am trying to run a Word document when clicking a button on an Access form. The code I am using is: ________________________________________________________ Private Sub Command16_Click() Dim LWordDoc As String Dim oApp As Object 'Path to the word document LWordDoc =...
  3. jvhazelbaker

    Access Working with Outlook

    I'm trying to export tasks from Outlook into Access as well as import tasks from Access to Outlook. This will be used via a network by at least 100 different users. Any ideas on how this can be done?
  4. jvhazelbaker

    Date Issue

    I am trying to figure out a net bushel weight per silo per date taking into account usage and new receipts. So, this is what I'm doing. First Query: Figures bushel weight per silo per day net weight: =([gross wt]-[empty wt]/56) Second Query: Figures actual bushel usage per silo Third...
  5. jvhazelbaker

    Formula to exclude selection from average

    I'm trying to average a group of numbers in a field named [your priority number]. The form is in database view. The form includes the following fields: Your Name Role Your Priority Number Which in form view could look like this: Your Name Role Your Priority Number Jaime...
  6. jvhazelbaker

    Update tasks in Outlook from Access table and vice versa

    I have a table for tasks in my database. When a user updates this table, I want the information to be imported to Outlook Tasks. And in reverse, when Outlook tasks is updated, I want the information exported to the table in the database. I have linked the tables, but the information entered...
  7. jvhazelbaker

    Calculating Subform Field on Main Form

    Main form name = Review and Edit Staffing on a Project Subform name = Priority Data Table Subform1 Field to sum = Your Priority Number The field to sum is on the subform formatted as a datasheet. I have placed a textbox on the main form and below is the formula I have used that is resulting...
  8. jvhazelbaker

    Report Hiding Behind Form

    I have a form with several buttons. When a button is clicked, the report print preview should appear, and it does, but it hides behind the form so the only way to view it is to close the form; the form must stay open. How can I get the report to move to the front without minimizing the form or...
  9. jvhazelbaker

    Automate printing according to date specifications

    I need a report to print according to the day of the week. So when a certain activity occurs on a Monday, Access pulls all activity reports associated with that day and prints them off automatically. Can this be done?
  10. jvhazelbaker

    Too many arguments in expression

    Here is the breakdown: I have an event taking place. The user wants to see where in the process we are with the event. The only way to monitor this is by what completion dates have or have not been entered. I have the following date fields in as many different tables. [Sample Dispatch Date]...
  11. jvhazelbaker

    Sub-Sub-Subform Requery

    I am having a problem with the requery feature yet again. Please let me know if you can help. Main form = Barrel Purchase Order Query Form Subform = Brand Event Table2 Form Sub-Subform = Barrel Pick Form Sub-Sub-Subform = Size and Case Detail Field to be required = Full Brand...

Part and Inventory Search

Back
Top