Search results

Thank you both for your responses both examples look brilliant and far better than i had envisaged mine ever looking. Colin, i have sent you a private message :)

https://www.dropbox.com/sh/og9r32nv4fz9w7t/AAByLrVR1zc9-qWgpfiBz8IUa?dl=0 here is a link to further images and a sample copy of my database. Apologies for the poor formatting as i say i am new to this and its my first attempt.

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...

Hello ArnelGP, Now i have the below but am struggling to get the command button to work to update my form. If i open the subform seperately the query runs and chart displays the data i input.

Apologies i have just realised how simple that is i am trying it now thank you!

Thank you very much for a speedy reply, could you possibly give me an example of what you mean when you say "Use your forms control to filter the query" I have tried to create a query but it wants to base the query off of a table or another query..

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...

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...

Thank you, i have added the page break control but it is not freeing up any extra space at the bottom, i have tried to drag the footers down but only the "report footer" will drag down... Am i missing something obvious here?

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!

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...

Extremely helpful thank you!

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...

Thank you so much for your helpful reply, Could i trouble you a little further? Having never dealt with the code side of Access before, where within the code should the below be placed? My search form code simply is: Option Compare Database And the code on my report is: Option Compare...

Excellent thank you, Do you know of any links or tutorials i could view to walk me through the processes? Apologies i have only been working with Access for 3 weeks now. Thank you again

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...

Thank you very much for your help!

Thank you for your reply. My database holds information about vandalism against our company property. The main Events table has fields such as ID - Location - Type of Incident - Date - Time - Reference Numbers - Tags Used I also have tables for the types of incidents and the locations of our...

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...