Search results

  1. P

    Problem Adding Record to Form in Access 2007

    In my FE-BE database, I have a form named frmMain with record source a table named “Projects”. The key field for “Projects” is ProjectID. On frmMain there are a number of tabbed pages. One of these pages is named “Environmental Document Review”. On this page there is a subform named...
  2. P

    Suspected Problem With Windows 7 Vs Windows XP

    Our office has a FE/BE MS Access 2007 Project Tracking database system. Each user has their own copy of the FE database on their C-drive. We are currently going through an upgrade to our operating systems from Windows XP to Windows 7. Whenever a user with a Windows 7 OS opens Project Tracking...
  3. P

    Sending Automatic EMail Reminders from Microsoft Access 2007

    I have a table (tblTasks) with a number of fields in it, some of which are “AssignedTo” and “DueDate”. AssignedTo is a LookUp field that comes from the table tblPersonnelList.LastName. I need to add a feature in my database that will automatically send email alerts to the “AssignedTo” person...
  4. P

    Creating Form To Search Selected Field In Table, Access 2007

    I have a form which displays open action items (frmTaskListOpen). On this form is a Search button which when pressed opens another form (frmSearch). On this form, the user can select a field to search on and the search criteria. The idea is for the user to be able to perform a search on select...
  5. P

    Inserting OLE Object in Table via Form

    I have a field in a form where users go to insert an OLE Object via the right mouse button. The data type in the table is OLE Object. Prior to converting our 2003 database to 2007, this feature worked just fine using the right mouse button to select the particular file in question. Access 2007...
  6. P

    Importing into a database with prior relationships

    I am trying to import an Excel file to a temporary table (tblARRAProjects) in Access and then use an append query to append the applicable information to the existing table (tblProjects). Two of the fields in tblProjects (District and Route) that will be 'appended to' are lookup fields that get...
  7. P

    Grouping Data in a Report by Fiscal Year

    I want to Group data in a report by Fiscal Year (for example, FY05 = 1 Oct 04 - 30 Sep 05, etc.). The Date field in my report is ProjectBeginDate which is currently formatted as a Short date (for example - 08/24/05). Can anyone out there tell me how to do that? Thanks in advance for any help.
  8. P

    Restricting Users from Accessing Only the Updater-Launcher

    My database has a front and back end. To get into the system, the user double-clicks on the icon for an Updater-Launcher that checks the master front end for new versions of forms, queries, reports, etc., before going into the database. The front and back ends are both on our LAN, but just in...
  9. P

    Opening Report Associated with Particular Number on Form

    The Record Source for the form called frmConstructionProjects is the query called qryConstructionProjects. On the form, there is a command button called "Go To DBE Form". The On Click Event Procedure for the command button opens the form frmDBE. The form opens to the same record associated with...
  10. P

    Assigning Workgroups via Code

    I have a special Workgroup Information File (ProjectsWIF.mdw) for the database I administer. The path for ProjectsWIF.mdw is W:\FINAL\ProjTrack\WIF\ProjectWIF.mdw. The database resides on a server on our LAN. However, MS Access is loaded on the individual user PCs. The current path for the...
  11. P

    Coverting Text Field to Combo Box Field Without Losing Data

    I have a text field in table A where I enter County names. I want to convert that field to a combo box where I look up the County names in table B. However, I don't want to loose the County data I have already loaded in table A in the process. Can someone advise me on how to do that, if it's...
Back
Top Bottom