Search results

  1. T

    Subquery Issue

    Hi Chaps, I haven't used subqueries before, so I am not 100% on the best way to approach this. The Scenario: I have tables; tblJobDetails tblMissingKit tblSiteDeficiencies JobID is the primary key for tblJobDetails. tblMissingKit and tblSiteDeficiencies are both tables containing (funnily...
  2. T

    Opening Excel File - Run-time error '462'

    Hi Guys, I am having some strange difficulties with trying to open an excel file. To briefly outline what I'm trying to do; I have numerous queries which I am using as reports, once the user has set the parameters for the query, I run the query and then export it to excel (using this...
  3. T

    "Too few parameters. Expected..." - Parameter Query Issue

    Hi All, I am having an issue with a parameter query, let me try and explain... I have a table (tblsitelogs) which contains records with dates on. I want to be able to query between 2 dates (from a form which the user specifies), and then export the data from the query, to an excel spreadsheet...
  4. T

    Changed Startup Setting - Cannot edit?

    Hi Guys, A real quick and stupid question here. I was playing around with the startup settings of my database, and I literally unchecked everything to see how it would load up.... It loaded up with no extra functionality (like no extra menus or no database window/status bar showing) - which...
  5. T

    Split Database - Locking of forms?

    Hi Guys, I have a query about splitting a database, and then restricting access to certain forms. I have a table with 5,500 exchanges in. I then have another table of 'jobs' which are all allocated to certain exchanges. When the user loads up the database, they are presented with a form which...
  6. T

    DataEntry is On - Blank Records adding?

    Hello All, I am having some problems with an access form. I have a form named frmEntryDetails - which is joined to: tblSiteLogs, within that I have a subform named frmViewMissingKit which is joined to: tblMissingKit. The user will fill in the top bit of the form (frmEntryDetails) and then if...
  7. T

    Displaying Records based on record values

    Hello, I am relatively new to Access and am currently in the middle of creating my first proper database, so please go easy on me if its a simple solution :D. Basically, I have a table (tblMissingKit) which I am displaying on a form. I have about 6/7 fields in that table, one being 'Item...
Back
Top Bottom