Search results

Thank you for the advice. I tend to complete alot of tweaks on my FE so it could be something has gone haywire in the background, but something not easily noticeable.

Hi There, Indeed, yep all is good thank you. Still working for the same company, nearly two years now... Thank you for the link, i will check it out.. :)

I can look but I am not sure if i will find the exact cause. Generally the way i have created my DB is put the tables on a network drive, then the front end is distributed amongst me and my colleague, all amendments are done on my version and then my colleague takes a copy. In light of this I...

Thanks for the reply! Its a rather strange one though as my colleagues PC generally puts it always in a sequential order, mine doesnt.. I don't quite understand what you meant in your latter comment, I thought ColumnHistory automatically put a date in, so not sure why I would need a dedicated...

Hello All, I use the following code in access as a way of capturing comments so my colleague and I know where we are at any given time, however I have noticed that the entries are not displaying sequentially? =ColumnHistory("tbl - Issues","MemoField","[ID]= " & Nz([ID],0)) In the picture...

Which area in the code though? Attached is the area where the current project was.

where should i put this is the code, in the Mod or On event?

Hi, Thanks for the replies. I had attempted to replicate the issue and it appears it is the "Ghost" application is running. Can this be resolved as I would have thought that when the user closes the form and deletes the record, the Ghost application should close itself, or is this a trait...

Here is the codes. I have named the files to relevance of the DB. Hopefully this should help?

Hi Gasman When the user has finished creating the document they click "Close and Delete record" The form in the DB is created from a particular field. Would it help if I uploaded my DB with a few records in so you can see?

Hi pbaldy, Thanks for the reply. The code is quite extensive, which is the best way to get this into the forum, notepad etc. Its funny you should mention the "Ghost" instance of excel as I have seen this a couple of times on users PCs, though it seems to be making itself more obvious now, is...

Hi all, Sorry it has been a while since I posted, i trust you are all well? I'm writing today today as i'm starting to experience a few issues to which i am unsure if it is Office 365 related or the code, The code was written for me by someone in this group (Arnelgp) to which I am really...

JHB/Isla, So I think I have now achieved what I wanted. (Hopefully :):) ) This result was after much perseverance and :banghead::banghead: The report will obviously get more compacted and smaller as the months go on so I am going to watch it closely and then go from there, the idea was to show...

Hello JHB, Thank you for what you have done, its appreciated. I have used your query to build my graph as my management team preferred the view attached than how the older Access displayed it. I've provided a picture of the view. I have noticed though that the graph keeps showing data in...

That makes sense now, it was putting alphabetical, you’d think it would have sense to know you are reporting on a month, so put it like it is in a calendar or is that asking it to be too intelligent lol.. Sent from my iPhone using Tapatalk

Hi JHB Thanks... No I’m not sure why it goes in that order, I tried everything to get it to show sequential.. January, February, etc would be better.. Thanks Stuart.. Sent from my iPhone using Tapatalk

Hi JHB, Thanks for coming back to me. I don't know if its making a difference but I am using office 365 to create my Graphs, which is still using the information from your query but still not reporting correctly, what you have done is reporting correctly but no when i create a graph from it so...

(null) Thanks June.. Is this reply related to what JHB had posted or Isla? Sent from my iPhone using Tapatalk

Hi JHB, Thank you for providing the guidance on how I can get the graph to show month view, its exactly how i envisioned my dashboard to look. There a just a couple of things I wanted to ask you. 1. How do i get it to show orders that are in this current year, so 2019 but by month view...

This was exactly what they required.. thanks for this.. Sent from my iPhone using Tapatalk