Recent content by cricketbird

Thank you - this grasps the problem I was having with unassigning vs deleting. I think you are right - an unassign button (and preventing deletion) is the way to go. Also, thank you for helping me think through the forms in this and I think putting two subforms into a single form will make it...

I do not need to keep any history - only current state. I am also leaning towards attempt B. Hmm...I had not thought of using indexes separately from the primary keys. I will explore this - this may be the solution. Thank you :)

I'm using homerooms and students as an "easier to grasp example" for my more complex case... Business logic: One student can only be in a single homeroom. But, a homeroom can have many students. I have a form with the homeroom table as the datasource, with a subform listing the associated...

Thank you all so much...duh for printing the form value and not the RS value! I knew it had to be something simple and just couldn't see it in the moment.

I'm baffled by why this code I've used many times isn't working on a new report. It should loop through each record and print one report per record. But, I can't even get it to loop through the recordIDs... What am I missing? This is in an onclick event of a button. Set db = CurrentDb() Set RS...

Thank you all for the fascinating discussion - I've learned a lot. The techniques here (define parameters even in the SUBqueries) got my original query working - thank you. But then I ran into the next issue, which was when I went to call it in DAO (set rst = CurrentDb.OpenRecordset("myquery")...

If I run this query as a "select" query, it works fine, but if change it to crosstab, I get the error "The...engine does not recognize [Forms]![Bookings]![StartDate] as a valid field name or expression". Apparently this doesn't happen as a parameter query, but I don't want someone to have to...

Currently yes, but we can limit that if that will be a problem.

The idea is that some records may have associated files with them, and I don't think we want to change those original files or make different versions of them - if someone updates the associated file, the report should reflect the updated info the next time you run it. So, I don't think a...

I'm trying to display a hyperlinked document (currently a mix of Word and PDF docs, but I can force users to use one format if needed) in an Access report. So far, I can create an Edge Browser control that correctly displays a Word or PDF document (the network filepath is in the ControlSource)...

Awesome - never used them before. Thank you all!

I'm trying to decide if that is extraordinarily cludgy or extremely elegant, but it works, so I'll go with it. Thank you!

From selected record(s) in a listbox, I would like to print multiple mailing labels (stickers). So, if someone enters "5" on the form, it would print 5 identical labels per record. If they enter 300 labels, it should print 300 labels per selected record. I can easily print 1 label each of the...

Apologies for responding nearly 6 years too late, but for future reference here is my solution including the R Shiny script to import and convert data from "wide to long", an example datafile, and the Access VBA to import the "long" data to Access: https://github.com/DataKritter/D1toZDN

I wanted this to work, and it seems like it should, but I still get values and not NULLs as the sum when I do this. I'll keep playing around with this...