Activity Stream

After a bit of testing with the attached data base, I wasn’t able to find a format for currency that does what I want. It makes no sense to put in a...

Never...yet! It will happen at some point!

I'm happy to offer my db however it would require some tweaking to share as it contains some user interface functionality. I'm unable to do this at...

Dim tPGM as integer (or long) . It has to be numeric. You could use CInt(tPGM) also.

Thanks guys, we never deliver to any postcodes that close, the competition un the market is too great but your right if we were door to door then...

Time to check your version, and roll back on a PC.

Oh, that linked thread is not yours? :sick: So maybe Office365 update has bug people are now stumbling over. Maybe rollback and see if issue goes...

Interesting that the thread in your link mentions an Office365 update on June 29th, 2022, that's probably it :(

Thank you for the feedback June... The files are updated every month (from a government website), last updated was about 3 weeks ago and everything...

Also at https://www.utteraccess.com/topics/2063554/posts/2801665 You say the same text files used for years - so names are the same but the...

No- just remove the entry should be able to - avoid using the format function if you can as that will convert a number to text - which a) will...

I think I hear what you're saying and it makes sense for tables. So far, I'm just designing tables. It seems the format property is there, so you...

Here's what I found: Microsoft Access tips: Currency format (allenbrowne.com)

personally I would not use the format property in a table at all (although I guess there may be a reason somewhere, but can't think of one, perhaps...

No, I don't understand why this happens. Want to provide db for analysis?

Thanks, June7! I've been tinkering with just the "1" condition. It's not working and I suspect it's because the count of the subform is completed...

Here is a good explanation of why to use currency: Field Types in Microsoft Access (eggerapps.at) I went back into the design view and saw this: ...

Hi Set the field as a Number and format as Standard

that's it!

Then I think you'll need to reset the the format property everywhere that it's used.

At this point, I just want Access to show currency without the $ everywhere. Like it's supposed to.

Try the following line of code in the forms OnCurrent event: Me..Format = "Currency" I suspect (from the screen shot in your post) that you...

Create a currency table, don't put it in country. Some countries use the currency of a "parent" region (Euro) or of another (Ecuador). Then you can...

No problem, when you are ready, it's always difficult when you are just starting out. Just be aware you know your business and we don't. So you need...

After reviewing for a few days, it seems this is down to load issues around my location. Thanks for the suggestions guys, always handy to know of...

Sorry, forgive me I am new to posting and a novice at access. I suspect a lot of my design violates normal database design. I will try and figure...