Search results

Wow, you are a very smart man. Thanks so much!!

But I need something to reference tblDept.

Hi, I have a DepartmentNumber field on my InputForm (for tblMain) that is a combobox with department numbers. This combo box looks up tblDept. I also have "On Not in List" code for this DepartmentNumber field so that if a user enters a department number that doesn't exist, a sub form opens...

YTDMissing: Fix(DateDiff("m",[FirstMissingDate],Date())/12) & " years " & DateDiff("m",[FirstMissingDate],Date()) Mod 12 & " months" I'm having issues with this. If Today's Date is 8/14/12 and FirstMissingDate is 6/30/12, 2 months is being returned and I can't have this round up... Is there a...

Yeah you're 100 percent right, can't believe I overlooked this. I had an input mask set up for letters and digits, i just changed the last character/number to a "0" which doesn't allow letters Thanks for your help

Hi, I have this code: Private Sub AssetNumber_BeforeUpdate(Cancel As Integer) Dim Answer As Variant strIdNumber = Me.AssetNumber Answer = DLookup("[AssetNumber]", "tblMain", "[AssetNumber] = '" & Me.AssetNumber & "'") If Not IsNull(Answer) Then MsgBox "Duplicate Asset Number Found." &...

Perfect. Thanks Paul

Hello, How would I put these two BeforeUpdates together? Private Sub LastMissingDate_BeforeUpdate(Cancel As Integer) If LastMissingDate.Value > Date Then MsgBox ("Last Missing Date cannot be greater than Today's Date!") Cancel = True End If End Sub Private Sub...

Beetle, you are a very smart man! thank you so much :)

@ Beetle, Your response finally clicked and I did what you said and that works...it answers my No. 2 question. I'm assuming my next step is to add/edit some code in my search command button to truncate the last 6 digits of my typed UNSPSC number..any ideas?

@ Beetle, don't quite understand what you mean but I'm not sure if we are on the same page either so let me try to explain this another way. I have a form that has an unbound Text47 that will be used to enter in a UNSPSC number to search by. Behind the search button is this code: Dim...

Hi, I have a field in every record called UNSPSC which is a 10 digit code. I want to be able to search by UNSPSC with only the first two digits of my searched number to retreive matching UNSPSCs. (I have a method to my madness for doing it this way) I.E. I search the UNSPSC 0123456789...I...

It seems like my formula is slightly off or I need an extra piece. I need it to take the difference of total years...not just subtract Today's Year - the First Missing Year. For example, today is 7/18/12...and the first missing date was 11/1/2009. This formula is returning 3 but since November...

@Bob Fitz - that worked...thank you! @Boblarson...the else was like that on my thread but within my code it was on the next line. Thank you both though.

HI, I set up a password on a delete record button to ensure the end user knows they are about to delete a record. I used the password "delete". So when I hit the delete button at this moment, a password prompts the user and if they type "delete", a message box displays saying something along...

Thank you guys...I'm going with Beetle/Addy advice because that makes sense.

Hi, On an access 2010 form, I have created a formula to calculate the "Year" difference between two dates and I want to add this difference to one of my form fields that feeds my table. I am probably approaching this wrong but this is what I have done. Added a hidden text field "Text12"...

Thank you both! Worked great...have a great day :)

Hello, I have this code executed when I hit my Save button. It works fine but I just added an additional field SFSID that isn't required each time. If I leave it blank, I still get the error message and can't save my record. I'm not sure how I would exclude one field with my given code...

So would my control be Fed ID or UNSPSC? I use the Fed ID to get a list of records that may or maybe have the same UNSPSC numbers. From there within a specific line (record), I want to click the button to only pick out other records with that same UNSPSC under the FED ID.