Search results

Well I moved some of the code that you mentioned and things got settled. I do not know which code was causing that. But my question remains: Does anybody know of a parameter or a possibility as it is done with the tabs of a form to define the order of appearance of forms, so that in case the...

Hi Tim, The reason for using the SBoxSelectionForm method is that the same code is used with different parameters namely ParName the calling form, ForName the called form and the QryName the query of the recordsource of the called form. This code is called and many times and it is centralized in...

It should normally behave that way, but it does not. That is what I am trying to figure out. Between two forms due to programming reasons the control is passed to modules, but then it comes back to the form again. For example the execution of the code below passes the control to a module and the...

Hello Ladies and Gentlemen, I have a series of forms that become current in a certain order. For example a menu form comes up. This is followed by a search form where the user gives search parameters. Then appears the results list. If the user wants a detail form comes after that, etc. Now when...

Well not exactly, nevertheless with the ideas that you gave I finally got what I wanted. The trick is to have the name of the form that is the parent of the subform as the Source Object. If the Source Object is a table or a query or a form that has the continuous format then this subform no...

I have done exactly as you said. I took a blank form and created a subform. The record source can be chosen as a table. Sooner or later one has to define the subform control. In doing so when I specify SourceQy as Source Object the form becomes a datasheet. If I change the Source Object to...

Here we go: The sample data is in the backend. Put the two files in the same directory, then the linking is done automatically. you do not have to use the display or connect buttons. The word search is done using the letters given in all the text fields. This is a part of a rather sophisticated...

The answer is YES, but it is not visible in the wizard. In the meantime I have solved all the problems of assigning queries to mainform record source, mainform listbox row source and to subform source object. Now everything is working fine except for this single form business. I wonder if it has...

I am trying to build up the subform from scratch. But it does not allow me to use the table name. In the wizard it does not display the name of the table. When I do it without the wizard by typing in manually the table as Source Object it says the object does not exist.

It is a single form. It is not split. I created it based on an existing single form. I shall now try your proposal. I'll report back.

I have a mainform with a listbox and a subform sitting in the mainform. The default view of mainform is single. The listbox displays a list of people. When the user clicks on a row of the listbox the subform shows detailed data about that person. The layout of the subform covers almost half of...

Okay, go to the Subform design view, then go to the properties sheet, check the Format tab, under which you will find the Default view property, see if it says anything other than "Single form". If it does not say single form, then there is your problem. Change it to single form. Now back to...

PR2, The title of the thread and the problem we are trying to solve may not coincide. This is because the issue came up immediately after the matter was sorted out and I thought that instead of starting a new thread I should just mention it to the person helping with the first issue. As to the...

Well to know what I mean by that you have to read my first post carefully. There is one main form consisting of a list box and a subform. The listbox gets a list of people to display and each time you click on row of the listbox the subform displays the details about that row. This subform does...

Yes I did. There is only one form and that is single. THe listbox acts as single form showing all the records, but the subfom takes the format columnar.

Thanks it worked. But now I have another problem. Although the subform is based on a single form and is designed as such it shows up as a tabular form. It has probably to do with the query. How do I fix that so that the subform displays only one person at a time.

I have a master form with a listbox and a subform. The listbox is unbound. The form has a recordsource of peoples data. Each row of the listbox contains a unique TelefID (Autonumber), name, telephone etc of each person. The subform is on the master form and contains detailed data about every...

I wrote it like this and it works. SQLRecordSource = "SELECT DISTINCTROW [MembersTbl].* FROM [MembersTbl]" & _ "INNER JOIN " & QryName & " ON " & _ "[MembersTbl].[MemID] = " & QryName & ".[MemID] " & _ " WHERE " & QryName & ".[MemID] = " & J1 & ";"

Hi to All, I have defined a recordsource based on a predefined query. Now I intend to use the SQL statement which works to produce other recordsources based on other queries. More concretely here is my code as of now: Dim J1 As Long Dim SQLRecordSource As String J1 =...

A practical approach that can solve sorting problems. A few points for clarification: This dynamic sort field is a calculated column of the query which exists only during runtime and is not stored anywhere isn't it. Also this field, do you put it at the start of the query and is it visible...