Search results

  1. L

    INNER JOIN problem

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

    SQL issue - Select multiple fields from multiple unrelated tables

    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 " _ &...
  3. L

    Managing strings via VBA

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

    Please help. SQL Problem giving a ComboID

    [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...
  5. L

    Problem with Do Until

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

    Problem giving control name as a argument .

    Good evening , dear programmers . I have a small problem (hope solvable :) ) . I am designing a Public Function F() I want this function to populate value from a any field selected from any table to any text box in any form ...... Sounds a bit crazy probably but I will try to explain my idea ...
Back
Top Bottom