• Query that uses input data from another form

    OK..I need to query a data form that is set to extract data from one table, but I have other fields on the same form that needs to extract data from another table. I have a query that I intend to use to reference the data I need...but my question is what is the syntax to make this happen. Here is...

    DaChosenOne5 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:
  • Can’t change Navigation Button Caption for subform

    I'm following the instructions in the New Perspectives Comprehensive Access 2007 and can't seem to get the Navigation Button caption to appear in the window when I use the Form selector and select the subform. Any ideas?

    Bets5 pointsBadges:
  • Error message stating that the value is too long for the field.

    I entered the last name of one of my students and received an error message. What is my next step(s)?

    C131315 pointsBadges:
  • Access form to link to Google Maps

    I have like a form to put all the custome address I want like a bouttom to click then it opens a google maps with the customer address from the place I set prevoiusly for example A: My address (1901 Northwest Expressway Oklahoma City, OK 73118) B: customer Address which is from the Data base

    Agma1020 pointsBadges:
  • How to delete a database – MS Access 2007

    I am using MS Access 2007 and I thought that I had managed to delete a database, but every time I open MS Access 2007 the database is still showing in the Recent Database list. Is there a way that I remove all traces of that database and stop it from showing in that list?

    NLC30 pointsBadges:
  • Which methodology (SDLC, Software Development Method) is best to use for a Census Management System I’m creating?

    I am doing my IT project for my final year (Bsc, Computer Science), Which methodology (SDLC, Software Development Method) is best to use for a Census Management  System I'm creating?

    Mahjong30 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:
  • Setting up a field to store .png file in Access 2007 Database so that it can be merged with Word document

    I have an Access 2007 database that includes a company logo( .png file) field.  I have set up the field as an "attachement" data type and I have also tried OLE data type.  The problem is that when I use the database as part of a merge with a Word document, the logo does not display.  Only the...

    TDrotos5 pointsBadges:
  • Access 2007 User Permissions

    I have administrator permissions on a PC based database. I would like to add users and give them various levels of permissions. The bottom line is I do not want users to be able to change the design of database, including forms. I am just a touch above novelist so need real specific guidance.

    JaneCountryman5 pointsBadges:
  • Recurring data

    Can I insert a command that allows a user to create recurring (eg: weekly, daily, monthly) jobs? I am using Access 2007.

    Shazzie70 pointsBadges:
  • Search for Records Containing Word(s) in Textbox

    How can I bring up records from a table, by using a query, that contain words that are entered into a textbox on a form? I can only get it to work if I enter in the specific word(s) into the field criteria in design view, which is not what I want.

    Fechn5 pointsBadges:
  • Repeating Data

    Can I create something in a form in Access 2007 that allows a user to make a recurring job?  I have created a database for a Waste Management company.  I created two tables.  The first one is the date table containing the date the customer calls in for a skip or a sewage collection or a water...

    Shazzie70 pointsBadges:
  • Date fields in Microsoft Access 2007 when mail merged into a letter etc, become American. ie 5/18/2010 instead of 18/5/10

    Can anyone advise me how to correct this.  I have tried changing the format in MS Access to medium (18-May-10) and it still doesnt come through correctly.

    Sue195 pointsBadges:
  • Calculate Business Hours

    I found a VBA code that fits the program I'm trying to create but I'm having a difficult time locating the 12-1 lunch break so I can make it straight time. Listed below is the code. Function CalculateDownTime(StartTime As Date, EndTime As Date) As Double Dim Result As Double, EndDay As Date Result...

    Bostic8620 pointsBadges:
  • Visual Basic question

    I made a database and to get around security issues. I made forms that will open when someone opens the database. I want to build a visual basic code to look for the computer name and based off the computer name a form will  open. I have the forms made and the table to put the computer names and a...

    Dwander5 pointsBadges:
  • Windows 7 Access 2007 SBS 2003 Problem

    Windows 7 client is set up on SBS 2003 and can access files, etc. An Access 07 back end database is stored on the server with an Access 07 database front end on the client machine. With tables linked, the back end does not operate correctly and VBA code in the front end does not work. The same back...

    Piscator5 pointsBadges:
  • using if in access 2007

    i have 2 schedule on we call it patient and it have in side it gender (male or female), and the author schedule we call it patient problem and it have (pregnant,not pregnant,not female), i wont wen we chose male automatically in author schedule chose not female. thanks for you help

    Samref15 pointsBadges:
  • Creating a database in Access 2007

    I am not an expert on Access; however, as a student in college my professor commented that my Microsoft Database was built from a table. Can someone tell me what does that mean? And do your templates build from a table? I guess I really want to know how to prevent a template from building a...

    Need2Know2BSure5 pointsBadges:
  • Access 2007 filters

    when i use the filter option and then go to advanced filter to save as a query. It is a ligth gray color and i cant click on save qurey. So i cant save any filters.

    Davobeau5610 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