Search Result

Collapse
8 results in 0.0043 seconds.
Keywords
Members
Tags
access2007
  •  

  • Error: "System.Data.OleDb.OleDbException: No value given for one or more required par

    No value given for one or more required parameters.
    Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

    Exception Details: System.Data.Ole Db.OleDbExcepti on: No value given for one or more required parameters.

    Source Error:

    An unhandled exception was generated...
    See more | Go to post

  • Raven7738
    started a topic Can I write a shell code in Access 2007?

    Can I write a shell code in Access 2007?

    Hey,

    I have an autoexec macro in my program. When the frontend of the program opens up, I want the macro to run a module to check the local drive (C:) for the same program. If the program is in the C: drive, I want the open program to overwrite the original program. If not, I want it to save a new copy in the C: drive. I also would like this to happen without the user being asked where to save or what to call it.

    ...
    See more | Go to post

  • How can you run a Query using Active Directory values?

    Hey,

    So I originally had a form asking for an ID and password. A query would take those two values and pull up information in a database that contained both those values. I need to change this so that instead of a user putting in this information, the query will look up both of these values in the active directory and pull up information on the user.

    Any ideas of how I might go about this?

    I am using...
    See more | Go to post

  • Raven7738
    started a topic How to select values using a loop

    How to select values using a loop

    Hey,

    I'm using Access 2007. I have a code to open a new message in outlook 2007.

    Code:
    Private Sub btnEmail_Click()
    
    Dim ol As Outlook.Application
    Dim inbox As Folder
    Dim msg As MailItem
    Dim rcp As Recipient
    
    Set ol = CreateObject("outlook.application")
    Set inbox = ol.Session.GetDefaultFolder(olFolderInbox)
    Set msg = ol.CreateItem(olMailItem)
    ...
    See more | Go to post

  • tuxalot
    started a topic Sum lost day type by active employee

    Sum lost day type by active employee

    I've attached a screenshot to help explain what I need. If it is difficult to see the details, a larger file is located here:

    http://depositfiles.co m/files/s94abwbk2

    The Date History form (shown with a green #1) is where the user enters data. The summary data is visible in Date History subform (green #2). These data are stored in the Date History table shown at the bottom.

    I would like Lost time days...
    See more | Go to post

  • tuxalot
    started a topic Total by option group

    Total by option group

    I have a table like below as a sub-form:


    Start Date Return Date Type of Lost Days Total
    12/17/2008 12/25/2008 Lost Time Days 8
    1/1/2009 2/4/2009 Lost Time Days 34
    10/7/2008 10/15/2008 Resticted Days 8
    12/2/2008 12/17/2008 Resticted Days 15
    12/26/2008 12/30/2008 Resticted Days 4

    These are data for a single employee....
    See more | Go to post

  • tuxalot
    started a topic Checkbox on form to change query result

    Checkbox on form to change query result

    I have a checkbox on a form. When checked, I want my report query to change FirstName LastName to "Privacy Case". Report shows employee injury data with each employee representing a line on the report. Other non-privacy cases will also appear on the same report.

    Example:

    John Smith Accounting Injury data here...
    Privacy Case Engineering Injury data here...
    Sara Jones Kitchen...
    See more | Go to post

  • tuxalot
    started a topic Access 2007 Display Option Group on report

    Access 2007 Display Option Group on report

    New to Access so please go easy. I have a form with an option group. I've wish to have it's result display on my report.

    options a, b, c

    I've created a field in my table to accept the data from the form. In my table, I see 1, 2, 3 when I save a record. Good enough. Now, in my report, I wish to have checkboxes representing options a, b, and c. When opening the report, a checkmark should appear within the box corresponding...
    See more | Go to post
Working...