• 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:
  • Access 2007 database reports

    I am converting our Access Database to a new fiscal year and have an encumbrance report that is supposed to start picking up services starting 7/1/2014 and it is calculating from the beginning of the placement, ie before 7/1/14 not after. The other report with the same formula is working fine. I...

    ci05215 pointsBadges:
  • Sum using SQL

    What I want to do is the following: Name_Patient......... amount........ xxxx aaa................................500.................500 bbb...............................500...................500 aaa................................500..................1000 I want to make the field named xxx to...

    mohammedwagihe5 pointsBadges:
  • Creating an Access 2007 query with results similiar to a Crosstab query

    I am new to Access and I have an Access 2007 database that has a table that has the following fields: Employee Name, Date Worked, Yes/No for Paperwork Received and Yes/No for Paperwork Returned. Is it possible to create a query that I can run a report off of that will show one row for each...

    mjp126215 pointsBadges:
  • Creating a report in Access 2007

    I have a table in an Access 2007 database that contains the following fields: Emp. Name, Date Worked, a Yes/No field showing Paperwork received and a Yes/No field showing Paperwork Returned. I am trying to create a report that will be run for a selected month that has each day of the month as a...

    mjp126215 pointsBadges:
  • Microsoft Access: ACCDE and ACCDB

    what does the word ACCDE and ACCDB stand for?

    Humphrey25 pointsBadges:
  • Hotel database in Access 2007

    How do I create a Hotel database in Access 2007?

    Reginaldsackey10 pointsBadges:
  • Print 2 A5 sheets on one A4 sheet in Access 2007

    I want to print 2 A5 sheets(the same content,printing two copies) on one A4 sheet in the Access 2007.if you have any solutions, please contact with me.mail: 7924168235@163.commany thanks in advance

    lengpaton5 pointsBadges:
  • Handling Record Update Collisions

    I have a split database. A form on the front end allows users to input their updates and then press a "Save" button to send their updates to the back end database. If two users simultaneously try to update the same record, one will connect, lock the record, and the change is committed. The other...

    MarvinM8050 pointsBadges:
  • Forms in Access 2007

    I am using a form to upload data from the form into a database. I have a submit button on my form that upon clicking, needs to input all the users data into the correct slots in the database but I have no clue on how to do this, or where to get started. How should I go about solving this problem?

    Jenkinac40 pointsBadges:
  • Access 2007 invalid procedure call or argument (runapp)

    Hi. We have a proprietary Access Database/program that a former employee created for us. We have no knowledge of how to fix it, most of the time it still works just fine.  A user in our office gets the error in the subject when he tries to run it. It worked fine up until a few days ago and I have...

    Longshot95 pointsBadges:
  • VB6 App with hardcoded SQL to access a Access 2007 DB

    Hi Team, I have a query that I run successfully in native SQL within Access 2007 but if I use this code within VB6 it seems as though it is not using the "From" & "To" dates. It does return values but it amounts to the complete database totals. The extra code added to the production code was...

    Witsend5 pointsBadges:
  • Making a POS form for a pharmacy program

    I need to make a POS frame for a pharmacy automation program am working on. >need to add data from a field in access in which it searches while I type. >when I select the name, the data from the access corresponding the name selected should be added in my flexgrid list and should be asked to...

    josewan5 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:
  • How to use lookup query to return only entries matching the related field of active record

    I'm creating a lookup field and would like to list only those items relevant to the record actively using the lookup. So my DB has two tables one using the lookup which as a child ID field that I'd like to match with the parent ID field of another table.

    YesMayhem5 pointsBadges:
  • MS Access 2007 mass email list?

    I was wondering is there a way to create a mass email from a query or table that would send out in MS Outlook? I know of a way of extracting a table and importing it into Outlook but my boss wants a more efficient way.

    Itguy1509220 pointsBadges:
  • Help Creating a Training Record Database

    We have an employee database that the managers want to use to track mandatory and option training. We already have an employee table, and I added two more. tblEmployee   (EmpID,EmpName,EmpProgram,EmpStatus,HireDate)  Has the basic employee information tblCourse      ...

    RaeLyn10 pointsBadges:
  • Need to modify an existing form in Access 2007

    I have just migrated to Access 2007 from previous versions. How do you bring up a window that displays all the objects in the database and then select one for modification. I have been able to modify tables and queries but cannot work out how to modify existing forms or reports.

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

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