Search results

0 I am relatively new Access vba user and having problems with the synatax for the use of DCOUNT with variables. I am constructing a simple routine to look for duplicates in the [EventShort] field of a table called tblEventsi. The first step is to count the occurrences of each of the strings in...

Dear Access World community: Apologies if this is not the right pace to ask the question; admins please feel free to redirect me. I am based in the UK somewhere between being a beginner and intermediate Access user and use the program for developing a database for a history project for a PhD...

I have a set of user defined keys and deliberately omit to check data-integrity requirements for the relationships because the IDs change quite often. What is the best way to update the primary key of a particular key across all tables? Is there a VB routine that would do this?

Microsoft itself warns against the use of the Dlookup function in Access but having become accustomed to VLOOKUP in Excel, I am keen at least to try to use the similar function in Access. Can someone help with the attached example in which a simple Dlookup of "GDes" on GID loops endlessly. Any...

I have a simple table that lists Families, Dates, Event Type Role and Person - these are life cycle events associated with a small sample of families in a database to analyse historic families. I am interested in the intervals between events in each family specifically from the marriage to each...

Good morning everyone and happy lock-down. I have just joined the forum and am excited to start meeting my fellow Access users. I am a historical researcher and am developing an Access database to help with the analysis of huge amounts of data I use to address demographic and social historic...