Replies

Thanks for your response; but I tried that and that means every Group Header on the top of the page has a line and extra space; I don’t mind writing non-trivial VBA code.

Got a error;
Update or CancelUpdate without AddNew or Edit. (Error 3020)
On a Microsoft Jet database, you called the Update or CancelUpdate method but did not use the AddNew or Edit method before writing data to a record.
On an ODBCDirect database, this error occurs when you attempt to write data to a record without first calling AddNew or Edit.

The following code is on the ‘On Click’ Event

If [ReportingUnit] > “009” And [ReportingUnit] “060” And [ReportingUnit] “080” And [ReportingUnit] “083” And [ReportingUnit] “090” And [ReportingUnit] “500” And [ReportingUnit] “629” And [ReportingUnit] < "712" Then
[Org] = "NORT"
[Office] = "NORTHERN"
Else
[Org] = "UNDF"
[Office] = "OTHERS"
End If

If you look at the Main Form I have included a Text Box that displays the current value of the SubForm’s sbfProducts Order By value. When you open the attached database you will see that the SubForm’s sbfProducts Order By value = strProductName DESC. When you click on the Report Preview Button the report Order By value is blank; look at the footer of the report or open the report in design view and you will notice that the Order By value does not = strProductName DESC. What I’m I missing here; why doesn’t the report use the value from the form?

Thanks; for the code and for the information between number fields and test fields. I have a new problem; I placed some labels on the subform called sbfProducts; I made the labels sort the Product ID and Product Name in ascending or descending order based on clicking on the labels. If I click on the Product Name label and sort the data by ascending order the form sorts the data; however when I click on the Preview Report command button the report displays the data that is displayed in the form; but not in the order that is displayed in the form. I have attached the database.

Thanks all of this works great; I placed a command button on the subform to print the a report of subform values; however the report printed all the records from the table and not the records that where filter on the subform by using LinkChildFields and LinkMasterFields value.

Dear Hans;
In a previous Post you provided code to use when using combo boxes to filter the records in a subform. This works great; however the selection criteria is not passed on to the subform. So when I print the a report based on the subform; the report contains all the records within the table. While the subform displays only the records based on the combo box selected. How do you pass on the combo box value to the FilterOn on the subform. Great Code for being able to allow multiple sorting values; how about code to allow multiple items for filtering?

Thanks again it did the job; after re-reading your post and looking at the form as it opened. The form was always maximized; it was the Access Application Window that was not maximized. Once again thanks for your assistance.

I want both the application window and the form to be opened and be maximized

Tried that already; before I responded. I guess I should have stated that. Sorry.

Thanks Very Much; Your “Automation” code worked; however opens the form in the minimized format. I liked the form to be opened in the max format. Any Ideas?

I have responsibility for a Database that uses information (links to another database) from another Database. However; I don’t have responsibilty for that information; I don’t manage that unit. I link to the database and have a form that displays the information. Let’s say the user reviews the information and determines that they want to modify the linked information. I want to be able to have the current form use a command button to open the database and the form; so the user can modify the information. The users folder rights will be checked to make sure that the user has write/update rights; to update the information in the recently open database.

I must apologies; I need to be a bit more detailed; on a previous post, you explained how to create labels that I move to the back of the each field on my form; the color of the labels is white. I chose a background color of purple and fore color of black for all of the text boxes and combo boxes; then I change the properties on text boxes and combo boxes Back Style to Transparent. When the I use the mouse to move to the field; the fore color is black and the background color is purple. Looks great and the users know where the cursor is at; but after a second or two, the field color inversion occurs. Then fields has a black background and a purple fore color combination does not look good; regardless; Is there a way to override the color inversion?

Thanks very much for the information; however we are using a CITRIX Client to push out many databases to all our customers. So whenever I make changes to the ‘Behavior Entering Field’ section of the Keyboard tab of Tools | Options… it will affect all the other databases. I don’t control all the Databases; So is there a way to do this for a specific database when it opens or to specific Form when it opens?

So the best thing is to have the combo box “after update” property move the focus to the next field? So the individuals entry will need to depress the tab key or enter key; before the cursor moves to the next field. Thanks for your response; it is very much appreciated.