• Multiple numbers for the same part in Microsoft Access

    I have 3 relating part numbers for the same part with the same description. How do I enter them into an Access DB for tracking?

    vaustin5 pointsBadges:
  • Access 2007 setting up repetitive entry form

    I'm doing a database for our transportation company. How can I set up multiple expenses for multiple vehicles? How can I set up a form for data to be entered by choosing a vehicle, a month during the year, and multiple expenses on a single form?

    Net201015 pointsBadges:
  • Access 2007 creating a menu

    I have inherited an Access Database. There is a form that provides a menu for user access to the various functions such as adding, changing records and various reports. Originally the users would only see this menu form. I modified the form and now they see Access and all the various Access...

    LeChat80 pointsBadges:
  • How to make Access 2007 database GUI

    I need help. I have created a small database, now my problem is I would like to build it in a more software-like interface. No more tools or any options of some sort from MS Access to display but only the navigation form which I designed. Is there any developer tools required? Thank you in advance!...

    Curiousnoob15 pointsBadges:
  • Replace data in a text file using Access 2007

    I need to replace data in a fixed length text file where the line number and position is always the same. Can anyone offer advice on this? Thanks in advance!

    rikkos12310 pointsBadges:
  • Access 2007 database query question

    I have imported a 2007 excle spread sheet. There are mutible columns that have date information. I need two types of gueries. First query to look at one column and only list records that have todays date, previous dates and dates through 7 days in the future. the query also need to reference a 2nd...

    JHartley10 pointsBadges:
  • Increasing text in Access 2007 without losing info

    I have formatted an Access Form with four inserts for text as each were limited to 50 characters at the time, this works but is tedious as some of my input is over 50 characters and breaks up my text to the next insert what I am looking for is to encrease my text characters as much as possible for...

    PeterQ10 pointsBadges:
  • Access 2007 button addition

    Hello I have what I assume to be an easy question that hopefully someone can help me out on. I have a form that I need to add a button to that will pop up a box that you can write a description in. It needs to be different for each record that comes up in the original form. Does anyone know how to...

    Jdusaf5 pointsBadges:
  • Password in Delete Button in MS Access 2007

    How to set a password in command button "Delete" in microsoft office access 2007 ?, that the only thing we need for our defense, please help me .. thank you !! :)

    Tipsdawn10 pointsBadges:
  • Hyperlinks in forms sent from Access 2007 to Sharepoint 2007

    Hi, I send files from Access 2007 to Sharepoint 2007 daily. The first column of data in the Access file is a hyperlink, and appears as one(htt:.....). When I send the file to our Sharepoint sight I would like it to appear as an image of our logo in that field, instead of the url. The link is the...

    Carystand15 pointsBadges:
  • Multiple user login in one Access 2007 database

    I found a lot of answers how to make a multiuser login but when count of users is known. I want to put all my users and passwords in one table and search for them. For example (I am admin with full access. I want to add a new user and give him different access. So I'll put a new record in my...

    Johnnyt05 pointsBadges:
  • Progressive Incident ID number in Access 2007

    I have a db that records each security infraction at a library. The desired ID number for it is year/month/day/number of event that particular day (example, 2010/12/01-1 for the first event, 2010/12/01-2 for the second, etc.) My question: I have this -- 0000/00/00-0;_;;_ -- as the format for people...

    Markcwrite5 pointsBadges:
  • Putting object description in Access 2007 navigation panel

    how do i get the object desc. to show in the navigation panel?

    Rdd111115 pointsBadges:
  • Creating Automatic Notifications in Access 2007

    I am building a volunteer database. I have a table tracking hours that each volunteer has put in, and would like to be notified when they reach certain milestones, (eg, 25 hours, 50 hours, 100 hours), so that we know who to thank appropriately. I believe that I will need a query totaling the hours...

    MeowGina10 pointsBadges:
  • Green Boxes in Access 2007 form after deleting O’s & 1′s from database

    I have a database tracking the information turned in on a hard copy form. If a patient triggers specific questions the data must be input: so if someone triggers the depression, I in their suicide rating, treatment plan, etc... I have the access form use check boxes but the data base use -1's. I...

    ARickert20 pointsBadges:
  • Access 2007 database design question

    I am designing a database for our transportation company and want to track per vehicle expenses, ie gas, repairs, license fees, etc

    Net201015 pointsBadges:
  • Multiple identical relationships in one Access 2007 table

    I am building a volunteer contact management database. I have a table titled “Volunteers” that contains contact information fields and links to other databases with information about hours accrued. The Primary Key in this table is “VolunteerID”. I want to somehow be able to associate...

    MeowGina10 pointsBadges:
  • MS Access 2007 IIF expression

    I have multiple court dates tied to a client. I have a query created to pull the records. Right now, it's pulling all records with all court dates that is greater than today's date. I want the report to show just the next court date for each client. Is there an expression can I use to show only the...

    BaMbI0530 pointsBadges:
  • Look up values from a table that refers to a range of records in Access 2007

    My company is converting the account codes and I am verifying that each code has been assigned a new one. I was given 2 tables: 1 with current account codes, and the other provides the new code by range of current account codes. For example, if the current code is 1225, the conversion table would...

    Fs735 pointsBadges:
  • Access 2007 printing

    I am trying to print a small card we call a buy card. I recieve an error The Printout action was canceled. I can print normal size paper fine.

    Mastermix5 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