Search results

I have a report which will not maximize despite the code. When I trace through the code it correctly runs over the "Docmd.maximize" statement and then it works correctly. But when I open up the database and do not step through the code, but click exactly the same command button it will not...

Does anyone know how to turn off the functionality to hold down the shift key, while opening the database and getting the database window? I have a few users who have learned to hold down the shift key, and I am afraid they could end up accidently breaking something. Thank you for your time...

Thank you, I got the report to sort and group as I expected.

I have a simple report with one group (it has a group header). Under that group there are 10 different fields (for the entire report as well), and the users have requested that they be able to sort the data by choosing from an Option Group which field (they have 4 of the 10 to choose from). So...

The State Header is now being repeated. It looks like this currently on the report: Iowa Users James K. Dold 8845 E. 55th Des Moines, Iowa Brett Wilderman 8907 5th Ave. Ames, Iowa Brian Zook 9350 Walker Av. Marshalltown, Iowa Missouri Users...

Darn did not work, let me try again here.... My first post for this question There this should work, ignore the above message.

Here is a link to the original post. Sorry about posting this twice. Thank you, T.J. http://www.access-programmers.co.uk/forums/showthread.php?s=&threadid=60007

That solution was a great idea, but when I tried that I get something like this..... Iowa Users Brad Stevens 1804 E 1st Street Des Moines Iowa (Too much blank page) ----------------------------New-Page------------------------------ Missouri Users Kyle Gundy 1103 W. 3rd Kansas...

I have a report with just one header and detail section below, which makes for a simple report. I have set the Repeat Section property = Yes on the header, so that the header repeats at the top of each page. My only problem is in some cases the Header will print at the bottom of the previous...

I have two questions regarding MS Access Reports. The first is regarding the "Can Grow" feature. I have a report built to have side by side column information. The column on the right contains a "Notes" field so I set this field's Can Grow property = yes. It grows correctly, but when it...

I have a subform that opens up a pop-up form on the click of a command button. The same subform is on three different parent forms, and opens the same pop-up regardless of the parent form. On the close event of the pop-up form I want to correctly update the subform. Of course to do this I...

Requery continous subform Thank you so much for replying. I would like to try the subform recordsetclone, but I am not sure of the exact code. I will play with the code, but if you get a chance could you give an example of the correct code? The purpose of the requery is to update the current...

I have a continous subform, that once a drop down box is choose from, the subfrom needs to be requeried CODE: Me.Requery This works just fine, except the requery automatically sets the focus back to the 1st record. So if the users enters like 20 records into the subform, and they are scrolled...

I have a form in which the users click records in a list box (these records are high lighted) and then click a command button on the form and the record is correctly added to another list box. Everything works great but I have run into a small problem. I could not find a way through code to...

I already have the correct results, and the search is working correctly, just cannot get the subform to refresh correctly. The users love the design if it would only work correctly. Basically if you choose from a drop down on a form, and want a subform to appear and show info based on that...

I have a request to build a search from in MS Access (it will contain a few drop down boxes for the users to choose from and then a button to click to run the search and show the results). The results will contain two sub tables of information, so that there can be many results in the sub...

I am not sure if this is the correct forum or not, but I am having some permission issues problems. I created an Access .ADP project and everything works great. The last step is setting up the correct permissions for the users. The permissions are simple, full rights on all the database...

I have a database in which the users have requested a "review screen". This form will not all edits/additions/deletions, it is built just to review data entered into the database. Since this form does not contain any functionality, the users would like to see the name of the person set up like...

Works like a charm. Thanks alot. T.J.

I have finished up my first ADP project and I am excited. I am going to use the Package and Deploy Wizard so I can place the front-end on the various users machines. Everything is going very smooth but I have come across a tough request. When the installation wizard is run, the default...