Recent content by tubar

  1. T

    HTML EMAIL

    msg = msg & "<a href=" & Chr(34) & "http://yahoo.com" & Chr(34) & ">Overhead Sponsor Example</a>" That Worked! Thank you!!
  2. T

    HTML EMAIL

    Im having trouble getting a web link in the body of my email. Any guidance? Private Sub email_DblClick(Cancel As Integer) STARTBODY = "<html><head><style type='text/css'> body { font: 11pt Calibri, Verdana, Geneva, Arial, Helvetica, sans-serif; } </style></head><body> " ENDBODY =...
  3. T

    XML Infuse Apple Tv

    my skills are few, but i created a database of my home movie collection. I use Infuse on Apple TV. With "infuses" xml format i can display meta data. But their format (i don't think) fits a schema. could some one point me down a VBA path that would essentially allow me to to export a query of a...
  4. T

    filter by year

    Im trying to filter my forms date field by year with a button. Me.Filter = "year([date])='2019'" Me.FilterOn when i apply the code to filter by month it works fine. Me.Filter = "month([date])= '10'" Me.FilterOn = True I even tried creating an unbound text field that displays the date field...
  5. T

    combo box multiple values update query

    still having issues. let me explain this way My table is tblmain. There is a multivalued field called colors. The values checked are red blue green. I want a query that loads records that have red checked and add orange to be checked. All colors come from tblcolors and have primary ids. Color...
  6. T

    combo box multiple values update query

    I have a query that filters the data i need. it contains a combo box with multiple values. Is there a way i could do an update query to check one value (the same value) true in every record?
  7. T

    compile error 64 bit

    Thanks ARNELGP!!!! After using your revised code i i get a Compile error sub or function not defined. with apiShowWindow highlighted If Err <> 0 Then loX = apiShowWindow(hWndAccessApp, nCmdShow) Err.clear End If any help would be appreciated. And thanks for your help so far!
  8. T

    compile error 64 bit

    Ive added PtrSafe to the declaration statements, unless im missing somethingOption Compare Database Option Explicit Global Const SW_HIDE = 0 Global Const SW_SHOWNORMAL = 1 Global Const SW_SHOWMINIMIZED = 2 Global Const SW_SHOWMAXIMIZED = 3 #If Win64 Then Private Declare PtrSafe Function...
  9. T

    compile error 64 bit

    Im using a module to hide access in the background from the user. It worked for years till today when i received a compile error. The code in this project must be updated for use on 64-bit. please update declare statement and mark them with PtrSafe attribute. Any know what i need to insert. The...
  10. T

    list items separate and not in string

    I have a table that lists events with a start and end date. Im want to duplicate these records in a report. Example: EVENT 1 3/15/18 – 3/20/18 EVENT 2 3/15/18 - 3/15/18 outputs 3/15 event 1 3/15 event 2 3/16 event 1 3/17 event 1 and so on. arnelgp helped me a great deal by explaining...
  11. T

    list items separate and not in string

    Thank you arnelgp! Makes sense. i need to learn more about strings! Thanks for the help before as well!!
  12. T

    list items separate and not in string

    Thanks GohDiamond! That is exactly what i want. I made your changes but i still have the f1 values on one line separated by a comma. Any other suggestions?
  13. T

    list items separate and not in string

    I have a module that works with a query. Im still learning how to build a module. I have everything working; except, id like my "f1" results not to string. can some one point me in a direction? Public Function fnConcat(dteValue As Variant) As Variant Dim rs As DAO.Recordset Dim strSQL...
  14. T

    create records between dates

    I have a table that lists events with a start and end date. Im having trouble coming up with a way I could duplicate these records in a report. Example: EVENT 1 3/15/18 – 3/20/18 EVENT 2 3/15/18 - 3/15/18 outputs 3/15 event 1 event 2 3/16 event 1 3/17 event 1 and so on i imagine i...
  15. T

    adding minuets and seconds

    Im trying to make a query that will add a start time in minuets and seconds to an end time in minuets and seconds to get the total time length. can someone point me in a direction?
See more
Top Bottom