Search results

  1. M

    Inline Query using Inner Join and Group By

    Okay I have fixed the issue, I just used the SQL Query builder in Access to generate an "Access compliant" query. :p Thank you for your time and effort pr2-eugin, I sincerely appreciate it. If you are curious about the Access generated query, it is as seen below: sSQL = "SELECT...
  2. M

    Inline Query using Inner Join and Group By

    Hello pr2-eugin Thank you for the quick response and the warm welcome. :) I have tested the query as it is in a Normal SQL Query window and it returns the correct result - ID:158 and GroupName:XPUb The original query attached to the combo box is as seen below: SELECT Store.ID...
  3. M

    Inline Query using Inner Join and Group By

    Hellooo, I have a bit of an issue regarding an inline query in Access 2010 - I am currently using INNER JOIN and GROUP BY to narrow down the RowSource of a combo box based on the value selected in the active combo box where the code is located "onClick". The value being selected is a StoreID...
  4. M

    Windows Server 2008 R2 IIS Access is denied on Port 80

    Hi there, Thank you for taking the time to view and potentially assist me in my issue. I am an Access(and IIS) newbie. I am currently running an Access .accdr file from a remote Windows server through System.Diagnostics.Process.Start("REMOTE_SERVER__FILES_URL"). The reason I am doing this is...
  5. M

    Thanks for having me from South Africa

    Hi there My name is Chris and I have been a PHP developer since 2006, yet recently I have delved into Microsoft's world of Access. I have been developing VB for about two months and have thoroughly enjoyed the language and I am always keen on learning more. My hobbies are bagpipes, programming...
Back
Top Bottom