Recent content by HalcyonDaze

  1. H

    Add records to two tables in 1-1

    Mostly its a case of Doc's #4 scenario. Table A is part of an existing database in use that tracks control instrument locations, pricing, etc. being use in current project. I am trying to add the instrument Datasheets, which contain specifics of model and implementation for each instrument, to...
  2. H

    Add records to two tables in 1-1

    I have a database where two tables are linked in a 1-1 relationship linked by the auto-number key in each. Table A is the main list, with Table B containing unique (and private) information related to each of the corresponding records from the Table A. What I need to do is ensure that...
  3. H

    Form with Multiple Data Source

    I have a Form to make, and I have only done the most basic of form work in the past. Honestly I dont even know enough to use the proper terms when asking this question, but Ill do what I can: I have an existing Table A in my db. Each record corresponds to an instrument being installed in a...
  4. H

    Access Closes when Copying

    Ya, thats what Im doing. Normally though when it crashes it gives some sort of message, even if its just the Error Report Send bit after the fact, but Im getting none of that this time around.
  5. H

    Access Closes when Copying

    In order: Not sure what a "Busy Form" is... MS Access 2007 (12.0.6423.1000) SP2 MSO (12.0.6529.5000) No, Should I? What is it? Save As works fine, I can Save. But the Copy sequence still sends a Close Command for some reason. Yes, the Report is based on Data from tables via a Query. It also...
  6. H

    Access Closes when Copying

    So here's a weird one. I have a report, and I wanted to build a form that looks similar. So I open the Report in Design View, Select All, and Copy. Immediately upon clicking copy (or using Ctrl+C, makes no difference) Access Closes. No Save, No Confirmation, No Error Message, Do not Pass Go...
  7. H

    Report from Multiple Tables

    Table A of the report exists; Im building Tables B and C, and the report to display it all. So Ive built the Query, but its not returning right. Im pretty sure its something in the Relationship/Join setup. Tables A and C should have a 1-1 relationship; each instrument will have its own data...
  8. H

    Report from Multiple Tables

    This may be more of a Table issue than a Report Issue, but the Report is the final goal. I need to create a report that pulls from 3 separate tables. Table A has a large (several hundred) list of instruments being used in a project. Table B has a list of spec sheet categories that are...
Back
Top Bottom