Recent content by DKO

Something more like the second example. Thanks for the help.

The "one line per dependent" is what I'm trying to avoid. I'm looking for a way to list more than one dependent per line - only displaying the rest of the employee data once, not duplicated on multiple lines. To the user, it should basically appear as a text box that lists all the dependents...

Is it possible to imbed a subreport into the detail section of a continuous report and enforce a one to many relationship? I defined the relationship between the query that the main (continuous) report is based on and the query that the subreport is based on as one to many - then I embedded...

Thanks for the quick input, guys.

Just a quick question for the pros. Given: Back end and front end are both Access 2007 databases. Back end is on a shared server and the front end is distributed to all users. (with auto updater if that matters) Generally speaking, is it better practice to keep all tables, static and...

The Right function only selects "x" number of characters from the right side of a string. So in that example - you're telling it to select the last 6 characters from the string: " " & [field1]...which is only 6 characters long to begin with. You could achieve the same thing with just: " " &...

Another possible solution is to set the table's primary key to the student's name + the date. Then it won't let you add the same student's record more than once with the same date.

Your code is fine. Post your query. It sounds like some kind of data type mismatch. Remember text values must be enclosed in parentheses, dates in "#" signs, and numbers don't need either. Also pay close attention to where you have your "OR"s and "AND"s...

What code are you using to transfer the values to excel? It sounds like a problem of where the focus is. If your form/subform has the focus, it works - if it doesn't have the focus, it doesn't work....correct? So maybe just return the focus to your subform before transferring the values to...

If IsNull (Me.LockRecord) Then Me.LockRecord = "Yes" Else Me.LockRecord = Null Try that. The way you have it is actually storing a "space" in the field and not setting the value to null. I'm not sure if that would create any problems for you or not...depending on what all you use...

Going by your code - the user will never use Combo22 unless they've already selected a filter from Combo20...correct? If that's the case, you could just change the "Filter" in the Combo22 event procedure to something like this: Filter = "Discipline = '" & Me.Combo22 & "'" & "AND Area = '" &...

Are your form filters built into the query that the subform is bound to, or do you filter it via vba...or a combination of both? If you do it the first way, you could probably just use the query the subform is bound to.

Why do you need to copy them?

For this, you'd have to do something like in MStef's example database. ie, you'd enter something like this as an event procedure on the "after update" event of the 1st combo box. Private Sub ComboBox1_AfterUpdate() Dim strSOURCE1 As String Dim strSOURCE2 As String strSOURCE1 = "SELECT...

You entered that for the row source of the 2nd combobox? What do you have as the row source for BanksComboBox? Whichever column you have set as the bound column will be the value that is actually stored in the combo box - not necessarily what you see displayed on the form. So if the bound...