Recent content by jjake

  1. J

    Solved Problem with MS Surface and Model Box

    I cannot post the database. I ended up just creating my own message box using a form and changing modal to no so at least if it disappears behind the main form the visitor can still press the check in button again and it will pop up after the keyboard has already dropped.
  2. J

    Solved Problem with MS Surface and Model Box

    Hi, I am using a MS Surface tablet for a visitor kiosk using MS Access 2016. I have several fields that are required and thus will pop up a msgbox indicating the fields are required if left blank. The problem arises when filling out a text box and the enter key is pressed using the on screen...
  3. J

    Using .findfirst and signaling no result

    Perfect thanks.
  4. J

    Using .findfirst and signaling no result

    I'm using the following code to look a user up by a pin code which works fine. But how do i alert the user if a match is not found. I tried to create a blank record as the first record in the table and match by a blank textbox but couldn't get it to work Private Sub cmdSearch_Click()...
  5. J

    Retain new line in field enter key behavior in email body

    at the top of the email it says Message (HTML)
  6. J

    Retain new line in field enter key behavior in email body

    Using outlook yes. There is no message about line breaks. All other formatting is correct.
  7. J

    Retain new line in field enter key behavior in email body

    I'm using the following code to send an email from a form. Private Sub Command68_Click() Dim objOutlook As New Outlook.Application Dim objMail As MailItem Dim Header As String Dim Text As String Dim EmailAddr As String Set objOutlook = New Outlook.Application Set objMail =...
  8. J

    problem opening different forms with hidden combo box

    Well i made a whoopsie. i found a typo in my combo box name :o Sorry.
  9. J

    problem opening different forms with hidden combo box

    Could it be because the combo box doesn't have a value yet?
  10. J

    problem opening different forms with hidden combo box

    Hello, I have a navigation form for entering equipment ID's. On this form is a combo box based on a table "EquipmentType" e.g 1 | Pumps 2 | Vehicles 3 | Storage Tanks Hidden on the form are 3 individual "subtype" combos During data entry if EquipmentType = 1 then "Pumpsubtype" combo box is...
  11. J

    How to retain field paragraphs when transferring to an email body

    That did the trick. Thanks.
  12. J

    How to retain field paragraphs when transferring to an email body

    Hello, I'm using the following code to generate an email. Option Compare Database Private Sub SendEmail_Click() Dim olApp As New Outlook.Application Dim mItem As Outlook.MailItem ' An Outlook Mail item Set olApp = CreateObject("Outlook.Application") Set mItem = olApp.CreateItem(olMailItem)...
  13. J

    Form button to scan documents to file folder

    One more thing. How would i save this file path to the record it was saved from so i may view it later from a form?
  14. J

    Form button to scan documents to file folder

    I figured it out based on this post - https://docs.microsoft.com/en-us/office/vba/language/reference/user-interface-help/invalid-use-of-me-keyword & Forms!frm1!frm2.Form.UserName & "Insurance Papers" & Format(Date, "mm.dd.yyyy") & ".bmp"
  15. J

    Form button to scan documents to file folder

    i got the following, invalid use of me keyword
Top Bottom