User Profile

Collapse

Profile Sidebar

Collapse
Ivan Kartun
Ivan Kartun
Last Activity: Aug 20 '19, 02:25 PM
Joined: Mar 24 '12
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • Ivan Kartun
    started a topic Access 2019 Query runs fine for a while then suddenly - changes , to .
    in Access

    Access 2019 Query runs fine for a while then suddenly - changes , to .

    Using basic Access tools - I developed a small system using Access 2013 - it ran fine

    Took it to a client who is running Access 2019 (365) - imported from my system some queries and forms

    All worked well

    Tries to edit a form on their system - suddenly the query had an error Invalid use of '.'etc.

    Had two other unrelated queries - both work fine - tried to run them again 5 minutes later -...
    See more | Go to post
    Last edited by NeoPa; Aug 20 '19, 03:03 PM. Reason: Made pic viewable.
    • Ivan Kartun
      replied to Adding multiple Lines for data input
      in Access
      The problem that i had related to the blocked table - in the trust centre - i enabled it and exactly what you suggested worked - so thank you
      See more | Go to post

        Leave a comment:

      • Ivan Kartun
        replied to Adding multiple Lines for data input
        in Access
        I have unblocked the location and it works now - thanks for all your help

        Ivan
        See more | Go to post

          Leave a comment:

        • Ivan Kartun
          replied to Adding multiple Lines for data input
          in Access
          as soon as i include the input table and sopecify the fields i want to append to - the append run will do nothing - whereas in select mode without the append (or the input table which i would like to append to - it brings up the correct data

          2 issues

          1 i think the problem is when i bring in a table that has joins in it (i have tried removing the relationships
          2 it comes up with an error saying it is disabled
          See more | Go to post

            Leave a comment:

          • Ivan Kartun
            replied to Adding multiple Lines for data input
            in Access
            Yep the union after much playing is not correct

            In the Select i have got the employee and day info up but not if i do an append to the daily input table - it says i need at least one destination field

            I tried putting in field from there (joins (relationships) ) then were included when i showed the table - but nothing happens - i cannot get all the records selected into the target database

            I've tried a few things...
            See more | Go to post

              Leave a comment:

            • Ivan Kartun
              replied to Adding multiple Lines for data input
              in Access
              Thanks NeoPa

              You got me onto the right track

              I eventually used (without coding) the union option in the query (append)

              Thanks muchly
              Ivan
              See more | Go to post

                Leave a comment:

              • Ivan Kartun
                started a topic Adding multiple Lines for data input
                in Access

                Adding multiple Lines for data input

                Hi all

                Please help

                I need to generate multiple lines (per employee per day)

                3 tables
                Employee - Empl No 001 John, empl No 002 Mary
                Day - Day ID 12001 Jan 1 2012

                The next table needs to be generated as follows:

                Daily input Table
                Record 1
                Day No - 1201
                Empl No - 001
                Hrs in Office - 0
                Hrs at client - 0
                ...
                See more | Go to post
                No activity results to display
                Show More
                Working...