Search results

  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?
  16. T

    multiple criteria

    so if shift was a numeric field would this look correct? stLinkCriteria = "[date] = #" & Me![Combo13] & " AND [shift] = & Me![Combo16] & "
  17. T

    multiple criteria

    i have two combo boxes on a form for the criteria to open the next form. I keep getting "data type mismatch in criteria expression" stDocName = "FRMSHIFTSTART" stLinkCriteria = "[date] = '" & Me![Combo13] & "' AND [shift] = '" & Me![Combo16] & "'" DoCmd.OpenForm stDocName, , , stLinkCriteria any...
  18. T

    continuous form wont link

    as in what i had in my first post?
  19. T

    Jump to a specific record in a continuous form

    as in what i posted first of all?
  20. T

    continuous form wont link

    when i click on a record in continuous form its taking the id from the first record to link to the form i open. so i tried this code Private Sub Image15_Click() myrecnum = Me.CurrentRecord ID.Requery DoCmd.GoToRecord , , , myrecnum ID.SetFocus stDocName = "frmITEM" stLinkCriteria =...
Top Bottom