Search results

well... your not really supposed to it was one of those, "God I'm an idiot" moments...

You know I already have those fields, you'd think i would have thought of that. Yes it's based off of a query, and yes it would be super easy for me to modify it a bit. Thanks for the help. it is still bugging me, is that type of display mask possible? aside from having it in separate boxes?

I have a form that pulls a name from a table. In Table it is in this format: "John Smith" in the report it shows "John Smith" I want to make it just display "John S" on the report for privacy issues. I've looked into input masks and display format but I cannot come up with anything. In...

Thanks for the help! I finally got it to work, Turns out I needed to set it to a variable then put it in the loop to get it to work, I couldn't set it inside the if statement like this: TableContents = "# " & PickNumber & " Prediction" FormContents = "Number " & PickNumber ... If...

The code it self works when presented like this If ViewPicks("# 1 Prediction") = Forms![WeekendResults]("Number 1") Then I just want to know if it is possible to fit this in a loop where the number within "ViewPicks(# 1 Prediction")" can be changed with a placeholder variable so on the next...

I have two recordsets that I am trying to compare two lists of 5 things. So is this possible? If ViewPicks("# " + placeholder + " Prediction") = Forms![WeekendResults]("Number " & placeholder) Then Note: I have this working when I don't try to use the placeholder variable. Did I do it wrong?

This is what I have right now, I would like to return the top 3 predictions based on an algorithm I wrote that will return "accuracy" of each user's predictions, I would like to do it automatically whenever you load a different record of Weekend Results, ( the page that displays what the top...

Hi I am new to this forum and kind of new to access. I am a previous excel VBA semi-guru so im not translating well to access. Here is my problem, I am trying to write a program that does an automatic query when a new record is pulled. I hope I don't sound foolish as I write this but here goes...