Recent content by NickWren

  1. N

    Match Excel Values with Access Query and in-put data

    CJ when you get a chance to look at this can you tell me how to link the sample ID field on my excel file and the one on the table? I used a relationship between the two but the data is not going into that sample for some reason when using an update query. The Sample ID and the Wren ID are...
  2. N

    Match Excel Values with Access Query and in-put data

    Because I think inside a box hahaha. Well thats an easy solution; I dont really want to use a linked table, but maybe I can upload the spreadsheet or maybe in-put the excel spreadsheet into a table to in-put it into the corresponding table.
  3. N

    Match Excel Values with Access Query and in-put data

    I have an Excel file that I am trying to upload into MS Access, I can easily click on a subform (which allows me to call the SampleID) then find that SampleID on the Excel Spreadsheet in column A; which will in-put other columns in that same row. However now I want to use a whole query's...
  4. N

    Loop excel column and match with records in database

    This should be the full code; but I still am having trouble looking through the query "qryCOCandLabels" or the subform called "subformtblFacilityPatients" (they are essentially the same thing). All I want to do is use an excel spreadsheets first column (has our "WrenID's" in it) to search...
  5. N

    Loop excel column and match with records in database

    Sorry this was just a snippet of my code so I forgot the line i = i +1. The problem I am having is having a look through a query for a given field (Sample ID) and then see if it matches any of the other Sample IDs on the excel spreadsheet; after it finds the matching Sample ID or doesnt the code...
  6. N

    Loop excel column and match with records in database

    Sorry if my code is all over the place and doesnt make to much sense; I am trying to write a code that can look through an excel worksheet and use the sample names to correlate to ones in the tables/queries, if the name exists then import the excel data, if not move to the next sample name on...
  7. N

    Creating a New Table in a backend then linking the table to a front end

    I can show you my table structure; but I know it is 100x easier to have just one table for all the facilities and a field to identify which facility it is associated with; but when your boss wants it done a certain way, you try to accommodate them. I mean clearly it is possible if there are...
  8. N

    Creating a New Table in a backend then linking the table to a front end

    I want to start off saying that I am still a beginner at access so forgive me if I use wrong terms or don't really clarify what I am talking about. I have a form where we create new facilities; once the new facility information is entered, the VBA command will check the "FacilityName" if there...
See more
Back
Top Bottom