Search results

So blank, as you call it is what I normally call an empty string "". It is a string of no characters, but it is a string. A number field/variable that contains 0 contains something. It contains the value "0". A field/variable that is NULL contains nothing. An empty void. An undefined...

Interesting. Try something like this in the 2nd query: WHERE NZ(tblName.Notes,"") <> "historical data"

You didn't make the changes request by MSAccessRookie. Should be: "[Fish Type]= Like '*" & Me.FishType & "*' AND [Fish]= Like '*" & Me.Fish & "*'"

Hi Clivios, No worries! I am just a fan of the sport and I was curious. I played in high school and knew a official in the college ranks that wanted to become an official in the NFL. Luck to you in your project and hobby!

Just curious, at what level do you officiate football? (High School, College, etc)

I would put the function CheckForNotesCheckboxes as a function in the General Declarations for the form in question.

Just looking at your query and field names, it appears that there could be a better database design. It appears that your Match table includes one field for each official position. I would remove those fields from that table and create a OfficialPostion table and a...

Instead of getting rid of the data, can you include another field in the TEMP data that identifies the Data Source? Then you could use the order in your "ranking" to determine which of the data sources to use for like records.

Per pbaldy's post in #2, a small function can be built and inserted in each of the checkbox's on change event. Private Function CheckForNotesCheckboxes() as Boolean CheckForNotesCheckBoxes = Me.checkbox1 Or Me.CheckBox2 or Me.CheckBox3 or Me.CheckBox4 or Me.CheckBox5 End Function Then...

If I understand what you want, try this: sPath = "C:\Directory\mainfolder\" & Format(Date, "yyyy mm dd") & " " & "folder"

The method I use is: Public Sub ResizeForm(ByRef frm As Form) Const Twips As Long = 1440 Const lngFormFrameTop As Long = (3 * 0.125) * Twips Const lngFormFrameBtm As Long = (5 * 0.125 / 3) * Twips Dim Head As Long 'Form Header plus estimated height of top form frame Dim Foot As...

Re: Who's bored? BluIshDan: In the original post, a couple of criteria examples were: So what do you get for 51?

Re: Who's bored? The more I think about this, the more I think part of the problem is that is not a straight base-10 to hexavigesimal conversion. In any base system we use, we include 0, binary has 0,1. Octal has 0,1,2,3,4,5,6,7 and etc. In this case we were given the task of converting as...

Re: Who's bored? BlueIshDan, I think your problem is recording the values of the Mod function as the value to be converted to the alpha sequence. I don't think this explains it well enough, but think of long division. We record the number of times divisor goes into the number, going left to...

Re: Who's bored? LOL - Thanks so much! :D

Re: Who's bored? Someone could always volunteer to do a semi-scientific experiment. Wrap a timer around a numerical sequence loop of several thousand(?) numbers and call the function for number. Then compare times???

Re: Who's bored? vbaInet, Yes, the character sequence for 256 is IV in Excel, but it was implied in the original post that A = 0. :p For 5 to become F, A has to be 0. Ditto for 51 = AZ. Hence, if you carry this out, the character sequence for 256 is actually IW.

Re: Who's bored? Ok, my version: Public Function GetSequence(ByVal lngNumber As Long) As String Dim lngTemp As Long Dim strChar As String Const BASE As Long = 26 lngTemp = lngNumber \ BASE strChar = Chr(lngNumber - (lngTemp * BASE) + 65) If lngTemp = 0 Then GetSequence...

Cool. For future reference - I was doing a small project with a recordset and got the same file sharing lock error. I think the error is a result of having a large number of recordset records open at a time. Increasing the MaxLocksPerFile obviously works, but changing up the size of the...

My first guess is something in the SQL statement. Typo in the field name? Calling out a field name that doesn't exist?