Search results

Hi all, I have been tasked with implementing a new field into our DB but not sure how to do it. Hopefully I can explain my requirement here. If the user selects "Biopharma" I only want them to see the results listed in the "Market Sub-Segment and so on. Market Market Sub-Segment...

Morning all. I currently have two departmental databases and I am currently working with our local IT department to get the DBs into SQL. The current setup is users have the FE on their Desktops linked to the BE through a network drive. Would it make sense to keep the two Databases separate...

Hi all, Thank you for the continued support but I've another issue. I have a main menu which has some graphs on it, see below: Unfortunately select users are reporting to me that they keep getting the following error message. Could the graph's refreshing at the default interval be...

Hi all, I have created some Graphs based on a query but the results are not reporting my requirements. Issue Below is the query I only wanted it to include all orders apart from orders not yet booked. Graph output No records showing Desired Effect. I would like the graph to show only...

Hi all, A form was designed for me by a member of our Forum and i've been requested to add a column but the results are not showing and i cannot work out why and hope someone could help. The issue is the OrderProcessor is not showing in the memo log box when the user saves the comment. When a...

Hi all, Hoping you might be able to help as I've hit a stumbling block. I have created a query on my DB and a user has reported that they are no longer able to select unselect all and then select a particular field. Picture here shows what the user wants. instead they are presented with...

Hi all, I have been testing Access BE tables into a Sharepoint List and reached a stumbling block. (Hopefully this is still supported by MS) I've managed to get the data uploaded into SharePoint using the export function in access but now I have lost the ID number in a particular form for...

Hello all, I am attempting to add a spell checker code which was taken from the forum to my existing VBA form that was completed for me but I am a little stuck. Below is the code that was written for me. What I added is a different color. Is there a way that when I click the save comment it...

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

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

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

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

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

Hello all. You may have seen posts from me previously or even helped me, to which I am grateful, however I have another question in the hope that I can develop something.. Basically we record Information that is later used to send an order acknowledgment or an order confirmation via email...

Hi all, Sorry another question from me :( In my DB i have combo boxes that returns a value from a particular field, however i wanted to limit the number of results that the Combo box shows, this is because my DB has alot of records and it ends up showing a long drop down box. It would be...

Hi all, I have been tasked with trying to come up with an inhouse approvals system but I am not sure whether Access is the ideal solution? The management team would like me to develop something that can be audited, time stamped and dated, but also has the ability to leave comments if they...

Hello all, I have reached a bit of a stumbling block for something that I am trying to achieve. I would like to use conditional formatting on a date range. In my tables I have "Opended Date" this is automatically generated when a user creates a record, I then have "Due back field" again a...

Good Morning I am trying to create a macro that when a particular criteria is selected in a drop down it generates a pop up message where I can inform the user to complete a particular action. in the tbl its setup as (Data type) "Short Text" with multiple Status's with that dropdown, I need...

Good Morning, The name is Stuart, nice to meet you all. I come here with an understanding of access and knowing the basics however when it comes to the more advanced stuff I am unable to complete I refer to the internet for guidance, however this can be quite difficult when i need to...