Recent content by Lestatos

Now it worked as well as expected ! Thanks a lot , pr2-eugin ! Nice day .

Thanks for the answer , pr2-eugin . Now I put the code on the on_change event of combo_sel_project and when I change its selection and try to drop-down the combo-sel-company I get : " The specified field "Comp_ID" could refer to more than one table listed in the FROM clause of your SQL statement...

Yes , the first column of the combo is the bound column . Indeed my idea is to update the Combo_Company after Combo_Project is changed , so it lists only the companies who worked on ProjectA let's say . I thought that SQL would help , but it seems I am wrong .

The bound column for Combo_Sel_Project is Column0 and the type of Comp_ID in Table_Projects is Number .

Good day , guys . Small problem ... SQL related I have 2 tables and one combo refreshing other combo Table_Companies : [Comp_ID] [ Comp_Name ] 1 Comp_a 2 Comp_b Table_Projects : [Project_ID] [Comp_ID] [Project_Name] 1 1...

Yes , both tables have data that is related to a single Employee , but I didn't use Access Relationships Tool , I want to do my complete database via VBA or SQL . May I ask a question - what exactly should I post ( attach ) so it would be useful for you to help . ( Like - Table , with data on...

Good evening , plog . You can see the attached pictures of the tables I want to query . And here is the code what I want to run ( a little explanation is below :) ) : Public Function CreateDynamicReport(strSQL As String, sname As String) Dim db As DAO.Database ' database object Dim rs As...

Good evening dear programmers . A small issue I was wondering of for a few day . Is it possible in SQL query to SELECT multiple fields from multiple tables ? Example for the question is dim my_var as String my_var = "SELECT Emp_FName , Emp_LName , Emp_Adress " _ & " FROM Table1 " _ &...

Good evening dear programmers . Well my current question is basicly theoretical . I think it would help also other beginners in VBA programming in Access . Here is the explanation of my question : - We have a few tables with different information - We have a public function called...

RuralGuy - Thank you ! That was really usefull . I changed the variable type (checkvar) to Long and the removed the single brackets . Then the CreateDynamicReport function just did its job without any mistakes . If we were at the pub now you have one Jack bottle from me ! :) My best regards...

[SOLVED]Please help. SQL Problem giving a ComboID Good evening dear programers. Running the code below : Private Sub Command299_Click() Dim selection As String Dim sname As String If IsNull(Me.cmbWorkerNameReport.Column(0)) Then MsgBox ("Choose Worker !") Exit Sub End If Dim checkvar As...

Wow ! :) Thanks a lot . That was really the perfect solution for my problem ! Good luck and thank you again .

Good evening dear programmers . I have a problem for which I didn't find any information in Google . Here is the problematic code : With paymentid Do Until employeeid.EOF = True .FindFirst .Fields("Emp_ID") = employeeid.Fields("Emp_ID") If .NoMatch Then...

:) Hahaha yep it was hot - indeed - for the moment I am beginner in programing at all ( well - back in the schoolyears I studied C++ but that is another story ) - so everyday staying infront my computer and trying to add any new idea to my Access project I turn back to hell :) . Thanks for the...

JHB , Thank you really a LOT for the handy answer ! You got me out of the hell . :) I hope that answer will help also other beginners . Best regards !