Search results

  1. R

    Filter a chart by date range

    Morning all, Again apologies for my inexperience in advance. I have four charts for my database where users input information about incidents at work. 1. Incidents by day of the week (to identify risk periods) 2. Incidents by location 3. Incidents by timeslot 4. Incidents by type The...
  2. R

    Manipulating a chart on a form based on combo boxes and date range

    Hello All, I am trying to manipulate a chart based on a selection of combo boxes and a between dates picker but being new to access and not being competent with VBA and SQL i am struggling somewhat. I have a table of information called "Events" And from that information i would like to have...
  3. R

    Record search is bringing up a blank record when no record exists

    Good evening all, I have a simple record search box (below). I would like an error to appear if no record exists for that number. I am not familiar with code at the moment though and simply use macro builder (shown also) Could anyone help with what i should input in the macro builder to...
  4. R

    How to add a second page to a report

    Hello again, Hopefully this should just be a simple solution, but how do i add a second page to a report in design view? I am currently adding fields to my report but have run out of room! Is there away to add a second page? Image attached. Thank you!
  5. R

    Use an input form to generate a report

    Good evening all, Again apologies i am a basic access user and still learning the ropes. I have an input form for my database (which holds details of incidents that occurred at my workplace). The users have always inputted the incident details into the form and then simply clicked "Save" and...
  6. R

    How to clear a user input form without it automatically saving to your table

    Good morning, I have a user input form on my database however i have noticed if a user starts to make an entry but then stops for some reason and closes the form. The data they have entered already appears on my table (and leaves me with incomplete entries). Is there a way to prevent this...
  7. R

    Tick box to include graph within a report?

    Good evening, 1. Is it possible to add a tick box to my search form with the option of including a graph in the report or not? 2. How do i change the specific date search function to a between dates function? (I don't yet have the competency to work with SQL etc so have build the attached...
  8. R

    Multi filter options for a subform

    Good evening all, I am very new to access, could someone provide a simple step by step to help me with the following: I currently have a basic form and subform (table) which is filtered by a drop down box. I would like to add further filters however such as type of incident, date etc. I...
  9. R

    Question Is it possible for access to link associates together

    Good evening, Firstly i apologize for my ignorance i am relatively new to Access. If i had a field in my table called "Associates" for example and within the cells i had the below (each line contained within one cell separated by a comma) Four example cells: 1 - "Jake, Tom, Harry" 2 - "Tom...
Back
Top Bottom