Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. TriniGal

    DLookUp help needed with Null Value

    Randy, Now I'm getting a Compile error: Expected: end of statement varADDRESS = DLookup("[ADDRESS]", "LEAKS FOUND", "[ADDRESS] = '" & Me.ADDRESS _ & "' And [STREET] = '" & Me.LOCATION _ & "' And [S_COMMUNITY] = '" & Me.S_COMMUNITY _ & "' And Trim('" &...
  2. TriniGal

    DLookUp help needed with Null Value

    Randy, Thank you for your response. I'm getting a syntax error here varADDRESS = DLookup("[ADDRESS]", "LEAKS FOUND", "[ADDRESS] = '" & Me.ADDRESS _ & "' and [STREET] = '" & Me.LOCATION _ & "' and [S_COMMUNITY] = '" & Me.S_COMMUNITY _ & "' and IsNull(#" &...
  3. TriniGal

    DLookUp help needed with Null Value

    Hello, I have the following code and it works great. I was wondering if it's possible to tweek it a little further to add [R_FOUND], which is a date/time field where it is null. Private Sub LOCATION_BeforeUpdate(Cancel As Integer) Dim varADDRESS As Variant If Me.NewRecord Then...
  4. TriniGal

    Hyperlink to PDF Files

    Sorry, Yes, it had the extension eg. 000001-Bronx, NY.pdf
  5. TriniGal

    Hyperlink to PDF Files

    Something just dawned on me, so before I go any further I should ask a couple questions. What should be stored in the table in that field? This is what I have right now. -the table and the form field looks like 000001-Bronx, NY (Text to display from the Insert Hyperlink Menus) -the actual...
  6. TriniGal

    Hyperlink to PDF Files

    PHV, Background information: -database was created in Access 2003, I am running Access 2007 -the users have Read-Only access to the folder where the .pdf files are stored -it is a hyperlink datatype -in the form where it says "Is Hyperlink" I have YES, where it says "Display As Hyperling" I...
  7. TriniGal

    Hyperlink to PDF Files

    PHV, From what I've read, that doesn't work for .pdf files. Am I mistaken? If I am, how would I go about doing that? Thanks.
  8. TriniGal

    Hyperlink to PDF Files

    Can someone please tell me what I'm doing or not doing wrong? I have the following module: Option Compare Database Option Explicit Declare Function ShellExecute& Lib "shell32.dll" Alias "ShellExecuteA" (ByVal _ hwnd As Long, ByVal lpOperation As String, ByVal lpFile As String, ByVal _...
  9. TriniGal

    If Statement with SetFocus

    Thanks for your help I figured it out. Thanks.
  10. TriniGal

    If Statement with SetFocus

    No, nothing else. Basically, if there is a change, I need to know what the channel # is right now, and what it will be after the change.
  11. TriniGal

    If Statement with SetFocus

    HarleyQuinn, Nope, that didn't work. That makes it go to the Current_CHL and that it, does not go to NEW_CHL. Any other ideas? Thanks,
  12. TriniGal

    If Statement with SetFocus

    Hello, I have a form with a combo box and two text boxes. Depending on the selection the user makes I want the cursor to move to one of the text box. Action (combo box) Current_CHL (text box) New_CHL (text box) Add - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - > > >...
  13. TriniGal

    Before Update Even Not Working

    PHV, Very valuable, I'll try to remember that. Thanks again.
  14. TriniGal

    Before Update Even Not Working

    PHV, THANK YOU, THANK YOU, THANK YOU!!! That worked great. Thank you so much for your patience and help. I have one question though, for future reference, why did you change "LEN" to "TRIM" in the code? Thank Again.
  15. TriniGal

    Before Update Even Not Working

    How do I combine them into one code? I had the second code in a control before update event and it wouldn't fire properly. I changed it to the forms before update event and its working fine. I moved the first code to the L_READING before update even and its not working. Is it possible to...
  16. TriniGal

    Before Update Even Not Working

    PHV, This is the code I had Dim ctl As Control For Each ctl In Me.Controls If ctl.Tag = "Required" Then If Len(ctl & vbNullString) = 0 Then Cancel = True MsgBox ctl.Name & " is a Required Entry.", vbCritical, "REQUIRED ENTRY" ctl.SetFocus...
  17. TriniGal

    Before Update Even Not Working

    PHV, Thanks for your help with the code, its still not working. Roy, I'm using the controls before update event because I have another function in the forms before update event. Like I said before, I'm fairly new to VB, and from what I've seen, there is only one function per event, I'm not...
  18. TriniGal

    Before Update Even Not Working

    Do you seed anything wrong with my code thought? Thanks
  19. TriniGal

    Before Update Even Not Working

    Hello, I'm fairly new to VB. I have the following code. It's stopping the user from going forward (adding new files) and thats it. The error is not popping up of the cursor is not going to the field. All I'm getting is a Microsoft Office Access Error "You can't go the the specified record."...
  20. TriniGal

    Non existing information

    PHV, THANK YOU, THANK YOU, THANK YOU. That worked PERFECTLY. Thanks again and have a GREAT WEEKEND. YOU GET A STAR!

Part and Inventory Search

Back
Top