Search results

Hello, My main table contains a foreign key NCAID from tblNCA, which is a lookup table with five records, with two fields (primary key) NCAID and NCAName. The NCAID fields between the tables are related. It seems to me the purpose of the tables/relationship is to store the NCA as a code...

Hello, I have inherited a database with in excess of 78 fields and I gather I need break this down as it may be causing the "record is too large" error. There are sections which lend themselves to this: there are field prefixed "susc", "val" and "vis" but I can't see how to select these in a...

I have looked and tried several solutions for this and cannot make any of them work. I understand the idea that copying records is bad, but my client wants it as the input form for his assessments have 40+ fields and many of the records differ by one or two elements. Some of the fields are long...

I was sent a database to repurpose for a new project. I last used Access in about 2009... So far, I've got through ok, albeit slowly in places. I added my tables & forms into the old database, so I could copy the formatting etc. I used a different naming convention so they're all separate...

Hello, I used Access a fair bit over 10 years ago but haven't touched it till now but have been asked to do some stuff in it & I am soooo rusty.