Search results

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

Thanks! It makes sense - I will give it a whirl in the morning :)

Currently, if my data in a given column is: (1, 2, 3, 4, 5, (missing), 7, 8, 9), then when I sum these I get 39, whereas I want to get NULL because in my business case I can't sum these values if I don't have all these values. I don't want to return a partial sum. So, in a simple query, I'd...

Originally it was showing status of over 100 locations. I just changed it to group by higher level division so there are fewer things to show and it can fit on one page :( After fiddling more with the ChartObject and every other setting I can find, I have given up. I re-did the report to...

I have a report that generates a graph that is so long that it flows across several paper pages. This isn't a problem, except that when printing/print previewing, page 1 just shows the report header, but is otherwise blank, and then the graph starts on page 2. I've tried: Putting the graph...

I spoke too soon. The second database opens, but as a copy of itself, so changes made aren't saved. Is there a way to launch it as its own entity and not a clone?

Thank you! This worked perfectly.

That quits Database B, not A, unfortunately (even if the code is in A)

I am trying to code a button that will quit the current Access database (A) and open another Access database (B). I can open database B just fine, but the quit command seems to close B instead of A. Database A knows where B is (so I can open it specifically), but B does not know where A is...

Thank you everyone - I've learned a lot. The code examples and example db were extremely helpful! I will be using both of those in several locations.

I currently have a button that launches a msgbox that asks "Which item?" and the user types "Fred", and it opens a report filtered to all the records where a field is like *Fred*.. This works perfectly. However, we now want to have users be able to type in "Fred or Ginger" (or Fred and Ginger)...

Thanks for the helpful advice :)

Thank you for helping me see this as a success and not a "taking over" and for the positive suggestions. I appreciate it!