• How to link to different tables based on an index in the first table in Microsoft Access 2010?

    I am setting up a database of photos and fine art prints made from those photos. I have a table that lists each photo and its related data. Each photo can then have a number of prints made from it (each one can be different size, material etc.) They should each be numbered individually and...

    agelidis5 pointsBadges:
  • Database Management using Microsoft Access 2010

    Hello, I am currently a year 13 student in New Zealand studying level 3 DIT. Currently we are working on a database management internal assessment and it would be great to get a bit of information on database design and management so that I can make my own successful and professional database using...

    mariaoakey5 pointsBadges:
  • Date function in Microsoft Access 2010

    I want to create a database that has 20 different training topics and all have different due dates (ex 30days, 25 days). I want to create something that assigns the date to a student then calculates a due date according to what topic I assigned. Can anyone help with this? Also I would like to run a...

    gotcha2bite5 pointsBadges:
  • Help with relationships in Microsoft Access 2010

    I am office manager in a service company that installs internet. A customer orders internet from the store, the store places the order and equipment is sent out for that job. There is a cantenna serial number, and IMEI and a router serial number that is unique to each order. There is also an order...

    AmWireLa35 pointsBadges:
  • Creating tabbed forms with data from different tables in Microsoft Access

    Hi! I'm a beginner on Access. I'm designing a database for school management system. I have a tables; Student Information, Math, Physics, Chemistry, Biology..... I want to create a form with student information then have 7 tabs for subjects information.

    Pegsoonline5 pointsBadges:
  • Access Database

    Access Database Question. I have two databases: Company and project. I want to be able to input a primary and secondary description of the work at the project level that is saved at the project level, but also adds to the company database (if that primary and/or secondary description hasn't already...

    bruceinpl5 pointsBadges:
  • Link Query to Report on Access 2010

    In an existing database, I have copied an existing query and an existing report so my new report will be in the same format as existing reports. I changed the criteria on the query so that it is pulling only the information I need. Now I need to link the two so the report will pull just that...

    LindaJenkins5 pointsBadges:
  • MS Access Functionality Problem

    I have a table with an associated form listing all of our raw materials that we have in house (sometimes multiple lots of materials). I have a table with an associated form defining the components (raw materials) of all of our products I have a “Build” table with which we would use a form to...

    BrianMCSE5 pointsBadges:
  • Access 2007 database errors when using Access 2010

    I have a database built with Access 2007. Some of our customers are upgraded to Access 2010 and cannot open the database anymore. Error is "The expression On Timer you entered as the event property setting produced the following error: Object or class does not support the set of events". Anyone...

    Browntr15 pointsBadges:
  • Output Microsoft Access Report as PDF WITHOUT borders (around the edges of the page)

    In PowerPoint, if i save the presentation as a PDF, it does so without annoying white borders around the outside of the page. In Access, I cannot reduce the borders to 0, or seemingly do anything else to output a report as PDF without at least a 0.166" white border around the page. I want to output...

    cvandenburg5 pointsBadges:
  • Date functions

    What is wrong with this function:=DateAdd('d','20',[REFERRAL]) I am adding 20 days to the Input date "Referral date" label . The message I get back when I save is that it cannot find REFERRAL? This function is in the Default Value for the date I want to change (Audit Date)

    HELPTECH10 pointsBadges:
  • Upgrade from Access 97 to Access 2010

    Hi All, I have a client requirement to upgrade our existing application which is developed on Access 97 and running on Win Xp to Access 2010 Win 7. The Access 97 database has file like .MDB, .MDE and .MDW. Can someone, please suggest a way to upgrade form Access 97 to Access 2010. This application...

    mercuryspark10 pointsBadges:
  • How to set up a simple form

    Hello! I'm very new to Access and have a question. I have a database set up and a form designed. I carrier items from an auction house, package them and ship them. I need a way to input client data and record of its progress (quoted, picked up, processed, shipped, etc). Once it has shipped, I'd...

    jlanefwbbc10 pointsBadges:
  • Using IIF statement in query to return answer

    How do I write a IFF statement to return data? I am trying to write a IIF statement to let a student know if they are approved or not approved to play a sport. Here's the statement: Status: IIF([Waiver]="Yes"]) and IIF([Academic]="Yes"), "Approved", "Not Approved" When I do this and hit run, it...

    loggerhead79150 pointsBadges:
  • Getting data from two sources into one table

    I have a form that will add data to say mainTable. In the form, I want to get some data like last name, first name and client_number from a linked master table (using a combo box) and have that data added into mainTable . I would also like to enter data (last name, first name and client_number)...

    handlewhat5 pointsBadges:
  • Update query doesn’t update table

    This is a really basic question, but I can't seem to make it work. I have a simple table with 3 fields. StartTime EndTime ElapsedTime Each field is defined as a date/time datatype. StartTime and EndTime are manually entered. I'm trying to use the DateDiff() function in an update query to populate...

    bonesie15 pointsBadges:
  • Incrementing a key field without autonumber

    I want to use a primary key field in format AAA9999999. Can I get the numeric part of the field to automatically increment to the next number in the range?

    HNDstudent5 pointsBadges:
  • Sort data in a column, not alphabetical

    I have an Access database that sorts the data in a column alphabetical and I want it to match my Excel spreadsheet which is by area. Where do I go in the database and change it so it follows my spreadsheet?

    DAHurd25 pointsBadges:
  • Access 2010 Field Design View, how to set up for multiple names

    I am using Access 2010 and I am setting up a training database to show trainers names against various training modules. Now some of these training modules have many trainers against these modules, how do I set this up? I have made a table with the modules and now I need to put trainers names to the...

    apmitch5 pointsBadges:
  • Formatting Cells individually in a Table – Microsoft Access

    I am currently in the process of using a Table to track employee annual leave, I need to be able to highlight all the weekends (saturday and sundays) in a different color to make easier to read. How do I do this?

    azuby2420 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