• Export Attachmets

    How do you export all attachments for all records from Access 2007 database?

    Angellja5 pointsBadges:
  • Access 2007 Replace operation

    In Access 2007, can a replace operation be performed using wildcard to replace a variable string with a known string.

    Gmmdm5 pointsBadges:
  • Microsoft Access query window

    I use an Access program to record student records. The program has built in queries, but when I try to start one the popup window is tiny; all you see is border, no text, no restore or exit buttons. I can't catch an edge with the mouse to enlarge it. Also, the program opens without the toolbars I...

    Masterlink5 pointsBadges:
  • Creating pop-up reminders

    I am maintaining a data baase of living documents whic require a review every 2 years. I need a reminder before the 2 year anniversary arrives. The table currently has a "Effective Date" column. Please keep in mind that I am not well versed in macros. Thanx for any help,

    Darkness5 pointsBadges:
  • Microsoft Access printing

    I had developed an application using MS Access 2003 and have no problem whether viewing or printing it in one page from my PC or Notebook. Also no problem when I opened this application in MS Access 2007 and printing it via MS Access 2007. By the way my printer is HP Laser Jet 1022. My problem is...

    Pusparaj7515 pointsBadges:
  • Creating a Form

    I'm creating a form and have an dropdown combo field on my form. (dz, each, Bag, case etc.) I want to use the dropdown on each line independantly. What ever is selected on the first line goes on all the lines. How do i get each line to have different selections based on a new line?

    Sims5 pointsBadges:
  • Modifying a module in Access 2007

    I have a database with around 40 queries. I have a module which runs all the queries using the following (abbreviated) code: Function RunQueries() On Error GoTo RunQueries_Err DoCmd.OpenQuery "Query_1", acViewNormal, acReadOnly DoCmd.Close acQuery, "Query_1" DoCmd.OpenQuery "Query_2", acViewNormal,...

    Stewartie5 pointsBadges:
  • Importing Data GAL entries into Access 2007

    Need to import outlook GAL entries into Access 2007 & have the database updated when I change a field in the GAL entry.

    AGB25 pointsBadges:
  • Access 2007 Report displaying the content of three different fields in one box?

    I am creating a report in MS Access 2007. I want to create one box that displays the content of three different fields. i.e. Salutation First Name and Last Name. I used to do this in Access 2003 this way =[Salutation] & " " & [First Name] & " " & [Last Name] but in 2007 I am getting an error. Any...

    JustDave5 pointsBadges:
  • Need Help Importing Data

    Hello, I have a relational database that was created by a former employee. The database has old data and I need to update it with current information. I have the most recent data in an Excel spreadsheet. Questions: 1. How can I get the new data into the database and maintain the relationships and...

    Bluize20 pointsBadges:
  • Can you help with the following DAO code explaining a step-by-step process?

    I’ve had some exposure to VBA and know the Access Interface very well (Microsoft Certified). I purchased MS Access 2007 Programming By Example by Julitta Korol a couple of months ago and all of the hands-on examples display the results in the Immediate window or a msgBox. Although I was able to...

    Doc3310 pointsBadges:
  • Highlight Query last executed

    How do you modify Access 2007 access options to keep last query executed highlighted?

    BluesPerson10 pointsBadges:
  • How to access and use subform data/calculations

    Access 2007 Database; Employee Info; Form:Sick Days Docking/Pay. I created a form with a subform that keeps track of Employee sick days. It transfers totals from the subform onto the main form...Then the main form does a couple calculations on those amounts...But I need to access that information...

    OBI Girl85 pointsBadges:
  • Access 07 Database to Import to Outlook 07

    Hi there, I would like to upload the database I have in Access (07) into my Outlook (07) contacts list. However I can't seem to find a way to do this. Can any help me? CC

    CC285 pointsBadges:
  • Rusty and Need Help

    I've been out of the IT Business for several years and have come out of retirement to work with a local community college on Training Grants. We collect specific pieces of data on each student that works for the company that we have the state grant for. It is becoming a nightmare to track everyone....

    Bluize20 pointsBadges:
  • How can I add Multiple Subdata Sheets to a single Table in Access 2007?

    I'm attempting to add subdata sheets that come from several different tables in my database to my master table. I have found, however, that no matter how I manipulate the different relationships I can only get one subdata sheet to work at a time. Is there anyway to link multiple tables as subdata...

    Zwoods10 pointsBadges:
  • Access 2007 form from a query

    I have an Access 2007 database that lists rules for specific types of systems. I've run the specific query to pull up the rules I need and put it in a form. The rules are un-editable and that is what I need but how do I get 1 field to be editable so the users can answer the questions posted by the...

    V-Ger5 pointsBadges:
  • Building A File Searching/ Tagging System

    Hello...I want to make something in VB (Version 9) that reads multiple data from specified file (Access 2007) and displays content in list box. If file doesn't exist, alert user. More description: My name is Steven, I'm a college student and now I'm running my practical session to complete my...

    Stevio10 pointsBadges:
  • How do I Autopopulate a few field on my my form?

    I have a database created in Access 07 and in this database I have tables, forms and reports. I have a table where I have all the Plan info and I also have a table into where the info is stored after being entered on the form. On my form I have a plan number, plan name what I want to happen is when...

    Lisarod25 pointsBadges:
  • Save Access 2007 format as 2000 format with VBA

    how can i save the curent database as a 2000 format with vba

    Dave b10 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following