Recent content by carnealse

Im about ready to start drinking to drown the frustration on my lack of knowledge. Clearly, I just don't get it. I have no idea how to do a function other than make a module, and say; public function phase as integer() Drawing a blank because other than the code I put before to get the phase...

So indent for easier viewing, check. Create a function check. Understand the function you just placed in front of me, IsNull, :D see what I did there? lol Anyway, now Im feeling like the guy banging his head. Lets break how I read that function code down...

Yeah I don't abide by all the etiquette of access because it makes sense to me how it is laid out and that is all I am concerned with. I know others have their ways and mine doesn't work for them, that's cool. I am not a dive shop, I just know how it works because my buddy works in one his Dad...

Hey no worries man. I get it. Its an eye screw. I'd use that Select Case yadda yadda if I had more skills and understood this stuff better. I am new at all this compared to you saltier VBA and Access types. I don't indent because, well, I don't need to to see it because I am writing it...

Mr Dan... No such thing as too much info. Not in my line of work anyway haha. Besides, why give you a piece of the puzzle and say figure it out. You have a bigger picture here to work with. If I remove the End If, then the code is worthless. That End If has to be there. Run it yourself...

For context, I am referring to Navy students on a Naval Intel base just out of boot camp who need to earn their expanded liberty. The higher the phase they are in, the more liberty they get. Now... I coded a way to determine what liberty phase my students are in VBA. I created a query to...

There are 39 fields but the ones specifically to this question are; ID autonumber OLD BOTTOM TIME number BOTTOM TIME THIS DIVE number NEW TOTAL BOTTOM TIME number I attached the rough work in progress so you can see what I am working with first hand.

Very nice. A round trip ticket from here would cost me $1,250 about. Not including hotel, charter, and gear. Yet I am still falling short of making this sum work for me. I think I am over thinking it. There has to be a way to start from zero and automate the sum of the last dive's bottom time...

Sharm...as in Sharm el Sheikh, red sea type diving?! I dove yesterday in the Gulf Of Mexico off of Pensacola Florida but that is nothing like diving over there. I'd give a lot to dive a place like that! So yeah, I will end up trying out what you suggested later today. If I run into troubles I...

I get what you are saying, I do. The nice thing is that bottom time is pulled from the dive computer at the time of dive long entry. Using rental gear, its not much of a reality that a diver will go back, track down the dive computer they had two weeks or two months ago and search for a...

Simply put, I am trying to pull the data from the previous record / row only in a continuous form for a dive log to keep tabs on total bottom times. All I am doing is pulling the "new total bottom time" from the previous record in to the "old total bottom time" of the current record in order to...

Well I figured it out. I did play around with the Dirty as well. I just wasn't sure exactly what I was doing with it. I just saw your reply and I think that could do it as well. This is what I used to force a save after using the search text box eliminating the error; Private Sub...

Maybe there is a disconnect between what I am saying and what you think I mean. The records changing has everything to do with it because only when a record changes will the search function return the 2115 when a new search is attempted or the clear filter is attempted, unless the save button is...

Well, using a combo box in this instance would not be ideal. The records are changed constantly and there are 83 records and counting. These are student records for Navy personnel for training and are always coming in so to scroll down a list to pick a student is not my first choice. Where...

I have an unbound text box with a search button running a macro "applyfilter," and in the "Where Condition =" I have the following; [lastname] & [firstname] & [rate] & [rank] & [notes] & [workarea] & [badge] Like "*" & [Forms]![N91 RECORDS]![Text128] & "*" Now, in the form, if I open it up I...