Search results

Thanks Mike, I know there are always many ways of doing things not just in Access ) But I will try to get it working for now and will let you know how I am going! Cheers for your input it is much appreciated! Albert

Hi Mike, yes it got me on the way I will keep you posted on how I am going. Unfortunatelly now I have not that much time anymore with my new work. But I will try to let you know how I am doing! Many thanks Albert

Hi Mike! Many thanks for your input! I will have a close look at your form and will go back to your! Seams we are getting somewhere now ) Cheers! Albert

Hi Mike! Yes that looks pretty good too I was just wondering how I can get it all working within the form! Still struggling a bit with it. But was not here was working so just got back. I will take a look at it again ! Cheers )

Ok thanks I will try )

Ok I am getting again somewhere ) Got the comboboxes sorted in the mainform and use now a subform to list all the entries on the StockInventory. However the subform still not show the correct or all the fields in the subform. Only some are missing and still need to work on that.

Ah ok sorry I created a blank database from what I had in my original Database. I know the cascading combo is maybe not the issue the issue comes done to the different linked tables what throws me off. I will add that query in a new Database maybe it is just a small thing but for me it is a big...

Hi Gasman, yes that would be also good! But as I mentioned somehow I was not able to get that happening.. either the combos did not filter correct or have been not filled correctly or filtered correctly and so on.. Is there a chance you could look at my situation and create a subform for me...

Good Morning and thanks for your replies. I was hoping that someone could give me a query that I could use to get this split form up and running. For me I had no luck so I was trying ways around it but without luck. I like to be able to have a cascading Combo to choose Filter Profiles depanding...

Hi again guys! it's been along time beeing here hope you all doing well! I have a new work so that is why I had not much time beeing around for the last past year! But I am getting back into it and after spending a day on one form I am hoping to get some help from you guys. I have attached a...

Hi Isaac, all good just did not know and it is nice that you are pointing this issues out!

Ok thanks I will need to look into it a bit more )

hmm ok.. What I did try was in one new module using Compare Text and it was working as Josef discribed.. But still very confused about this lol (

I tried with option compare Text.. getting an Error sayin it is used serveral times ?? Does this statement not come on top of the Module like Option Compare Database Option Explicit Option Compbare Text I have nowhere a option compare Text in my database so not sure what this error means and...

Oh I see says the blind man ) I will do that and let you know how I went with it! Cheers for making it more clear to me )

Hi Josef, you making me looking bad very bad lol 🙄😳 I have no clue what you are saying at this point oh my gosh ;)

I understand what you mean.. well I hope it is robust enough for what I am doing. But many thanks for pointing out those possible issues!!

Yes I guess so but it is still a bit much for me to handle all propabillities. For one statement over a year it is working as intended need to look for other years and check there will be for sure more to do or do update different functions. That is why RegEx comes handy but I am still very...

Hi David, my function returns everything after the Mandatsnummer: xyz to the REF: so everything in between. It is a bankstatement as you for sure guessed but there are as always many different ways they provide the Data. And in some I just need what ever is after the Mandatsnummber:xxx and...