Search results

Hi, I have lookup fields in my tables and each lookup option has a number assigned to it (e.g. No = 0, Yes = 1 Not Sure = 2). How can I view/amend the number assigned to each lookup option in my table? When I click Modify Lookups, I can only see the text value and not the number that is...

Hi, I created a chart in Access based on a query. The query is as follows: SELECT [RCADS-C].[Client ID], [RCADS-C].[Appointment date], [RCADS-C].[RCADS Separation Anxiety], [RCADS-C].[RCADS Generalised Anxiety], [RCADS-C].[RCADS Panic Disorder], [RCADS-C].[RCADS Social Phobia]...

Hi, I am trying to create a PivotChart in Excel using data from my Access database as an external data source. I will then link this PivotChart back to my Access database. However, when I try to create the connection to the Access database in Excel, I am only able to select tables as the data...

Hi, I have recently split my Access database and am now finding that the relationships in the backend aren't showing as they did before I split the database. Instead, I see what is shown in the screenshot below. Is anybody able to advise what could be happening here or how to split my database...

Hi there, I have created an Access database which will be used to collect client data from practitioners. I have split the database into a front end and back end. On the front end, I have encrypted the file into a ACCDE file, hidden the ribbon, and the navigation bar to try and prevent users...

Hi, I am a beginner with Access, so apologies if this question has a very obvious answer/has been answered before. I am hoping to use Microsoft Access to store a large master database which will consist of 5 individual databases combined. The individual databases have around 350 columns and...