Search results

I think I've seen some advisement to not use calculated fields directly in tables. However, I'd still like to know if there is a way to do the following: Assign incremental sequential number by Year, i.e. YYYY-DDMM-xxx (xxx being the incremental number within the Year the entry occurs) The...

I was using macro not VBA, my apologies.

That's my current process unless I am misunderstanding! It opens to needed report, but I was hoping to bypass opening report to "print preview" to then downloading/printing. I am hoping to download or print with a single button click of the correct filtered form.

From what I have gathered, I can't simply bypass by putting a command button with macro to export a report AND have criteria (from a Form). It will export all report records...I believe. I was having a hard time wording the concept I am looking for- my apologies if it's still not clear. How it...

@isladogs Is there a way to adapt this to expand the size of the Detail section to accommodate the expanded fields? I would really love my continuous form Detail section entry to be a singular line with no dead space between entries, however, still have the ability to expand/collapse to show...

Pat, this is wonderful! I'm digging into it now to see if it can be modified to fit our program. Is there an appropriate way to structure this to have different sources for the responses(i.e., instead of a respondent, be tied to a Project OR a Structure/Property OR a Complaint, etc.)? The survey...

@plog aaaaand SAD face. I thought I was all done haha. That looks completely different and even more foreign. I'll dig in and see if I can find some resources on how to implement the Select Into. The W3 is very clear and concise, but does not seem implementation into VBA is simply plug & chug so...

So, I was able to create a query that Appends the Elements into the Response table OR Appends the InspectionPK (inspID), but not how to accomplish both. The closest I have come and am not sure it is what you meant is the following Query: INSERT INTO Response (Inspection, el_ID ) SELECT...

Edgar, thanks for sharing! If I am understanding "Since you didn't mention anything that could particularly involve Access" this correctly, to answer: This is just one small piece of the DB. This inspection is one of a handful of other inspections required, and all of them are done year over...

I am partially following and also a bit tripped up. Would the response table be something like PK InspectionFK MarkedResponse el_ID An option group on/as the subform...and is then the subform a continuous form so that it is creating individual entries/records (i.e. placeholder for appending)...

What would be the best design to accomplish this "Yes/No" style checklist? (see attached) I have tackled so many things in my journey learning access, yet my brain refuses to process the proper way to turn a form like the attached into something usable in Access. I'm fearing it's out of my...

Hello all. Just one of many people who find themselves in dire need of "more than just spreadsheets" and being tested daily trying to learn the world of Access. I'm several months into a deep rabbit hole of learning and attempting to create a database, but still feel very in over my head & out...