• Database deletion

    How do I delete a database from Access 2007?

    plasma15 pointsBadges:
  • Linking tables in databases that change each month

    The test software that we use, creates a new database each month. So you have to relink the tables you use to the newly named database each month to get the new information. Is there some code that I can put into my database that will go out and relink these tables?

    cyberGirl19665 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:
  • Security

    Can someone tell me how you handle user security since it is no longer available in Access 2007 or 2012. I have a database that I need to pick and choose who can edit certain forms.

    bgharrod5 pointsBadges:
  • Access Find the previous checkout record and add a return time

    I am setting up a database in Access 2007 to track equipment that is checked out and returned everyday several times a day. I have the checkout and return times working, but I need the Returns form which only has a text (to enter the equipment ID) to look up the last matching equipment ID record...

    TeaBone5 pointsBadges:
  • Access 2007

    I have a database that is supposed to generate the min, max & ave for two different sets of numbers. I have it actually working, but only up to a certain date of figures, I have no idea why these fields do not update when I enter new data. Please help

    3009196420 pointsBadges:
  • Creating a form in Access 2007

    i have a customer table with the following fields : name code : this should be generated automatically domestic export I want to create a form to add, edit, delete and view the records. when a new record is added, the user has to choose between domestic and export (option group), and based on the...

    agarwal12310 pointsBadges:
  • Report design Access 2010 / 2007

    I do not know how to design a report that will display the data the way I need. It is hard to describe here, but I will try with a simple example. Each record is based on a date. On each date there are entries to 0-200 accounts for various $$ amounts. IE: on 1/1/12. acct 120100 for $5, acct 120202...

    gc4evr5 pointsBadges:
  • Extra Page Printing

    When I print a form I select a record but it gives me an extra page with part of the header printed with it.

    Phagerman45 pointsBadges:
  • Microsoft Access 2007 – Code for connecting two related forms, bringing up same record?

    :sigh: My database suddenly requires me to have my forms appear as read-only's (since my employees are too stupid to NOT going flailing around, typing madly for no reason). However, we still need to be able to edit the information. I've created a second form, mirroring the original, to be my edit...

    Abaumeister25 pointsBadges:
  • Access 2007 type mismatch

    Why is Access 2007 macro getting type mismatch error message for a simple macro to pop-up a message box when a form field is left blank upon exiting the field?

    Floridaboy5 pointsBadges:
  • How to refresh page when leaving the field

    In my form I have a calculated field, this field is based on two other fields in the table. The field updates only when I page up or down or manually refresh. How can I get it to refresh once the other two fields are populated?

    RKJohn95 pointsBadges:
  • linking data

    I need to enter the same "data" in two forms how can I enter it just once

    B78nov5 pointsBadges:
  • Generate automatic report number in Access 2007

    I'm creating a db to track reports for my organization in Access 2007.  We have a unique report numbering system.  For example, a report number would be GR-50-12-002, where GR and 50 are constants, 12 is the year, and 002 is the second report issued that year.  I want to create a form to add new...

    DomDOJ5 pointsBadges:
  • Link Access automated form to separate outlook mailbox

    I want to email a form from access to 5,000+ indiviudals. This form contains sensitive data so I want to encrypt an outlook mailbox (we'll call it mailbox B) for the purpose of this correspondance. The outlook mailbox is separate from my personal mailbox (mailbox A). The problem I'm having is that...

    KNK5 pointsBadges:
  • Access Filtering

    I have a database which has multiple Product fields ( Prod Name, Prod Name 1, Prod Name 2, Prod Name 4). It is set up this way because one customer can order more than one product up to about four. The products are listed by number and the users can enter a product number into each of the fields,...

    Mwpv145 pointsBadges:
  • Record Locking in Access 2007

    How can I lock records in a simple Access database after updates? And, how do I set up the user interface to include only the form I would like for the user to complete?

    SJohnso35 pointsBadges:
  • I would like to know all the commands fired by all my users using command line, is it possible.?

    I keep a track of all my users when they login and logout, i have very few interactive users on my system who use command line. I would like to know all the commands fired by all my users using command line, is it possible.? This is required from an audit perspective.

    JohnsonMumbai1,160 pointsBadges:
  • Access 2007 – Controlling Master ID when launching detail form from master form

    Hello, I have a master table, and a detail table. (One master record to many detail records, and an ID number that links them.) I have a form that shows the master record data, with a button that launches a form that shows the detail records for that master record. (Where condition ="[Master ID]="...

    KAnneAxcesDev5 pointsBadges:
  • Access 2007: VB Code for making a Select all Option

    Currently running an Access 2007 database for tracking forms used in multiple States trying to add a Select all button instead of having to go through and select each individual state (the States are populated from a different table and in a drop down multiple selection window)

    RustyAMcM15 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