Search results

Yes that is correct, i have now fixed it within the database :)!

Hi, I have frmTableA (persons) and want to open frmTableB when I double click on the "Name" column from frmTableA. frmTableB opens the TableB (friends) table, where friends can be entered which need to correspond to the NameId from frmTableA. Opening frmTableB I have managed by a small vba...

The problem was solved by the following: 1.) Use ODBC Driver 17 for SQL Server instead of SQL Server for linked table connection 2.) Use Mixed login method instead of Windows Authentication. Now everything works like a rocket 🚀

Hi Mike, I forgot to delete the "ClientProdID", which is used to link the data to another subform. Which you guys teached me in my first post...

Please see attached file. When opening form "frmClient" it takes about 20-30 seconds with linked tables. In the uploaded database I have made the tables local.

Well I was to fast. The form load and works instant when I make from tblClient a local table. Unfortunately, when I leave tblClient as a linked table it takes the form 20-30 seconds to load. When it is loaded it works stable. It is strange, since I only do the following: "right mouse > make...

I think it is because I have put in the tblClient into the query. Now it works instant, when I delete this tbl. Thanks for the lessons, I really have to keep in mind to think like a data waterfall haha 😅

Thanks! When I take your solution the initial load of the form takes sometimes 30 seconds. When the form has opened, all data population works instant. This is with all the linked tables. Is this just the downside of using linked tables? Looks like their is no smarter way. By the way, I have...

Please see attached database, where i have recreated my db. I have converted all linked tables to local tables. However, in my real database Form1 acts unpredicatable fast and slow after I add the combobox. I have applied a filter on customer, but don't know if this is the most efficient way to...

Is it logical that loading speed / performance is dropping when adding this combobox to the form. This form is a subform in another overview and when I add the combobox the performance is significantly dropping...

Thanks for the reply both :)! This helps a lot. Just for my understanding: If they are not linked by the query, how does access know to take the StatusId and not the Status? Because 2 columns are in the select statement (1.)StatusId, 2.)Status) and then with setting "Columnwide > 0cm,2cm" Is...

Hi Thanks for the quick reply. In your DemoDB each time a new record is put in with for example Status "Open", it will create a new StatusId 😅

Hi again, I try to understand what would be the best way to update a status field in a table by my created form. Situation is the following: tblRequest has a StatusId, which is linked to tblStatus. I have created a form with and have placed the StatusId with standard value "1" (corresponding...

Thanks for helping me out, I have played arround a little bit and forgot to tell you that all my tables are linked tables. So the Enforce RI I should arrange in SQL server, moreover the Datamacro also don't work with linked tables what I see. Eventually I have created the following VBA code to...

Maybe it is a stupid questions, but i don't see datamacro1 in the sample file? Edit: a wait, that is a new function for me, i see it now. I am going to investigate :)!

Goodmorning, I am struggling with one of my queries. Basically their are two tables, which are used to build a query to populate data. Table A: ProductID = PK CodeId Description Table B: Id = PK ProductID > multiple ProductID of the same can be exist in this table CodeId Color Active > Their...

Thanks for sharing your idea and code. It is funny since i was thinking to create some sort of conditional format to highlight the selected row. In order to prevent confusion about which Id gets the comment. Till now I have made showing/hiding as in the attached demofile.

I will look into "Open Args", thanks! I now update the Friend table by using this code when I add a friend. Private Sub Friend_AfterUpdate() Me.Form.PersonId.Value = Me.Form.txtPersonId.Value End Sub Dont know if this is smart to do, but it works haha If i understand "Open Args" correctly, the...

Yes! This works and fixes the problem :) However, I also want to understand which method is best according to "the book". The reason why I put in Friend as a subform is that i want to put in a second subform in FormB with for example comments and is related to the Friends form in FormB. I am...

Okay, I understand, but i know how to do that. I want to create a "pop-up" form instead of putting it in the same form for saving space in my actual database.