Recent content by dlambert

  1. D

    Sequentially modify entries in subsequent query results.

    Hello, I am trying to implement a form that i will use as part of a quotation system. The data displayed will come from a query that filters down by quotation number (selected from a combobox or similar), and orders the results based on a field called RowNumber (I use this field so that the...
  2. D

    Extract field from query results into VBA variable

    I am quite new to the whole Access world, this is my first project in Access (though i have previous programming experience), so i clearly do not know all the the 'industry standard' ways of doing certain things, and sometimes end up with unusual workarounds... but as you said this one works OK...
  3. D

    Extract field from query results into VBA variable

    My objective here is to have the user be able to: - select a PartID from a combobox (this then runs an AfterUpdate event that autofills the ManufacturerID and ManufacturerPN) OR - Select the manufacturer form a combobox and enter a ManufacturerPN in a textbox and if I happen to already have a...
  4. D

    Extract field from query results into VBA variable

    Hello all, thankyou to all the suggestions, i think several would get me there, but in the meantime i found a very simple workaround that works perfectly for me: I made a hidden combobox called comboMatchingID that has my query as the row source, then i use the following code to get the PartID...
  5. D

    Extract field from query results into VBA variable

    i guess that the 2 parameters could be the the sections bold below from the SQL of the qryStockFindMatchingID query? (the other query i tested with that had the error expecting 1 parameter has 1 'referenced filter' (for lack of a better word) so i guess that would make sense) SELECT...
  6. D

    Extract field from query results into VBA variable

    Thanks for the suggestion Namliam This seems to work OK if i use a table (instead of "yourquery"), but when i put in the name of my query i get the following error "Too few parameters. Expected 2" Just for troubleshooting i tried with another query and i get the following error: "Too few...
  7. D

    Extract field from query results into VBA variable

    Hi arnelgp, i have tried that but get the following error: "Run-time error '2465': Microsoft Access can't find the field '|1' referred to in your expression" i have no idea what the '|1' referenced in the error comes from... This is the code i have at the moment as a starting point...
  8. D

    Extract field from query results into VBA variable

    Hello all, I am trying to make a VBA script that will be in the 'AfterUpdate' event of a textbox in a form that needs to get the value from the output of a query and use it further down the code. So i have a query (which works as expected) where the output fields are: PartID, ManufID, ManufPN...
  9. D

    Combine varying quantities of fields into a single fields without additional commas

    Thankyou for the responses, quick summary of why i have the 7 description fields: I am storing data on various types of equipment. Some for example i have descriptions as follows: Relay: ADesc (Coil voltage): example: 24VDC BDesc: (Contact configuration): example: 4PDT CDesc: (Rated Current)...
  10. D

    Combine varying quantities of fields into a single fields without additional commas

    Hello all, I have a table that contains a list of materials, with 7 separate fields for descriptions segments. These are called ADesc, BDesc, CDesc, DDesc, EDesc, FDesc, GDesc. I would like to display the combined description into a single field output of a query, so at the moment i have the...
  11. D

    Query with double link between tables

    Thanks for your quick response, much appreciated, (i had already tried that but had something else wrong, after your message i investigated more and got it working). On a similar topic, below is a screenshot of my overall relationships: As you can see i already had 2 sets of tblEmployees to be...
  12. D

    Query with double link between tables

    Hello, I have a table called tblJobs that contains the IDs that are linked to other tables IDs. Those ID numbers are meaningless to the users of the database, so i would like to make a query (or is there a better way to do this?) to 'clarify' the table of Jobs. So for example if i add the fields...
  13. D

    Delete duplicate entries (keep only one)

    Hi Gasman, Thanks for your suggestion, i think it will work. I am stuck on the last step. How to a make the delete query WHERE Dupes.ID not in Wanted? I have tried with no success...
  14. D

    Delete duplicate entries (keep only one)

    Hello all, I have a table in my database that is accumulating duplicate entries. (i am trying to work out what is causing those duplicates as they should be prevented in the first place, for for now i need to be able to delete the duplicates) The table is called tblJobs and has the following...
  15. D

    "After Insert" Data Macro to populate field with data from another table based on other field in new entry

    Hello, I have the following tables: tblJobs JobID ClientName (more) tblWorkMaterials JobID ClientName (more) The table WorkMaterials list the materials used in each project so each entry has an associated JobID (from tblJobs) I know it is not a standard way to do things as it would be a...
Top Bottom