Search results

  1. 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 =...
  2. 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...
  3. 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...
  4. 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?
  5. 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...
  6. 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...
  7. 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...
  8. 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?
  9. 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...
  10. T

    continuous form wont link

    I have a continuous form that wont open another form with the onclick expression when there is criteria. stDocName = "frmITEMSEARCH" stLinkCriteria = "[ID]=" & Me![id] DoCmd.OpenForm stDocName, , , stLinkCriteria is there a setting i am missing?
  11. T

    parts of a textbox

    is it possible to write vba that would only take a part of a text box and copy the value to another text box. if text box 1 displayed "J:\TEMPLATES\Strong Reveal.jpg" text box 2 would display "J:\TEMPLATES"
  12. T

    value from text box populates other textbox

    Me.PHOTO = " & Me.text36 & " & Me.FILENAME & "\" & Me.FILENAME & ".jpg" can someone tell me what I have to change in the " & Me.text36 & " part so that the value displays the value in text 36 and not the words me.text36
  13. T

    if and statement

    I have scratched my head on this for awhile...if the time out is 2:30pm it shows "18" if its 1am it shows "0" however 2am, 3am, 4am are all good... If Me.Time_Out.Value >= ("12:00am") And Me.Time_Out.Value <= ("5:00am") Then Me.appy_hours.Value = DateDiff("h", [Time_in], "12:00AM") + 24 Else...
  14. T

    save first record of duplicate

    my query lists duplicate records which I append to a new table. from that table I would like to delete the duplicates but save the first record of each duplicate. example the fields are employee and date worked. I would like to keep joe smith 1/1/14 but delete the other joe smith 1/2/14 and joe...
  15. T

    display "enter date"

    im new...I was wondering if I could display "enter date" in my date text box on my form...when the user selects the text box, "enter date" disappears
    • tubar
    • Thread
    • Replies: 6
    • Forum: Forms
  16. T

    create values from other subform

    im new so ill explain the best I know how. my parent form has two subforms. when the user double clicks a value on one subform it populates the first blank field in the other subform. I created a code for the double click on the subform Forms!frmeventbuild!Form.frmBUILDsub.EMPLOYEE.Value =...
  17. T

    message box with textbox

    I am trying to put a value of a text box in my msgbox...can someone suggest a fix for my vba. MsgBox "SAVED IN DROPBOX. BILLING FOLDER" & Me.EMPLOYEE & ", vbOKOnly"
  18. T

    user selects subform filters other subform

    i have a form with 2 subforms. when the user selects a record in subform one. the date of that record filters subform 2. in the source query of subform 2 i have this under criteria[Forms]![frmeventbuild]![frmBUILD]![EVENT_DATE]. i think reuery would help me but i dont know where to place it...
    • tubar
    • Thread
    • Replies: 3
    • Forum: Forms
  19. T

    update subform requery other subform

    i have a main form with three sub forms on it. when i update subform 1 i want subform 2 and 3 to update...can some one help..currently i have an after update event in a combo box subform 1[Forms]![FRMDATESUM]![frmHOURSUMnowork].Requery [Forms]![FRMDATESUM]![frmHOURSUM].Requery when the user...
  20. T

    format row source as long date

    the source table needs to be formatted as short date...my form is pulling data from a query and I would like to change the row source of my combo box on the form to be formatted in long date. row source is as followed SELECT [qrydateSUM].[day of event] FROM qrydateSUM ORDER BY [day of event]; I...
    • tubar
    • Thread
    • Replies: 6
    • Forum: Forms
Top Bottom