1
  • 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:
  • 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:
  • 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:
  • 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:
  • 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:
  • 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:
  • 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 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:
  • Access 2007: Create a form for both display and data entry purposes

    How can I create a form that is autofilled with data from a query (such as a client's ID and balance), and will also be used for data entry for another field from a table not part of the query (the amount paid by the client and the current date)? I tried to use a subform for the data entry but (a)...

    Deej185 pointsBadges:
  • Access Tab Control Problem

    I had a form that was working fine. I was able to open a form by clicking on the ID in the subform using code "[Forms]![Sales Home]![ConvoQuery subform].[Form]![ConversationID]=[ConversationID]" and it would open the form I wanted.  I have however changed the form to put my subforms into tabs. Now...

    Chazzster5 pointsBadges:
  • Access 2007 Recurring Jobs

    How can I create a form that allows a user to create recurring (eg: weekly, daily, monthly) appointment/job in access 2007?

    Boyscout15 pointsBadges:
  • How to eliminate double-entry in Access

    I'm using Access as a scheduler to schedule clients for my business. Each client has a unique and customized schedule. How can I eliminate extra work for myself everytime I schedule/cancel a client. Is there an easier way to do this? Also, clients sign up online and then I enter into Access. Is...

    Sonsie5 pointsBadges:
  • Is it even possible to store calculated data in access 07

    my employer asked me to build a database to do payroll. the forms are complete, the expressions work, but the calculated fields do not store in the table like they should, such as net and gross pay. is there another way to do this? i am in serious need of help. thanx

    Agrendell5 pointsBadges:
1

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