Recent content by BFroeschlKC

After playing with it for a long time I figured out it may have something to do with the graphics or complexity of the Publisher Document. I had background images and a couple of other images in my template documents and when I removed them I had better success. If I reduced the number of...

I'm trying to automate creating a publisher page (a binder cover) from a Publisher "template" document, for each person in a list. The template document "BinderCover Test.pub" has one TextFrame object with the text "Name" in it. I have some code to automate this template file. Public Sub...

I can't help with the login problem. Sorry. I'm still noodling on your post and realize that requirements can sometimes be tricky. So, here's a solution if you need a sum of the number of rolls, not the sum of each roll. Public Sub HowToUse_DiceRolls() Dim rolls As Collection Dim oDice...

In VBA code, I'd store them in a collection. Try this. Public Function DiceRolls(Optional NumTimes As Integer = 1000) As Collection Dim aRoll As Byte Dim i As Integer Randomize Now() Set DiceRolls = New Collection For i = 1 To NumTimes aRoll = (5 * Rnd) + 1...

Just checking some basic stuff here. For this code to work: With varForm .Controls("something").Property = Value .Controls("somethingelse").Property = Value End With Form "form_Test_0" would need to be open. I don't see where you open the form. Here's some code that may help. Public...

dhookem is correct. This formula is just too much for Excel. That said, if you must, I think what you should do is break your formula down. Take each "unit" of the formula and put it in it's own cell so you can see the value that is being returned. In this way you can "debug" the formula...

I'm not seeing a question here, but I'm guessing using the form events is not working for you. That's because you need to "select" the form to detect the "Key" events. And that is hard to do and even harder to manage. Instead, I think you want to use the KeyUp and KeyDown events on the button...

I think you need to tell the subform to requery after selecting a prefix or breeder. The subform has no idea that the main form changed values that affect it's internal query. It works when you open the subform because then the subform's query is run again. I always use the "code behind" (not...

I've always done this type of check in-line as: If Len("" & V) > 0 Then AttachFile(V)

Currently learning/using React. Mostly with AWS Amplify right now.