Recent content by M3lvn

After some searching and researching Ive come across some code: Dim strF As String If not isnull(Me.Text0) Then strF = _ "[TableFld0] = '" & Me.Text0 & "' And " If not isnull(Me.Text1) Then strF = strF & _ "[TableFld1] = '" & Me.Text1 & "' And " If not isnull(Me.Text2) Then strF = strF & _...

Here is the the sample database with my table imported in it, which is giving errors. To reproduce the problem use the following keywords: - leeftijd (means age) - dienstplicht (means duty) Only the found records starting with the tablename (tbl_DIENSTPLICHTWET) are good. The rest of the...

Im currently studying the example database. It is not exactly what I had in mind, but I have a good feeling it will do nicely. I really like the doubleclick feature to view the record in detail and the option to search with more than 1 keyword. Thanks alot! Ok, now down to the grinding: I...

Hello, What im trying to build is a search that goes through the whole database and all tables. The output will be on a form by which the found items are shown, but not all at once. Only the first item is displayed and the rest can be seen by using the navigation button (first, back, next...

Alright, good to know. Ps. You must spread some Reputation around before giving it to RuralGuy again.

Thank you very much for the explanation and the answer RG. It would have taken me forever to figure out the correct syntax. Especially where the first part is [formS]! and at the second one is [form]! (without the 's'). Thanks again!

It seems I need help once again. Im trying to figure out the syntax of the criteria for a subform that has a subform. The code below is for the subform directly connected to the mainform. [forms]![frmMain].[frmSub].[form].[cboChapters] I have 3 forms setup as: mainform(A) has a...

That did it! I put 'lstArt.Requery' in the OnChange event of the dropdownbox and voila! It works for 2003 and 2007 as well. wiklendt, you're awesome :)

Ok! I got it working! Thanks wiklendt! I have indeed noticed that there was some kind of refreshing needed for the controls. When I changed from design view to normal view things suddenly worked. I did a 'DoCmd.Requery' on the OnChange event of the dropdownbox and it seams to work fine. I...

Here is a screenshot as example: There are 27 chapters in this example. The importance is that the user uses the chaptername to find what he wants. Every chapter has a bunch of articles. The problem is that at the moment there is no overview: he must click on every tabbutton to see what...

I got feedback from the customer and they say its ok: the listbox is very handy and the info in the separate textfields can be just like that. So I guess I dont need to put it in 1 textbox. What would be very nice now, is that I'd like to replace subform tabs with a dropdownbox (Ill post a...

Thank you very much for the screenshots wiklendt. They make things much clearer. I like that listbox (on the left) design, but more importantly, I think the user/customer will like it also, because it gives an overview. At the moment, the selection is implemented as a dropdownbox which is...

Is the listbox setup like several dropdownboxes, eg. the first i select the country, the second will give the region, third the streetname, etc? Like a step1-2-3-x selection? If thats not the case, please post a pic. The difficulty of this project is that there is a lot of overhead from the...

I can send you screenshots via email. At this moment I dont feel 100% comfortable exposing my project publicly. The seniors actually do dictate the layout for a certain amount; the senior is the customer.

Well, the program is already full of subforms, because I needed forms with tabs and subtabs. And therefor used subforms. I found info about continuous forms: http://www.codeproject.com/KB/grid/ContiuousForms.aspx At the moment I cant yet say that it would be better or not, but I'll think...