Search results

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...

What will be in the 2nd combo box? Do you mean you want the list for the 2nd combo box to be filtered by the 1st combo box? IE - in the first combo box you would select the bank name, then in the 2nd box you would choose from a list of all the branches that belong to that bank? If that's the...

Any reason that you need to use code instead of just manipulating the properties of the controls themselves? Is the user able to choose which name format is displayed or does it change depending on a trigger? If not, then you could just enter "=StrConv(werknemers.achternaam, 3)" as the data...

Sorry - I forgot to mention - I'm using '07, but the database is in '02-'03 format. (My company upgraded to '07 in the middle of my build...fun to learn the new ribbon menu while on an "optimistic" deadline...) Thanks for the tips, guys. I'm going to read them over tomorrow. I had...

Like the title says... I have a copy of my front-end db on a shared server so users can copy it to their own computers. The database is still in the development phase, and I'm still making changes to the front-end on a daily basis, then replacing the file on the server so everyone can continue...

You can also just open the query in SQL view, then copy and paste that here.