Search results

  1. Freshman

    Concatenate fields in related tables

    Thanks - I will add it to the notes :)
  2. Freshman

    Concatenate fields in related tables

    Thanks - will ask him about his backend as well. Not sure. They are a 3rd party who is supposed to work with us but keep thing close to their chest while still not delivering. Yes I know :)
  3. Freshman

    Concatenate fields in related tables

    Thanks - yes I can do it with a function but it's not me that needs it this time. I need to give the SQL to another developer not using Access. I'm waiting to hear that language he is using but thought if I could give him something in pure SQL it would be eaier for him. Anyway - will wait for...
  4. Freshman

    Concatenate fields in related tables

    Hi all, I need some help with the following please: I have 2 related tables (on Field1) and I want a query to display the "concatenated" data without using a VBA function. Thanks a lot!
  5. Freshman

    Creating DSN connection

    Thanks - I'm wating to for the support session on zoom later today so will discuss this with them then as well
  6. Freshman

    Creating DSN connection

    Thanks I have tried that and various other name options but none seems to work. I've managed to book a service call with Actian to assist me tomorrow. Thanks everyone for their input. I hope to get a soltution tomorrow!
  7. Freshman

    Creating DSN connection

    Pervasive PSQL is SQL type database previously known as Btrieve. The Software company is actian.com See installed Driver below in the ODBC
  8. Freshman

    Creating DSN connection

    Thanks but Pervasive does not appear there. I can connect without a problem but only if I setup the DSN in the ODBC first. They I don't even have to spesify the driver. My goal however is to create a DSN from scratch so that I don't have to first set them up at each User since there will be lots...
  9. Freshman

    Creating DSN connection

    This is what I tried again getting either error 6 or 11 - Google did not help me find that those error code mean?? ''Driver = "HFSQL" ''Working ''Driver = "Pervasive ODBC Engine Interface" ''Driver = "{Pervasive ODBC Engine Interface}" ''Driver = "Pervasive ODBC Unicode Interface" ''Driver =...
  10. Freshman

    Creating DSN connection

    I googled for some help and found this code which I modified a bit. (I tested with HFSQL which worked fine) But with Pervasive I get DSN creating failed: 6 Const ODBC_ADD_SYS_DSN = 4 'Add a system data source Private Declare Function SQLConfigDataSource Lib "ODBCCP32.DLL" (ByVal _...
  11. Freshman

    Creating DSN connection

    No I did not - not sure how to. Function/Method not found. SQLConfigDataSource is declared like this: Declare Function SQLConfigDataSource Lib "ODBCCP32.DLL" (ByVal hwndParent As Long, ByVal fRequest As Long, ByVal lpszDriver As String, ByVal lpszAttributes As String) As Long Should I then...
  12. Freshman

    Creating DSN connection

    Hi, I made sure all is 32-bit including Access thanks
  13. Freshman

    Creating DSN connection

    Well I read and tried a lot of diffrent option but still no luck. sonic8 or someone else who can help with the correct syntax to create a DSN from scratch would be very helpful. Public Function CreateDSN(strDsn) Dim vAttributes As String ''vAttributes = "DSN=" & strDsn & ";Description=Pervasive...
  14. Freshman

    Creating DSN connection

    Ahh - thanks a lot for the link - that might come in handy. Will go through it now.
  15. Freshman

    Creating DSN connection

    HI David, thanks for the reply. I did not post the entire code since the rest is standard. I delete the table, then recreate it yes. I normally use the User of System tabs but I tried the File tab as you suggested. It also stopped hafl way with the same error but it did create a DSN file with...
  16. Freshman

    Creating DSN connection

    Hi all, I'm trying to go the DSN-less route for a few databases. 1. mySQL = Working 100% 2. HFSQL got it working with this code: (locally hosted database) Public Function CreateHFSQLDSN(strDsn) Dim vAttributes As String vAttributes = "DSN=" & strDsn & ";REP=C:\PathToLocalDatabase\" & Chr(0)...
  17. Freshman

    front.com instead of Outlook

    Thanks a lot - that is helpful. Have a great day
  18. Freshman

    front.com instead of Outlook

    Hi all, Our company has started using Front instead of Outlook and was wondering if emails can be sent via Front instead. Is there a createobject option that can be used or some library that can be installed? Simply setting Front as the default email client does not do the trick. Thanks
  19. Freshman

    Convert PDF to Doc

    Hi all, I'm using the code below to convert all pdf files in a folder to txt (in bulk). The metode below uses MS Word to do the job but since I have hundreds of files to convert I was wondering if there might be a faster way. I don't want to use one of the many online/website option since I...
  20. Freshman

    Modern Chart System resource exceeded

    Something else to add is that I did not previously tried the old charts since I moved over from the continuous Form to the Report. I however tried it now and it works 100% in the Report but it looks soooo 1980! At least the fact that it works smoothly without the other issued like point 2 above...
Top Bottom