• Calculating Exp. Dates in Microsoft Access

    I am creating a database for my boss that houses realty leases and I need to have a calculated field that will let me know 60 days before the lease expiration date.

    LaceyRae5 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:
  • What’s the best SQL Query Formatter tool?

    Hi experts, Is there any free SQL query formatter tool? I am using this free SQL Query Formatter Tool for small queries. It is very good tool. But I can not customize everything what I would like, like fonts and colours. Is there any other good free tool?

    sulica235 pointsBadges:
  • Hotel database in Access 2007

    How do I create a Hotel database in Access 2007?

    Reginaldsackey10 pointsBadges:
  • How to access database file remotely

    How should i access database file remotely in the internet? I want to connect this database file directly to internet i don't want to upload this file manually.

    muragesh5 pointsBadges:
  • MS Access split database link to MS Query

    I have a Microsoft Access database which I would like to split. I also have Excel spreadsheets with Microsoft queries set up to pull information from queries in the Access database.When I tried splitting the database my Excel queries stopped working. If I tried to link them to the front end of the...

    Angelsfear5 pointsBadges:
  • Adding a password to a SQL Server 2005 database

    We are moving our Microsoft Access database to SQL Server 2005, and the Access database has password protection. How can you add a password to a database in SQL Server 2005?

    SQL Server Ask the Experts2,585 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:
  • Find Due Date From X months in Access 2007

    I have a database that has several different training topics each that a due at different intervals. I have a date completed field [Date completed] and reoccurs every x months [recurrence] and then the next due date [due date]. How do I get my database to calculate and store the next due date?...

    Desnyder200155 pointsBadges:
  • Conversion from FileMaker Pro to Microsoft Access database

    How do you convert FileMaker Pro 7 database to an Access 2007 database file?

    Ccardona5 pointsBadges:
  • Access database file corrupt

    i am using acces database but something is happened, my database file is not working properly pls if you have any idea about this problem pls let me know or specific mail me on my e-mail id anteshwar.bhosale123@gmail.com thanks anteshwar bhosale

    192168020120 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:
  • MS Access 2007 Date Query Question

    My question is 2 parts: 1) I need to build a query that will look for dates in a date field that are >= 4 1/2 years from a date specified by the user. For example, if the user enters Sep 2011 the query would return all records in the database that are 4 1/2 years older than the specified date...

    Smidkiff55 pointsBadges:
  • Writing to multiple fields with one text box

    I am trying to find a way to get a single text box to write to multiple fields within a table. The reason I want to do this is for graphing purposes (with an outside source) and to not over crowd/complicate a form for the operators who will be using it. If this is not possible is there a way to...

    Manalyn35 pointsBadges:
  • Creating DB of stories from documents for a website

    I want to create and maintain a database for a personal library; if it works, I would like to make it available online. I know there are several already available but I’m trying to set up something specific – something for the fanfiction community. (For those not in the know, ‘fanfiction’...

    Juliearichards5 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:
  • Cumulative totals in Access 2003

    I need to be able to calculate cumulative totals on groups of data in a query. Specifically I have a list of repair order numbers with associated part numbers required, dates the order was placed and the amount of the part needed for the repair. I need to be able to calculate a running cumulative...

    Acmaintainer20 pointsBadges:
  • FAQ Database

    how do you build a FAQ database using Microsoft Access?

    Farkaska5 pointsBadges:
  • Pivot Table Error Field Message

    I have a pivot table in my spreadsheet that is linked to an access database. When clicking on the refresh data button at the top toolbar to refresh the data in my spreadsheet from the new data hitting the access database, I receive an error message stating "The Pivot Table field name is not valid....

    Buckeyes0810 pointsBadges:
  • Access Database Splitting

    I just split a database because there are multiple people using it and we started having problems with people not able to get into the database while someone else was in it. I moved all the tables to the back-end and created links to the tables in the front-end. After doing this we tested out. The...

    Randrae15 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