• 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:
  • MS Access 2007 IIF expression

    I have multiple court dates tied to a client. I have a query created to pull the records. Right now, it's pulling all records with all court dates that is greater than today's date. I want the report to show just the next court date for each client. Is there an expression can I use to show only the...

    BaMbI0530 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:
  • VBA Access forms and 1 table

    I have an application where a start form, launches a second one and then according to text input/selection more form open (as a 3rd level form). I want all the answers to be recorded in one table as a singe record, but instead I get 3 different records, with responses from each form. What do I...

    AlienBee5 pointsBadges:
  • Access 2007 printing

    I am trying to print a small card we call a buy card. I recieve an error The Printout action was canceled. I can print normal size paper fine.

    Mastermix5 pointsBadges:
  • Trying to Design a Split Database Access 2007/SQL Server Express

    Hi, This post will be long, as I have several questions related to this project, but please feel free to only answer any piece you want, however small. Every bit of knowledge will be helpful. One of the programs at my office is in need of a database. I've been researching this for awhile, and going...

    Dataempress115 pointsBadges:
  • Expression Builder, Calculation confusion in Access 2007

    Ok I’m having trouble with this simple calculation.  I have a Query with a field called “% of fire Calls made” it may contain a number (ie 23.34). I’ve tried to create another field in the same query that ask the question, if the # in “% of fire Calls made” is equal to or greater than...

    Phil12550120 pointsBadges:
  • Visual Basic Email Script

    I have an Access Database with multiple groups. I would like to send emails containting reports to the individuals corresponding to particular groups. How can I do that?

    Dragione5 pointsBadges:
  • Outlook 2007 templates in Access

    I am trying to call an Outlook email template from Access app. and I am not sure what I am doing wrong. I can get an email to come up with TO, CC, Subject, and Message text variables when using the DoCmd.SendObject. However, I can not get the Outlook template to come up that I want to use. I have a...

    Rdd111115 pointsBadges:
  • docmd.sendobject – “FROM” variable

    I am trying to get Access to send an email from an email address, "response folder", other than mine or anyone else who might be sending an email from the database.

    Rdd111115 pointsBadges:
  • DB Table/Query Layout for Ranking System

    Hello, I'm building a Membership DB where Members can achieve certain ranks (Rank1 - Rank14). I would like to present two things: - a list of all Members with their current rank and the Date the rank was achieved - for each Member a list of their ranks and the corresponding dates of achieving them....

    Artificial15 pointsBadges:
  • In Access 2007, how do I increase the file lock capacity so I can split an existing table into smaller ones?

    In Access 2007, how do I increase the file lock capacity so I can split an existing table into smaller ones? Thanks

    Kadiddlehopper5 pointsBadges:
  • Edit a text file with VBA

    Cheers, I have large text file that needs to be edited to run a job but I would like to automate the process.  How do I open a file and replace line 132 of (which is about mid of the file) that file? Thanks, Bob

    Rjwilcox45 pointsBadges:
  • Client Loves User-Level Security, But Needs Access 2007

    Hey Guys, I have a Client for whom I have remodeled an access database. The database was initially created in Access 2003, and has been updated in 2007, though it is still in .mdb format. I showed the client a few simple user-level security options, and they worked like a charm. The only problem is...

    Washkuhnw90 pointsBadges:
  • SQL problem: Adapting code fragment

    How do I adapt the fragment of code below to show: a) Two columns - the Filipino Population and the Total Population  b) The Filipino Population as a percentage of the total population  SELECT DISTINCTROW POPDATA.CITYNUM,  COUNT(*)FROM POPDATA  WHERE POPDATA.ANCNUMBER=720  GROUP BY...

    Mentos5 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:
  • Create SQL statement in VBA Access 2007

    How can I create a select Group BY SQL statement inside a VBA module? I've ran actions queries and they seem to take an effect in my tables but I'm having a difficult time creating a Select statement. Please display a couple of samples

    Bostic8620 pointsBadges:
  • 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:

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