Search results

Glad you got it working.

A brute force method is below. Basically just a loop that resets a counter to 1 at every change in TV show name. If you want the episodes of each TV show in a specific order, include the secondary field in the ORDER BY statement (ie AirDate). Sub NumberEpisodes() DIM rs as DAO.Recordset DIM...

I tend to use this when trying to determine if a combo box has a value.If nz(Me.Providers,"") = "" Then Cancel = True MsgBox "Enter a Provider!" End If Works for both a NULL value and empty string. Also, is this in the form's before update event or the combo box's before update? I...

davidb88, The problem appears to be in your arrangement of IF statements. This doesn't work because the Exit Sub is outside all IF statements and will be executed every time. The issue is the "_" at the end of the IF statements. This effectively makes only allows a single line for...

I am making an assumption, but couldn't the timer event be expanded to check for a "dirty" record and either force a save or cancel before closing the database? That would reduce the possibility of having an edited record opened at database close.

Or like Gemma suggested, create another option in the option group. For example "No Data Available". Then in code, make sure this option assigns "nothing" to your data record. What you are defining as nothing depends on how you set up the record.

So you were only missing assigning the result of the MsgBox to your defined variable. I also cleaned up the code slightly. Since the MsgBox will only have the choice of Yes or No, there is no need for the second if statement. ;) Also notice that now the MsgBox is a function, the open and...

Ok, I come up with a simple solution, but I would still be interested if there are better solutions available. :D Public Function DoesBGONE7Exist() As Long '**************************************** '* Returns -1 if file does not exist * '* Returns 0 if file is empty * '* Returns...

Background: In my Access FE, I have created a "linked table" to a file on our AS400 database. I know I can check the MSysObjects table for the linked table name, but sometimes the file actually does not exist on the AS400. The file can be in one of three states. File exists with data. File...

Sorry, but I have been knee-deep in my own projects. Can you explain in simple English what you want to happen when the user double clicks an entry in the main form list box? Example: 1) User double clicks in list box containing account numbers 2) Customer form opens with the current record...

This is probably overkill for your situation, but this is the code I have to filter the data in my form. The form header currently has 2 text boxes and 7 combo boxes. Upon execution of this code, a new SQL statement is built, then it is set as the form's recordsource. If nothing is selected, the...

I know I said "heard", but I in fact first saw it written on a white board in our business system manager's office. A friend of mine and I had walked into the manager's office to ask a question. I saw the message on the board, starting laughing right away. The manager looked at me and said "I...

I was laughing so hard after reading this that I nearly shot Dr. Pepper out my nose! Not a pleasant experience. :( (I know, I know - TMI :p) So do all poor Access souls get equal "prayer time", or do Catholics get special, ah, consideration? :confused:

dvance24: Ah, rest easy. I have never been to Michigan. :(

Now, that is just starting to get spooky! :eek:

Hey dvance24! I grew up in Idaho, right on the ID/UT border, just north of Logan. I saw your 'Location' comment and just had to respond that a couple of us can find Utah on a map. :D

Put a <space> between the last 'l' of until and the period. Do Until .EOF

The version I have heard is: There are 10 kinds of people in this world. Those that understand this message and those that don't.:confused:

Example: tblFaculty FacultlyID FirstName LastName tblResearchInterests InterestID InterestName tblFacultyInterests FacultyID InterestID The tblResearchInterests would hold the 54 keywords. Blue, Red, Green Yellow, etc The tblFacultyInterests would hold the facultlyID...

Welcome. I went to school at USU.