Recent content by naa123

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

This is a very unhelpful reply. If I knew how to simplify the expressions by assigning parts of the expression to variables, I would have tried that. I am a beginner with Access, hence why I am here asking for help.

Thank you very much for your help - I have done this and it has solved the issue.

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

This is really useful, thank you very much for your help!

I see, apologies for my misunderstanding. Yes, I do have View set in options - unfortunately I am still unable to select any queries.

Hi, apologies for the silly question - can you tell me how you got to this Table Options menu? I cannot see this in Access 2016.

Thank you for your response. This is what I see when trying to link the query - it is only possible to select a table:

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

Thank you all so much for your help!

Thank you both for your reply - the screenshot I posted is what I see on the back-end, and I do only have one back-end file. I created my relationships in my database before splitting, and then split the database once, using the database splitter wizard. I am unsure why I am seeing relationships...

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

Thank you very much everyone for your very helpful responses (and patience with me!), I really appreciate it. Everything feels a lot clearer now and I have some great advice to consider going forward. GaP42, thank you for your detailed guidance in your recent post - it is extremely useful...

Hi all, apologies for any confusion I have caused by not being clear on this. I am still getting my head around a lot of it myself (and learning a lot!) and in doing so may have misunderstood/missed key information. GaP42, you’re right – this database will not have a front end to support data...