Recent content by vangogh228

Thanks! I'll note that and try it.

I use On Current a lot... sometimes to make sure certain values are null when I come back to a record, for example. But... can I do the same thing as I am LEAVING a record? I have made it so a number of records in a continuous subform can be checked (bound checkbox), then a button is selected...

Hello all. I have a customer-level form, with invoices showing in a continuous subform. I want to be able to prepopulate a number of reports (that duplicate current manually-filled paper documents) with customer-level information AND invoice-level information. I was thinking about putting a...

Tried that too. Same old thing. Thanks for any help...

I was looking back over my own posts from the last 6 months or so and I was shocked to see how few times I thanked those who had helped me. This forum has been a lifesaver to me many times, and I want to thank all those who contribute. Also... I need some reading material on splitting and...

Tried that before. Does not work. Any other help?

I have a data table for open accounts receivable collections activity that has the following important fields: Autonum (Key) Code InvoiceNumber Amount Date Each day, this table will be updated with new invoices. However, a significant number of updates are required. For example, under...

If I enter 2-4 into a cell, as in "pages 2 through 4," excel reformats it as Feb 4. I don't want that to happen. Yes, I know I can use an apostrophe. I don't want to have to do that. How can I turn this irritating helper... just one of many... OFF? Thanks!

I have a Customer table in an Accounts Receivable late-payments database that has very basic fields: CustomerNumber, Name, BillToAddress1, BillToAddress2, City, State, Zip, Phone As we get changes from new invoicing activity, I need the table to update the contact info. So, we get a...

THANK YOU !!! Works great. I will add this to my code bank.

Hello all. I'm trying to open a document from a button on a form... as many others have done. Here's my code, that I based on successful code that opens an excel spreadsheet (edited as well as I could figure out for word)... but it fails on the Set objWdDoc line. Any help is greatly...

How about using some punctuation and syntax so what you're submitting can be understood?

I have successfully used the following code on the On Click event to open an email to the address shown in the subform's PrincipalEmail control: Private Sub PrincipalEmail_Click() Application.FollowHyperlink "mailto:" & Me.PrincipalEmail End Sub But, I would like to capture a subject line from...

Answered. Found the answer, quite by accident. Here's the first pass of code that makes it work: Private Sub Frame42_AfterUpdate() If Frame42.Value = 1 Then Me.PrincipalsInfoQuerysubform.Visible = True Else Me.PrincipalsInfoQuerysubform.Visible = False End If End Sub

I have five continuous-form subforms that I would like to set to invisible, but make visible based on an option group selection on the main form. If option 1 is selected, I want to see subform1, etc... and then be able to make the subform invisible with, perhaps, a subform button click so that...