Search results

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.

I can’t help but question the hard-coding of values in expressions. I would think that the values might be unique values in a lookup table. Perhaps you want to include or exclude #7 and #9 in the future. If possible, I would add a field to a table that would group/categorize these values. Data...

You could also try: [NewLineDesc] Not In ("#1", "#2")

I didn't think it was too much older than 10 years so I googled it. There are a number of dates starting in 2011 but it suggests a public release in 2015

PBI is only 10 years old. To me, “500 forms” makes PBI even more attractive.

I would consider using PowerBI.

You could remove the qryOutstanding stuff and use a domain aggregate function like dLookup().

The OP stated “When I save the form filter” which isn’t the same as QBE.

I never use the table name in these situations. This also assumes you won’t have repeated field names from more than one table.

I don’t find it misleading. I don’t think it mentions “container” and it accurately describes “select all the controls”. I’m happy with the help text as you quoted it and have always expected the behavior.