Search results

I all so after much persistent on myself, i think I have manged to achieve what I wanted however my manager is not happy with something. I have attached a photo for reference. basically the graph reports on a yes/no, if its yes then it graphs it, the issue is it shows -1, is there anyway I...

Hi JHB, sorry. Please find attached. The second graph is a picture, but provides a view of what I am after. Graphs are in Sheet 1

Hi all, Wondering if there was any guidance on the below on how I can achieve whats needed..

Hi All, I am at my wits end and cannot seem to get what I need achieved. I have managed to do most of them but struggling with the below: I need to report on the following but it always returns empty: MK Denial Completed? Within 4 Days Booked Orders by Month.. So shows Jan,Feb etc. and...

Hi Isla, Thank you for doing this, it provides me a guide of how to build subsequent graphs.. On a side note, does the report automatically refresh itself upon opening or will i need to build a requery? Stuart:D

Apologies, guess it helps. I have provided a form of Demo in the new tab. This is ideally how i would like my graphs to appear in access. :)

Please find attached. This is the primary data that I will be running graphs from, in addition to this I will be using Queries and criterias to break down the information so its not so convoluted. I am really keen to try and create a graph that provides a form of count on the OTF information...

So you build this into the query using VBA or can I use it in “design” criteria view? Sent from my iPhone using Tapatalk

Hi all.. I have been tasked to provide KPI information in the database I have created and need to ask a question around date fields.. The particular field I am attempting to report on is a date field however when I run a query on this in the graph it puts the reporting in a date format, I...

Thanks for the tip Isla.. Column history works currently as the user deletes the previous comment before adding another.. as you know everything the user does in my dB is dictated by the record ID.. I’d love to use VBA to do certain things but when I attempt it, it don’t work, probably...

I'll be watching this space. When you say split, is that where there is a gap between each update, as currently mine is all together and looks really messy.. be good for each comment to have a new line.. etc (Example below) Version1: The cat sat on the mat Version2: And it was sunny :D:D:D:D

Thanks all. What I have done is taken the tip from Isla. I have used Macros that when the users wants to add a comment, they click a button which closes the main form, and takes them to the comments form, once the comment is added they have the option to save and return to the main form or...

Just so I get this. So let’s say I have one table.. tblsalesdata Connecting to that tbl are: Frmcomments frmother But the frmcomments is on the same as frmother and the users click a box to add a comment, which opens frmcomments leaving frmother open in the background, this is when it...

Hi All, I just wanted to check on something, after the below: Cause This behavior occurs when you open two forms that update the same data source at the same time. The first form puts an edit lock on the record or records, and then the second form changes the record or records and saves the...

Which Section would you build this VBA into?

I got that working.. Yes! The next question how do you stop it repeating the last entered text, and also not put a blank time stamp in. (Attached pictures)

Agreed, is a rather silly name. So i built that in as advised but i still get an error? I referenced it correctly. Followed a guide from: http://www.fmsinc.com/MicrosoftAccess/2007/ColumnHistory/Index.asp

Does this mean I have to have a seperate table that is an "append" table?

Hello Again all, I am attempting to use the below expression in my access field: =ColumnHistory([RecordSource],"Comments","[ID]=" & Nz([ID],0)) This was an example taken from a microsoft Template, "Customer Service" however I am attempting to get this to work in DB and it wont. I attach a...

Hi dbguy. Ok, thanks. So my ultimate goal is.. the user clicks a button this initiates “acknowledgment of receipt” it uses the report I created in access but then in addition to the form output it also attaches our terms and conditions. Note the terms and conditions PDF never changes.. The...