Search results

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...

Here is the Query as mentioned shown below I thought I have it worked out with this join but still the same issue. Sorry this I don' understand completely.. allow edition is false is that a property on the form?

Hi MajP, thanks for your reply! Will check your answer with my database and hope to work it out! Getting back to you! Cheers

Hi guys, just wondering what the issue could be with following. I have created a form frmMietvertrag with a datasource of a query. I open that form from "frmTenant" The button is on the FormHeader Private Sub btnMietvertrag_Click() DoCmd.OpenForm "frmMietvertrag", datamode:=acNormal...

Hi, not sure if I understand the view you like to create but in Access this could be done via Reports. First you need the Datastructure to be in place then Queries, Forms and Reports. Those reports can be as you wish and have buttons which open the corresponding Datasheet of that product. Not...

Thank you MajP, I will look into it!! Cheers

Hi MajP, got it worked out :-) Many thanks that is great!! Cheers

Oh ok, I will let you know how I did manage :) Cheers just got it working with my new Version fantastic work MajP!! Many thanks

Hi, wow many thanks I will look into it looks damn good though :) Cheers!!!

In my database is now as the pic providet in this threat. tblAppRoom AppRoomID AppID RoomID AppRoomSize IsLivingSpace ....YesNo Unit I guess in the old threat there where still old namings

Yes sorry that is right mixed it with german oops I guess that was still the old version now as shown below in the pic are to updated fields it is now calles AppRoomSize just for your info

Hi MajP, thanks alot for taking a look at it! Cheers!