• Automatically generating info into fields

    I am working on a databaase in 07 and i have a drop down field with peoples names and i want to when i select their name the next field to automatically generate their phone number. is this possible?

    Sunset3115 pointsBadges:
  • Microsoft Access database update question

    So I have two Access databases that are linked together so that tables on one of the database can be updated offline but can update the main one when needed. I have ran into an issue though where my table isn't recognizing the linked data from the other tables that it needs to. For this database it...

    Tgoody30 pointsBadges:
  • My DTS package runs normally, but hangs when run as a SQL Job

    Hi, I'm trying to run an Ms Access .mbd file through a MS SQL 2003 Server. The package runs normally and works when I start the job, but simply hangs when I run the package as a a scheduled job. I've designed a DTS local package as follows:...

    Dring575 pointsBadges:
  • Access Database update question

    So I have two Access databases that are linked together so that tables on one of the database can be updated offline but can update the main one when needed. I have ran into an issue though where my table isn't recognizing the linked data from the other tables that it needs to. For this database it...

    Tgoody30 pointsBadges:
  • Create a report with only results with specific entry in field

    Very simple question - sorry. How do I create a report where only the entries where a field has a specific answer. Such as only the results whose tick box is ticked, or who's "category" field is a certain category?

    Sleepybird5 pointsBadges:
  • adding hyperlink

    I have created columns in the query for links to pdf files. Each one belongs to an employee. My question is how do I create the link to showup on the form for each employee? The links belong to certain employees while others have no link. I am currently running Access 2000.

    Sunshine07660 pointsBadges:
  • Access 2007 table versus forms

    I use Access for contact mgmt. database. I have my "main" table that has all my client info. If I create a form (looks like spreadsheet) and it is populated by the names in the table and I need to delete names from the FORM, not the original table, does it delete also from the main table?

    Gpl5 pointsBadges:
  • AS/400 data to Microsoft Access database

    In my business, I use an MS Access database to monitor inventory of my client and encode similar data to my client's AS400 system. I am asked by my client to simplify my job by encoding only in AS400 and have the data transferred to my Access database automatically to whatever method is possible....

    JEV5 pointsBadges:
  • linking report to form by macro

    I have a report that various info including name is pulled off of a form. i want to be able to click on the name in the report and have it bring up that particular record in the form. i can click on the name and it brings up the first record, but i want it to go to the specific record that matches...

    Mjward755 pointsBadges:
  • creating reports with forms/subforms

    I have created a report that is linked to the form. When I click the preview command button it asks for Emp. ID I enter in the ID Number and click ok. The print preview screen shows up with nothing on it. How can I get the data to show up on the report? and when I create complete report how can I...

    Sunshine07660 pointsBadges:
  • Change year range on ActiveX calendar on Access form

    Hi. I want to change the year range on the calendar in microsoft access. At the moment it goes from 1900 to 2100. really annoying! I have the ActiveX Calendar 11.0 version. On the microsoft website it says to add the code: StartDateCalendar.Year = 2001 but how do you do this? the only other thing...

    Dontgetit105 pointsBadges:
  • Make Table query Produces different result than same select query

    In MS Access what would cause a make table query to produces differnet results than same query as a select query

    Donjuanc5 pointsBadges:
  • Autopopulating following fields

    I have created my first Access database form, and now when I enter data into some fields, it autopopulates the three following fields. If I enter data in one of the following fields, it changes all of the other fields. It seems that my fields are all connected to the same row in my tables. How can...

    Dknielson5 pointsBadges:
  • VB6: Getting List of records from one field of Microsoft Access Table in ComboBox

    VB6: Dear sir, For the following code I am getting "Run-time error'3265': Item cannot be found in the collection corresponding to the request name or ordinal." However, I already connected Adodc1 to my database from where I want the data. Actually, what Im trying to do is, just to get record list...

    ScorpionEyes45 pointsBadges:
  • AccessDataSource and ‘?’ parameters asp.net

    I have been stuck on something for days and wondering if anyone can offer any help. I am using an Access Database, so i am using the accessDataSource in asp.net I drag and drop an accessdatasource on the form, and also a datagrid. This is a simple datafile with 2 fields. An ID and an EmailAddress....

    OrangeMiro20 pointsBadges:
  • Trying to learn – How to filter dates…

    I have a DB that lists a date in each column, so that when I run a simple query I can pull up only the dates that I need. I have tried (filtering by exculding dates not needed) but now my DB is too big to spend the time going through each date, to only get current dates needed. I need to know a way...

    Beginner095 pointsBadges:
  • front end tools

    My company is in the process of building out a DW. Although there has been many discussion topics within the individual end users, the one area of conflict is on what front end tool to use. More specifically, we have some expert users who want to directly access the DW and others who are ok with...

    AJB1005 pointsBadges:
  • Date a specific record in Microsoft Access

    I have a database where I would like to specifically date a record when a value/change is made in one of the fields of the record. Specifically, my database has addresses for donation solicitation, and I wish to date a donation made by a receipient at a particular address. So, basically, if I...

    Sfd41065 pointsBadges:
  • Microsoft Access 1997 emailing

    "I have a business that currently is set up on Access 1997. We have an option that allows staff to email directly off this data base to our customers. However this is only in an HTML format. I would like to change this to a PDF format. So essentially I am looking to change the way I am emailing my...

    BJV10 pointsBadges:
  • Microsoft Access Report “Specific Printer”

    Cannot get MS Access reports to let go of default printer. Selection of "Specific Printer" in page setup does not get saved. Also set .UseDefaultPrinter=False in code but it goes back to true no matter what. Have also tried every conceivable means of setting properties of both application.printer...

    Feldmrob5 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