Search results

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!

Hi guys, I am starting a new threat but it does relate to my previous question on following threat https://www.access-programmers.co.uk/forums/threads/query-combining-records.333010/#post-1947330 Not sure if that is how I suppose to refer to the other threat hope I did that right? However I...

Hi Pat, thank you for your explaination and your link to your databases! I will look into it and if there are questions I will let you know! Many thanks! Cheers Albert

Hi guys sorry if it was not clear, normally I use as suggested access to handle forms and it works perfect. However I was wondering how to create it with recordset. Here is a code snippet what I have in Form1 Dim db As Database Dim rst As Recordset Private Sub Form_Load() Set db =...

Hi the DBguy, no sorry that is not what I am looking for :( But thanks anyway ) Will try to work it out...

Hi guys, just wondering how to go about using an unbound form and a Country Combobox to select or choose the approbiate country for the record. I use an unbound form and fill Data with Recordset. However there are Country and Salution linked to that table and I like to use comboboxes to...

Hi thanks alot theDBGuy!!! Fantastic and yes it works just great! Just what I have been looking for! Also thanks to gasman for your help and input!

Hi Gasman, thanks for your reply I will look into it an get back to you! Many thanks Cheers

Hi guys, thanks for your replies. I have included a sample Database with the Code providet but not sure how to get it in my case working. Maybe someone could have a look at it please? Nice greetings Albert

Hi guys, I got the same issue but using a n:m relationship for Appartments, Rooms, and AppartmentRooms 1. tblAppartments 2.tblRooms 3.tblAppartmentRooms as linked table I like to have one query which gives me all the rooms listed in one appartment in one Column. Appartment Top 1, Kitchen...