Search results

This would maybe a good solution, but i have to think about the limitations. Eventually, I want to do some tests before loading the data and i wanted to use the sql server queries for this purpose.

Thanks for replying, this one does not work, I think it is because the tables in access are named with "dbo_" and sql does not recognize this. 😅

Hi :)! I want to load some data from an Access form into a sql server table, but i am facing some challenges. The data I want to load is from/displayeb by a "saved qry in Access", lets call it "qryAccessDemo". This query I use in a form form with some related criteria's. So when I have a form...

Thanks guys for thinking with this problem. I now choosed to go for this method.

Hi again, I have this problem with my comment form, where I want to autoresize the comment field to save some space when it is not used. What I found in a couple of threads is that this is probably not possible, since it is only possible within a report. Some sources I found: Not possible...

Thank you :D I had a look to your greate example files, i think i can implement this!

Hi, I have two problems which i try to fix: First problem: I have created a simple project form where i try to make an option to asign a person to a project by a combobox. In addition, I want to filter the combobox with the corresponding category from the project. My current method is that i...

Thanks! I have deleted the PK on table 2, I thought that CompanyID in table2 also needed the status primary key. Since it is the unique identifier of Table2. When I make it a foreign key, access recognizes the relationship.

Good morning :)! When I create a relationship in SQL server and add them in my Access database, Access sometimes does not auto recognize the relationship. I try to understand why this is happening. I have tried to restart sql server and relink/fresh the linked tables in access after creating...

Good evening, I have a form which contains a combox to select certain products. I use the combobox to fill in the form. This combobox is based on a qry with approx 50 records. Now, I wanted to make a search box in the form which can be used to filter the combobox so I don't have to scroll all...

So, if I understand you correctly. I have made something with local tables and used without releasing it a bug to reach my goal. Now I want to implement it in SQL and therefore it is not possible, because there the bug does not exist.. 😅 haha

Hi, I am having some trouble with Referential Integrity, hopefully somebody can help me in the right direction. I have two tables, 1.) tblA with products and 2.) tblB with the corresponding demand of the product. The two tables are linked together with ProductId column. My goal is to have a...

🙈

Yes Ma'am! ;) :oops:

Thanks for the advice. I have now implemented OpenArgs, this works best.

Okay @Pat Hartman, let me explain: When opening frmTableA the user sees persons (Name) with a corresponding id (NameId). When double click on a Name (record) form frmTableB opens. This form is related to TableB, with the columns NameId, FriendId and Friend. When this frmTableB opens by the...

Quite some code above my level haha 😅. But I want to learn, so I have tried to make something simple based on your suggestion (please see attachment). I doubt if "Me.txtNameId = Me.txtNameIdLoadValue" is the best way to do the validation. What do you think?

@Pat Hartman , I was reading your comment at 00:30 on my mobile before going to bed and hit the like button, since you gave me some eye openers ;) You gave me several options, so I am trying and playing arround to see which one is best for me to implement. Afterwards I will off course respond on...

I don't like the Idea that after opening frmTableB that corrupted data can be entered when first selecting a different record in frmTableA (*edit) and then refresh frmTableB. Having a possibility to enter biased data is not something I want. Therefore, when opening frmTableB, the NameId should...

I have fixed the schema, made indexes and define Primary and Foreign keys in my sql server :)!