Recent content by cricketbird

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!

Thank you for seeing through my questions to the real issue - it is darn hard to let a beloved project go off into the wild without me. Thank you for your advice and feedback.

Our database (split fe/be, 80 users, Office 365, in use for 6 years, regular small modifications to add features or new reports) has become mission-critical enough that folks are rightly nervous about the backend living "loose" on a shared network drive. I'm being asked to move it to SQL server...

Aha! That worked! Thank you!

Thanks! You are correct! They are not closing! When I type that same code in the immediate window (using a real form name, of course), it works. Why isn't it working in this function?

I am taking a large database (split front/back, 85 forms) and creating a script so that users can switch all of the button and label captions on each form to their local language. The eventual script will use a table like this: TableName ControlName LanguageCode CaptionText Form1 Button1 en...