Search results

If you don't have certain tables, can you provide some clue as to what causes you to have hundreds and why they are growing. Do any of your tables have similar structures? Help us understand what you have created.

I would use code like: Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer) Me.Last_Name.FontBold = Not IsNull(Me.DateOfDeath) End Sub

I replied from my iPad and expected the OP to give it a try and come back with questions. Creating a function allows you to encapsulate the logic into a single object that can be used over and over within an application. If/when the logic changes, you have one place to look. Here is a...

Create a small used-defined function that has the three fields as arguments. The function will provide comments and easily understood and updatable logic. Nested iif()s should be avoided.

If you feel a pain in your chest (even if for just 5 seconds), don’t ignore it. The same is true for other symptoms.

👈 As per my image, my heart stopped (sudden cardiac arrest) two years ago at age 69. I can verify, getting old is better than the alternative. I now have a valid reason for lapses in memory. I recommend a coronary calcium scan for people over 60 particularly if you experience any heart related...

Does MySQL support MVFs? I believe there is a recent thread in the Forms forum discussing this functionality.

Have you tried creating an additional column with the field in the Format() function? DateMMYYYY: Format([DateField], "mm/yyyy")

I don’t know about others but I think this thread has run its course (and then some). This should have been posted in the Site Suggestions forum. This is similar to the great idea to create a new thread regarding MVFs.

Hi Joan. Welcome to AWF. I assume you are the famous Joan Wild, former MVP!

If you haven't split out the data tables from the other objects, how do you intend to provide updates to your users? When you send them a new application, it will overwrite everything they have added in terms of records? Is your application read-only? On a side note, it seems like a waste of...

I don’t believe @DakotaRidge has ever stated the full contents of what is contained in the post. Was there an attachment, image, link, script,…?

This is the 79th post in this thread which should have moved to the Watercooler 70 posts ago.

I was a Microsoft MVP for 15 years, consider many here as personal friends, and have been contributing to these types of forums for over 20 years and I had to patiently (not really) wait for my 100th post.

There are specific rules defined in this forum that don't allow some types of content in posts from participants with less than 100 posts. I recall watching my post count grow to 100 so I had full rights.

Great to see you here Ken.

@Woodpecker has had less than 40 posts.

Place a text box in the subform header with these properties Name: txtAmtTotal Control Source: =Sum([UnitPrice]*[Quantity]-Nz([Discount],0)) Then change the text box on your main form to: Control Source: =[SaleDetails].[Form].[txtAmtTotal]

Can you take a screen shot of your error message or is that prohibited also? We can't see your screen.

I believe the number of posts required is/was 100.