• 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:
  • 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:
  • Pull up a list of the last time the person took each course set-up in the system

    I have a training database and I can easily pull up a report of all dates a person took courses but I would like to just get a report of the last time a person took each course. I do not want multiple listing of a course.

    Grainna5 pointsBadges:
  • Link RDP in Microsoft Access to click computer name to remote control

    I have build a Microsoft Access 2007 database for trouble tickets and inventory.  I have a table called INVENTORY.  One fo the fields is DEVICE NAME.  Right now it is simpy a text field.  In this field we enter the comptuer name (example COMPUTER1234) We have forms which contain the DEVICE...

    Maxwellafb35 pointsBadges:
  • Select box and enter number into hidden field

    I am trying to find a way to either have the operator click a button or a checkbox and have it enter in a set number (depending on which they select) into a hidden textbox on a form. The reason I am trying to do this is because it is how I need the data set up for another program that we are using...

    Manalyn35 pointsBadges:
  • Access 2007: VB code to make a button press link to a specific record in another form

    The database is for a set of components. One of my forms shows details about each component on a separate record (the property "Default View" is Single Form). The other form is a list of all components by component number displayed all together (the property "Default View" is Continuous Forms). The...

    VinDibo5 pointsBadges:
  • Return nth record

    I have a db where I can not change any data type (they are all text). I want to retrieve every 237th record.

    Clockwatcher25 pointsBadges:
  • Access Tab Control Problem

    I had a form that was working fine. I was able to open a form by clicking on the ID in the subform using code "[Forms]![Sales Home]![ConvoQuery subform].[Form]![ConversationID]=[ConversationID]" and it would open the form I wanted.  I have however changed the form to put my subforms into tabs. Now...

    Chazzster5 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:
  • How can I run a Microsoft Access database on a computer and the report on a TV?

    I am using Task Management Database in Microsoft Access 2007 to track Items that need to be inspected. I have found a way to connect my computer to a TV. My goal is to keep the database view up on the computer screen so my Techs can walk up to it and add trouble tickets, but have a running report...

    ValerieOneZ15 pointsBadges:
  • data copy – paste from the same table not showing in a subform

    I have an Access 2007 application for recording employee skills and competencies in a medium business. We have recently duplicated the application with a view to recording other employee skills of each employee. Normally, I would add each employees details via a form and an embedded subform,...

    Tcharlton7920 pointsBadges:
  • Dymo Printer programmatically with VB.NET

    For a project i need to get the print out in Dymo LabelWriter Duo Printer. I am facing the problem in 1. How can i make a file with extension as *.lwl or *.d1l 2. How can i pass values to the file i had made above. I am using VB.Net , VS 2005 as IDE and MS Access 2007 as backend. Any fast help is...

    Honeyprogrammer35 pointsBadges:
  • Microsoft Access 2007 starting errors, tries to setup on each staring

    I have install Microsoft Office Pro. on a computer. Everything opens up fine except for Access. When i click on access to open it wants to install not open.

    Dwgwyther25 pointsBadges:
  • Access 2007 – How to include option group on report

    Hello, I'm new to Access so please consider this when forming your response. This has been driving me crazy and I've looked high and low on the 'net for a solution. I look forward to your response. I have a form with an option group. I've wish to have this display on my report. Take for instance...

    Tuxalot5 pointsBadges:
  • Monthly Average in Access 2007

    Dear All, I need to calculate the monthly average on an array of data the gets added to weekly. Therefore, from Jan to March, the total is divided by 3. Come April, the total should be divided by 4, and so forth. Please, no VB code if possible - my VB sucks Thanks Riaan

    Riaane65 pointsBadges:
  • Sum of Donations for current year

    I have a query that sums donations and groups them by year. When I print receipts, it gives me two receipts -- one for year-to-date donations for 2009, and another that includes 2008 and 2009 donations. How do I get just the one receipt to print?

    RonleeG5 pointsBadges:
  • Microsoft Access 2007 Data Input & Report

    I am given a Start date 1/3/09 and an end date 1/5/09. 3 days. I am given 1 of 4 Codes (I, C, V, O). How do I get Access to show one of the predetermined codes under a monthly calendar starting day 1 through 31? ie., Rec# Jan 1 2 3 4 5 6 ** 1 I I I 2 C C 3 V V With the 3 pieces of information...

    PD15 pointsBadges:
  • Microsoft Access 2007 Query/Report Calculated Fields

    I have a table with customer estimates and sales. I need a report to reflect the closure rate by total number of jobs within a given section (in this example subdivided by lead source). Each job can have multiple records. I need to get the % based on grouping estimates for specific jobs. (7...

    Reici10 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