Search results

  1. 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!
  2. 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)...
  3. 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
  4. 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...
  5. Freshman

    Modern Chart System resource exceeded

    Hi all, I'm getting a "System resource exceeded" error when inserting a Modern Chart into a Continuous Form. The old charts do not allow the option so the modern charts work great except for the error I'm getting. 1. It does not come up every time - maybe every 3rd time I open the form. 2...
  6. Freshman

    Existing line breaks in textbox not showing

    Hi there, I have a textbox based on existing data from a table (Long Text field data type). I don't have control over the input of the data which is done via a website but it appears to have linebreaks because if I copy and paste the exact text into Notepad, it shows with linebreaks, but in the...
  7. Freshman

    NumberFormat

    Hi all, I have a csv file that I download and then import into an Access db. There are around 100,000 rows One of the columns contains a serial number which could look like a number or text. Some containing only number and others a fix of letters, numbers and even symbols. After importing it I...
  8. Freshman

    Acess 2010 - 2016 upgrade errors

    Hi all, I got a call from a Client who has been using an Access app for about 18 years (I imagine multiple Access versions in that time). The app is used on most machines runnnng Access 2010 without a problem. Last week two machines were upgraded to 2016 and now those 2 machines have errors...
  9. Freshman

    Count number of flagged Emails

    Hi all, I'm using the code below to count the number of emails in an Inbox but I want to narrow it down to just the flagged emails. Sub HowManyEmails() Dim objOutlook As Object, objnSpace As Object, objFolder As Object Dim EmailCount As Integer Set objOutlook =...
  10. Freshman

    Listbox.requery

    Hi all, I searched for posts on the above topic but could not find an answer specific to my issue. I use currentdb.execute to insert a value into a listbox and then update the listbox using me.notelist.rowsource = me.notelist.rowsource Me.NoteList.Requery If IsNull(Me.CurNote) = True Then...
  11. Freshman

    Listbox update unknow

    Hi all, I'm working on a app created by an unknow developer. In the one form (unbound) there is a list box being populted from the sub below. But I can't seem to find the table or query it is refering to. I would appreciate some advice on where to look for it. Do I need to post extra info...
  12. Freshman

    Pervasive Connection String

    Hi all, I'm using the following connection string to connect to the "P000Lap" Pervasive database from within Access tdfLinked.Connect = "ODBC;DSN=P000Lap;DBQ=P000Lap" However I would like to connect to it from PhP. At the moment I'm connecting to a MySQL database from PhP but would also like...
  13. Freshman

    Life after VBA

    Hi guys, My goal this year is to learn a new language, but a more "modern" one that would be in demand for a possible career. VBA tend to be seen as "old school" compared to the new web focused languages. Someone suggested Python as a good option but I want to know from my fellow VBA Developers...
  14. Freshman

    MySQL connections

    Hi all, I've been starting to move my tables over to MySQL and everything is working fine so far. The only question I have is around the steps I follow: 1. I installed the MySQL ODBC drives 2. Then I use the above ODBC to create the connection the the MySQL db 3. Then from within Access I link...
  15. Freshman

    Update Flag on Max Date

    Hi all, I've seen the answer to my question on a few places but just can't seem to implement it on mine. Maybe I'm missing something when changing their fields to mine, so I'll give my table and field names if someone can help please Table: Career Fields: CareerID AutoNum and PK ID...
  16. Freshman

    Access 365 32/64 bit clash

    Hi all, I have numinous Clients running my Access (mdb format) for many years. However I'm now battling with a Client running Office 365 64 bit. The Access 2007 Run-time I normally ship with my app works fine but as soon as the Client re-boot I have to either re-install 2007 RT or run a "repair"...
  17. Freshman

    msg command from CMD line

    Hi all, I want to run the following command from VBA: If I type "msg * test" into the cmd window, I get a nice Windows message box. I tried to Shell it like this: Shell "cmd.exe msg * test" but it does not work. It only brings up the cmd windows but does not execute the msg command. Any...
  18. Freshman

    WhatsApp

    Hi all, I came across this info regarding sending WhatsApp messages via the web (PC). https://faq.whatsapp.com/en/android/26000030/?lang=lt I can use FollowHyperLink to action a new message but I still have to click on the <Send> button in WhatsApp. It is not a problem for Single messages...
  19. Freshman

    Pervasive PSQL

    Hi all, I need some advice. I need the table data from a Pervasive PSQL database to be exposed to the Internet in some or other way in order to use the data in a Website's frontend.. I can create a ODBC DSN connection from within Access to link to the tables and then have code on a timer event...
  20. Freshman

    MSComm32

    Hi All, The code below is giving me a "ActiveX component can't create object 429" error. The MSComm32.ocx file did register sucessfully via Cmd Any help would be appreciated. Running Access 2007 but also tried it on a Access 2013 machine I had to browse to the ocx file as Microsoft Comm...
Top Bottom