• 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:
  • Create a form/subform in Access 2007 that displays multiple records to be updated.

    I have an Access 2007 database that has 2 tables: 1st table is the Employee table that contains Employee ID, Employee Name, and the Location code they work at. 2nd table is the Work Log table that contains the Employee ID, date they worked, and 2 yes/no fields for paperwork received and paperwork...

    mjp126215 pointsBadges:
  • Hotel database in Access 2007

    How do I create a Hotel database in Access 2007?

    Reginaldsackey10 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:
  • Query by character length in Access 2007

    I want to see all the records with 3 or less characters in a specific field. My field contains both text and numbers. How can I do this?

    Skb195510 pointsBadges:
  • Create Button to Open Specific Form

    I have a continuous subform. I have added a command button beside each record on the subform to open another form, which is specific to that record. Every time I use the control wizard to make the button, the record I want is not opened. My relationship is Continuous ID to Button Number. I am not...

    a2rose2l5 pointsBadges:
  • Problem with relating multiple tables

    access 2010 i'm not getting a good answer on my question on this form, i place the link here so i don't need to explane it againLink to forum

    Kwantakosta20 pointsBadges:
  • Tie Access Query results to Form Entry

    I am attempting to run a calculation based on the numerical values entered into the form. The end result would be to include the numerical value entered into the form as an item in a query equation calculation. Any help you can provide is greatly appreciated.

    LostinAccess5 pointsBadges:
  • Access 2007: VB code to make a button press link to a specific record in another form

    The database is for a set of components. One of my forms shows details about each component on a separate record (the property "Default View" is Single Form). The other form is a list of all components by component number displayed all together (the property "Default View" is Continuous Forms). The...

    VinDibo5 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:
  • How can I export from Notes to MS Access and have links function within Access taking you back to a Notes data page?

    How can I export from Notes to MS Access and have links function within Access taking you back to a Notes data page? Copying as Table from Notes creates the links and it works when pasted to Excel or Word...but not Access. Importing to Access from the working Excel file then breaks the hyperlink in...

    Rakmup55 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:
  • 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 setting up repetitive entry form

    I'm doing a database for our transportation company. I need help with setting up expenses for multiple vehicles. We want to be able to enter for reporting monthly gas, repairs, license, etc.. Want to be able to enter 50 gas receipts for one vehicle a few times a month. Reports will be monthly with...

    Net201015 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:
  • 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:
  • How to use the data from other table into the main table in Access 2003 and 2007

    I'm trying to use data from other tables to make a sum and then display the result in a "Total" text. For example: I have in table1 3 qty's, in table2 2 qty's and in table3 5 qty's. I want to sum all those qty's and display them into the Main Form. I use MS Access 03 and 07

    Eddy20 pointsBadges:
  • How to enter a field with number increments in Access 2007

    How to increment a number field adding 3 with the number from the same field of the previous record. (like entering next invoice number)

    SatbirBlog15 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