Consulting

Results 1 to 10 of 10

Thread: Take elements from database table to array using VBA

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. #8
    I wanted to create some custom function and it dosent work when I set strings.
    For Example,
    This works
    Set rst = CurrentDb.CreateQueryDef("Selected_Elements2", " SELECT * FROM  Population ")
    But this dosent
    Dim zzz  As String
    zzz = "Population"
    Set rst = CurrentDb.CreateQueryDef("Selected_Elements2", " SELECT * FROM  " & zzz & ")
    What's wrong with the second one?
    EDIT 2// Solved the second problem
    Last edited by alex009988; 08-10-2019 at 11:11 AM.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •