Search results

  1. P

    Access 2010 Not Responding when fields selected

    Hello All, A bit of an emergency here at work! For some reason our database keeps "not responding" and we have no idea why... The application stops responding when: A field is selected that has a input mask A combo box is highlighted (forcing the drop-down menu to open) Certain buttons are...
  2. P

    Database linking issue when db is opened

    I am trying to link a access DB to an excel sheet and everything works as expect it to, unless the DB is open. my db is an encrypted accdb file and I have connected it via the "From Access" wizard within excel. it is an encrypted file as I do not want the users to gain write-access to the tables...
  3. P

    Best way to allocate record numbers

    Hello All, What is the best way to allocate a record number to the end user? I have had problems where users have come back to me saying that both of them created the same record number at the same time and I am not sure why that is happening. To be certain, I am using INSERT rather than...
  4. P

    subtract two columns within a query

    Ok there is a problem with this method... I want to link this query to an excel spreadsheet but the query doesnt appear on the list of queries you can choose from when creating a table/query link to excel... So i tried to create an SQL type instead but I receive the message: "Undefined...
  5. P

    subtract two columns within a query

    yes, this is currently what I have... but that still doesnt reduce the run time unfortunately, that was the real problem :(
  6. P

    subtract two columns within a query

    @ pedantic amatuer methmatician. I knew someone would do this with my example! unfortunately the forumla isnt as simple as that. The formula takes a long time to compute with the large data size I am using. its much easier for a computer to compute a subtraction than it is to use my formula...
  7. P

    subtract two columns within a query

    hello again :) I have two calculated columns in my query for example... table.num1 - table.num2 as "Col1" and table.num1 - table.num3 as "Col2" I then want another column equal to: Col1 - Col2 I know that I could say: (table.num1 - table.num2) - (table.num1 - table.num3) but I am wondering...
  8. P

    Filter a sub report on open

    uh... new problem... now some people are requesting that they dont always want the most up to date one and instead they want to enter in the date value to retrieve... so how can I filter based on a passed in date? (can I use vba to modify a queries definition? or use QueryDef to create like...
  9. P

    Filter a sub report on open

    The problem was that the tables were not properly linked in ALL fields on the form (and subform) so thank you for helping me clear that up!
  10. P

    Filter a sub report on open

    I have tried to copy this method to my database and... surprise surprise, something isnt working. I have been trying to do it at home but the connection is bad, it takes 10 minutes to even load up the "Query Wizard" that ive just given up. The error I get is a "parameters" box that wants me to...
  11. P

    Filter a sub report on open

    is it possible to condense these two queries into one? select [Model],[Owner],[Date] from [Data] where [Date] in(select [Model],max([Date] from [Data]) Something like this would work but if there was entries in multiple models on the same date that happens to be the max date for one model, it...
  12. P

    Filter a sub report on open

    this is EXACTLY what I want, could you please explain what you have done/changed so I can see how you did this! it appears that you have done: 1. Change the subform to link Manufacture and Model 2. Do some magic with the "query1" report that I dont understand:D Could you explain? Thanks very much
  13. P

    Filter a sub report on open

    ok... here is what I am trying to achieve... if you select "BMW" you should see 3 pages of the report. Page 1, contains a list of owners of M3. Page 2, contains a list of owners of M5. Page 3, contains a list of owners of Z3. If you select "Mercedes" you should see 3 pages of the report. Page...
  14. P

    Datasheet like report inside a report

    ok... here is what I am trying to achieve... if you select "BMW" you should see 3 pages of the report. Page 1, contains a list of owners of M3. Page 2, contains a list of owners of M5. Page 3, contains a list of owners of Z3. If you select "Mercedes" you should see 3 pages of the report. Page...
  15. P

    Filter a sub report on open

    Table1 Package - Unique Identifier Type - the type of package Table2 contains a list of things which appears in the subreport table, the link between this table and table2 is Package. In this table, Package is not unique so I am assigning lots of records to the information that is kept in...
  16. P

    Filter a sub report on open

    hmm, I am not sure... I want to show a report based on all a collection of packages, so I filter the report by the collection name... so there is multiple packages. When I set up the Parent/Child relationship to packages It asks me to input the package name... which cant be done as I want to...
  17. P

    Filter a sub report on open

    Hello again, Im trying to filter a subreport on open. in my report I have a field called "Packages" and my subreport consists of a table, one of the columns is "Packages" so I want to use the value that I have in "Packages" to filter for only those items in the sub report. Is this possible?
  18. P

    Datasheet like report inside a report

    argh, frustratingly struggling still :( because the type can contain multiple values, it requests that I give the value for type when the report opens (rather than give all values of type in the report...) I am not sure if there is a way I can scrap the sub report idea and just use some...
  19. P

    Datasheet like report inside a report

    So table1 essentially contains all information that is not within that table, the unique column is the Package Name. table2 contains multiple lines of the information within that table PLUS it contains two columns that are hidden, Package Name and Type so that I can identify where each record...
  20. P

    Datasheet like report inside a report

    Hopefully this picture will explain what I want it to do... the hard part is getting the "sub report" to only report out the "types" in the "packages"
Top Bottom