Search results

Hi guys, thanks for the discussion this is bringing some light into my question ) However as I read through your thougts I was wondering to simpify it can you just create some kind of Switch Board in the "Master DB" to open one DB work with it and if finished just close it? And if you need to...

Ok thanks MajP, I will look into it a little more and see how I will go about it! But thanks for explaining :) Cheers

Hi MajP, thanks for your explaination! Ok well I thought for my business it would be nice to have one "Application" to do it all but if that is not a good practice I will overthink it again ) Cheers Albert

Lol really hihi I will try many thanks ) Not sure how you use chatGPT need to look into it I guess )

Hi, there are not always the same as mentioned once I use a query to filter it out. And I am used to use instr or instrRev functions to get the possitions as you mentioned but was wondering if there is in Reg Ex a simpler way of doing it. I will try anyway with those functioned mentioned ) Cheers

Hi thanks for your input! Ok understand! Cheers

Hi guys, I know some of you guys are pretty awsome in Reg Ex but I am not lol--- So I was hoping for some help with following String Kunner GmbH Oberwasser 69 AT 6666 Walddorf IBAN: AT75 1683 0021 0000 0166 DOC/2319/2667.60/20220729 REF: 195302208230116494800000001 Josef und Anne Schöller...

Hi guys, I got different Access Databases and was wondering if I can make one Application to Access those different Databases. I am aware of linking data to another database and so on but is it possible to have say one Database to access different Databases something like one Form that can open...

Hi MajP, many thanks for your help that is it!! Fantastic! I found Format and Currency but not the whole statement! Cheers! Albert

Yes Gasman :( Euros in my case )

Hi guys, I guess it is a simple question and answer but I can not get it to work. I like to use bookmarks to fill a word ducument but need Euro Currency for the amount. .Bookmarks("vv_AppBrutto").Range = Me.txtAppBrutto.Value this is what I got at present. How do I need to change it...

Hi arnelgp, many thanks yes that was it many thanks! Cheers Albert

Hi guys, just wondering if someone hast already come to a similar issue. I have create a word template with bookmarks. After I fill those bookmarks with a decimal number say 52,23 as shown in the form it displays the number 52,2345647854 I have in the form set the properties of the textbox...

Hi guys, many thanks for your replies! I will take a look at it and get back to you! I am trying to use different joins but often I get an error that is not allowed to use inner joins or left joins so I need to understand this more where you can use it or not. I will try and as I said get...

Good Morning Access People ) Some Changes for your understanding: I have renamed my form frmMietvertrag to frmRentalAgreement Below the Current TestVersion with all Queries & Forms Many thanks for taking a look at it Cheers Albert

Oh, it works only if I got no appartment selected if there is an appartment selected and not all fields are providet then I get again an empty form .( it is getting late on my end I will take a rest from it for now. @MajP I will give you tomorrow the info! to all others many thanks for your...

Yes I did try it, so the form below allows me to enter Tenant Informations. the sfmAppartmentTenant is shown as Wohnungen if there is no Appartment is selected the btnMietvertrag shows me the Messagebox if there is an appartment selected it will open the form and get all informations. Not good...

Hi MajP, thanks for your help!! As my workflow is a little different I think all I need to do to prevent the frmMietvertrag to open if there is no Appartment selected for the Tenant is following Code. Private Sub btnMietvertrag_Click() If IsNull(Me.sfmAppartmentTenants.Form.AppTenantID)...

Ok I understand, and sure it does not make any sense to write a document with missing information. So I guess I just ignore the fact of no data or controls are displayed and return to the forms to enter approbiate data. I also treet the frmMietvertrag supose to be called frmRentalAggrements...

Hi Gasman, I guess this are the properties you are refering to? Below the pic. So is it set wrong? Perhaps is the same location in english versions of access? Does any of those need to be set to NO? Sorry not sure?? Löschen zulassen = allow deletion Anfügen zulassen = allow addition...