Activity Stream

Perfect... I'm still learning the intricacies of Access forms. Thanks

I've used this idea for many, many years. Here is my example of what Micro described.... (using only CF)

True, but while it's populating the continuous form, only the first record is "current". OnCurrent for a row will fire only when the user moves to a...

Don't agree. It fires each time you move to a different record, either via navigation controls or scrolling and choosing another record. Regardless,...

I had/have an outlook calendar style db but can't locate it just now. I'm thinking that instead of creating appointments you'd create orders. Perhaps...

Thank you both for those replies. I will see if I can implement either of those options, though it seems I have a lot of learning to do, and maybe I...

I only created a basic framework as an example. I'm sure you can improve on that. Anyway I've left you all the hard work to do. On a button click...

Hello Thomasso, this has given me inspiration to spice my CRM application up that I have been building since May last year! I'm going to crack on...

Have you created an ODBC connection? There are lots of videos to watch on Youtube.com - here are a few How To Migrate Microsoft Access Tables...

Brilliant, I didn't expect that you would actually create the thing... Thanks so much! Sorry for being ignorant, but how do I set the source object?

tblSuppliers * DiscountPercentageID = Number tbluSuppliersDiscount * DiscountPercentage = Number

Agreed. OP, double check that the datatype for wherever 0.025 is coming from isn't a string. Playing around with this on my end I could only...

What did you do? I'm still struggling to get it to display 2.5%.

The process behind the logic is when a Supplier is picked, the orange blocks are updated and in return the visible white controls to the left display...

The box in orange is formatted as Percent, however, the value is 0.025 when it should be 2.5%.

After testing that access throws the code out like this ""=For"m"at(,Percent)"

Hi That works just great. I can see the Login in the pattern what I get lost on is the basic syntax Many thanks :)

So make them a new tenant.? Add a field as to previous tenantID for your history. Either that, or change your receipt process to store name/id at...

Yes, it does Mike, you are just fortunate that as they are boolean, it will work. :) You could just as easy have 30 If Me.Toggle0 Or...

Hi That part is relatively easy to create. The screenshots below show how I would do it. Doing that took about 10 minutes to create Design View...

This would be the pattern Private Sub cmdFilter_Click() Dim fltr As String fltr = "" If IsNull(Me.Toggle0) Then...

Hi KD2017 So building on those 2 Toggle buttons working how would I modify the code when I have 4 Toggle Buttons like this:- 30 If...

Hi Cancel my last I closed the Form and Reopened and it now does exactly what I need. Many thanks for this :)

Shouldn't the message be something like 'Missing Endif'?

It looks you're trying to be clever around line 30 and 40 but it's not working out. Try this from post #14: Private Sub cmdFilter_Click() ...

Hi I tried this: Private Sub cmdFilter_Click() 10 On Error GoTo cmdFilter_Click_Error

That's strange, it works just as you've requested on my machine. Can you post your latest full code or db?