Search results

  1. S

    Query to SQL linked table not returning values

    Thanks arnelgp that worked a treat. Probably a separate question - is there an easy method to convert this query to an MSSQL based query? I can obviously copy the SQL from Access but MSSQL doesn't seem to like this format? Thanks again :)
  2. S

    Query to SQL linked table not returning values

    Perfect thanks, I think I found another peculiar issue. The record is stored in uppercase and my search will only return the values if I use upper case - is there a way to search upper and lower?
  3. S

    Query to SQL linked table not returning values

    Hi Plog - thanks for the quick reply. I managed to get it to work in a fashion, so the below query works if I put in PLC as a search SELECT scheme_plsuppm.name, scheme_poheadm.order_no, scheme_podetm.long_description, scheme_poheadm.[date_entered] AS [Order Date] FROM (scheme_plsuppm INNER JOIN...
  4. S

    Query to SQL linked table not returning values

    Hi, I have a couple of linked tables from SQL (I prefer to use the built in Access query builder to build queries) in Access O365. If I create a query using the like parameter with a wildcard I don't get any values back but if I just query the actual value I do. I could give an example but...
  5. S

    SQL Select statement help please

    I only want to show the values within table1 but use the material values which are stored within both tables to get the results and (as you can with Access) create a field which displays the material name because obviously the material is null within table1.material which equals...
  6. S

    SQL Select statement help please

    Material is on both tables because its part of a transaction table so some values are null others are the material. Ive tried an inner join which doesn't work. I was thinking create two separate queries and then union joining them but that doesn't work either.
  7. S

    SQL Select statement help please

    Hi guys, I cant get my head around what appears to be a simple sql select statement and was wondering if someone can help me please? I have 2 tables table 1 has all the data Im after but is linked to table 2 by a Request_ID Field. They say a picture paints a thousand words so...
  8. S

    Can anyone see whats wrong with my code please?

    I still cant get it to work, if I debug.print it the date ranges are correct but it seems to only filter on the second value not the first. So I get all results up to the entry put in the second control box.
  9. S

    Can anyone see whats wrong with my code please?

    Thanks, so based on your example you seem to have mm/dd/yyyy am I not able to get the user to input dd/mm/yyyy? I understand that access see's the date as mm/dd/yyyy but I think this will just confuse people. Thanks
  10. S

    Can anyone see whats wrong with my code please?

    Hi, Trying to export values from an Access table no matter how I format the date it doesn't export properly (the export works but the date specified is ignored) strFile = "C:\" & Format(Date, "ddmmyyyy") & ".csv" strDateEntry1 = Format(InputBox("Please Enter From Date...
  11. S

    Automatically linking an ODBC connection

    Taken from a Microsoft Example: '//Name : CreateDSNConnection '//Purpose : Create a DSN to link tables to SQL Server '//Parameters '// stServer: Name of SQL Server that you are linking to '// stDatabase: Name of the SQL Server database that you are linking to '//...
  12. S

    Automatically linking an ODBC connection

    Hi, Im looking to automate the process of linking my Access DB with an ODBC connection to an SQL DB with VBA (unless theres an easier way to do it?) - can anyone either point me in the right direction of some sample code - that's if this is possible at all? Thanks
  13. S

    Importing users from AD into a table

    It didn't return the department, instad I opted for some different code which works fine - thanks. Public Function AdUserInfo() As String On Error GoTo ErrorHandler Dim sysInfo As ADSystemInfo Dim oUser As ActiveDs.IADsUser Dim LName As String, FName As String Dim LoginName As String Dim...
  14. S

    Creating a list based on multiple queries

    Strangely enough it now works - bizarre :)
  15. S

    Syntax Error in INSERT INTO - but I just cant see what it is?

    Easy when you know how :) thank you
  16. S

    Syntax Error in INSERT INTO - but I just cant see what it is?

    Hi, I cant seem to get my insert statement to work, Ive checked (although I could be wrong) for reserved words and I don't seem to have any. Ive declared what the fields are so that should be ok, it just wont insert: Dim sEmployeeName As String Dim sLogonAccount As String Dim sDepartment As...
  17. S

    Creating a list based on multiple queries

    Hi, I have 3 select queries which Im trying to output to a combo - Ive tried a UNION query but I get an error ODBC-- call failed ODBC Driver SQLBase..... Firstly is do the results need to match within a union query? I mean they have no relationship what so ever Im just trying to populate...
  18. S

    Importing users from AD into a table

    Just to open an old thread Im now trying to add additional AD fields into my form - some work but I cant get other to show, like Department or Description for example. I thought if I add them to the query, in theory it should pull them through Public Function UserFullName(Optional ByVal...
  19. S

    Importing users from AD into a table

    never ceases to amaze me how clever people are, also this link made me re-think my process. I didn't need to populate a table in the end just use the logged in username and pull the first and surname from it. Thanks again :)
  20. S

    Importing users from AD into a table

    Hi, this did exactly what I wanted - I was wondering can this be modified to work on security groups rather than members of an OU? Thanks again
Top Bottom