cricketbird's latest activity
-
Ccricketbird replied to the thread Wrapping long graph across pages.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...
-
CI 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...
-
Ccricketbird reacted to Minty's post in the thread How to quit and open a different AccessDB with
Like.
Don't open it as an app. Try using Application.FollowHyperlink "file://" & YourFullPathAndFilename Which won't involve the current... -
Ccricketbird replied to the thread How to quit and open a different AccessDB.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...
-
Ccricketbird reacted to isladogs's post in the thread How to quit and open a different AccessDB with Like.
You’re welcome. I use variations of this code in various apps which is why I gave the alternatives
-
Ccricketbird reacted to isladogs's post in the thread How to quit and open a different AccessDB with Like.
Try this code - it includes various alternatives for you to choose from Public Function RunExternalDatabase() As Boolean Dim...
-
Ccricketbird replied to the thread How to quit and open a different AccessDB.Thank you! This worked perfectly.
-
Ccricketbird replied to the thread How to quit and open a different AccessDB.That quits Database B, not A, unfortunately (even if the code is in A)
-
CI 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...
-
Ccricketbird replied to the thread Search using and/or.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...
-
CWhat you want to do is inherently the hairy part, not implementing it in Access. Complexity has to exist somewhere--either in the code...
-
CThe existing BuildCriteria function may already be sufficient. Const FieldName As String = "ITEM" Dim CriteriaString As String Dim...
-
Csee also this demo. open form1 and see the code on the "Report" button.
-
CI currently have a button that launches a msgbox that asks "Which item?" and the user types "Fred", and it opens a report filtered to...