1
  • Access Database

    Access Database Question. I have two databases: Company and project. I want to be able to input a primary and secondary description of the work at the project level that is saved at the project level, but also adds to the company database (if that primary and/or secondary description hasn't already...

    bruceinpl5 pointsBadges:
  • Link Query to Report on Access 2010

    In an existing database, I have copied an existing query and an existing report so my new report will be in the same format as existing reports. I changed the criteria on the query so that it is pulling only the information I need. Now I need to link the two so the report will pull just that...

    LindaJenkins5 pointsBadges:
  • MS Access Functionality Problem

    I have a table with an associated form listing all of our raw materials that we have in house (sometimes multiple lots of materials). I have a table with an associated form defining the components (raw materials) of all of our products I have a “Build” table with which we would use a form to...

    BrianMCSE5 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:
  • Output Microsoft Access Report as PDF WITHOUT borders (around the edges of the page)

    In PowerPoint, if i save the presentation as a PDF, it does so without annoying white borders around the outside of the page. In Access, I cannot reduce the borders to 0, or seemingly do anything else to output a report as PDF without at least a 0.166" white border around the page. I want to output...

    cvandenburg5 pointsBadges:
  • Access field set to Scale =2

    How do I set a field Scale = 2?

    jcurry6510 pointsBadges:
  • ACCESS 2010 query in CRYSTAL XI

    In Access 2010, suppose query having a validation rule [90 bal %] = '0', when calling this query in CRYSTAL REPORT that '0' considered as a parameter and waiting for user to input value for [0]. Though '0' is a validation rule and also working fine when running in ACCESS 2010 whereas in CRYSTAL...

    SQLlions35 pointsBadges:
  • Microsoft Access 2010 DB Macro that allows a count of a date filter, and an email to be sent

    Hello, I was wondering if, within Outlook 2010, is it possible to have a script run that runs the date filter command within Access,displaying the weekly total number of values logged within the Access database. Once it pulls that value, I then would like it to send an email saying the count to a...

    Chris311fan5 pointsBadges:
  • Auto populating fields in Access 2010

    I have the following tables: Parts(PartID, Description) SecondaryParts (SPartID, Description) The relationship between the table is a 1:M - One part can have many secondary parts associated with it. I want to create a Form that will allow me to select the PartID and When a PartID is selected, I...

    MWS5 pointsBadges:
  • Access 2010 database query

    I am new to Access and am having some trouble writing a query, for an absentee database. I only have two tables, one for the roster and the other with the absentee logs. The Roster table only has employee name, badge number, and shift. The Attendance Log table has the date of occurrence, the...

    Katie5 pointsBadges:
  • Access 2010 macros

    I have a macro that 1)starts with a make-table query, 2)opens a report based on the new table, then 3)runs an If statement stating IF [Reports]![Reject Report]!="NO" THEN EmailDatabaseObject called "Reject Report". . . My problem is that after the macro completes it locks the table that was made...

    Danna15 pointsBadges:
  • Problem with Access 2010 and Adobe PDF creating a file.

    I am trying to create a PDF file from within Access 2010. I just converted from Windows XP running Access 2003. Now I am on Windows 7 with Access 2010. The following work on 2003 but the PDF creations doesn’t on 2010. Private Sub PrintInvoiceWithForm_Click() On Error GoTo...

    DPaxton180 pointsBadges:
  • How do I keep the original value of a field in Access 2010?

    Hello, I have an inventory with varying prices (which may change weekly).  I need to compare the current price with the original price. However, I only want the users to input one price value in a form.  I've tried to do this with a datamacro and the "old" command, but every time i update the...

    Vostro12315 pointsBadges:
1

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