Recent content by TriniGal

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('" &...

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(#" &...

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...

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

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...

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...

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.

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 _...

Thanks for your help I figured it out. Thanks.

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.

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,

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 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - > > >...

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

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.

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...