Search results

  1. J

    Pulling in data from Excel

    arnelgp Thank you so so much. I have pasted it in and it looks like it is working. I need to ensure we then saee in the form - but that should be finew. And add in all the other fields we need to bring through. Really really appreciate it. Fabulous
  2. J

    Pulling in data from Excel

    Dear all First - apologies that I have not replied sooner. It was a hectic week. A bit of further explanation. 1. We have a statistical package that we use say 200 times every quarter to create new statistic equations. The statistics package geneates outputs for each equation. These are...
  3. J

    Pulling in data from Excel

    Hello. Looking for some assistance. I have an access database that we pull in data from excel files and store. Currently we enter the data manually via a form. I want to automate it. Context Currently we have a statistical package that generates outputs in an excel file. Those outputs...
  4. J

    Working with one to one related data

    Gemma. Thank you. Now I have that, I may just change it to a hyperlink field and we reference the location. The issue I have is whether a report will actually automatically display the relevant file... If you know if that will be ok, brill. But I will look for some oher explkanation here...
  5. J

    Working with one to one related data

    Thanks for the replies. Few points. Re the query - that is the key issue, I need the underlying query to be update-able and particularly that new rows are definitely added in both tables. The issue is that, as it is an multi-value field type, it cannot be referenced in a query in another...
  6. J

    Working with one to one related data

    Hello I am newbie and really hope someone can assist. I setup a "main" database with related tables. But there is one table with lots of information based on a primary field (a "curve"). I did create an autonumber field to drive new instances of curves. A form was created with a lot of...
  7. J

    Introduce myself

    Hello all I am a new member. I have some understanding of databases and running queries, but I have only started creating a database and form in Access 2010 in the last 6 months. I am self taught and only know what I know. Any assistance you have will be much appreciated...
Back
Top Bottom