Search results

Didn't get any replies here, but I ended up adding a preferences table and added a preference for the report height. In the onload event for the report I check the preference and set the me.detail.height parameter = the the preference value. If the preference doesn't exist or is less than the...

I have two users that want different amounts of blank space between each line in the detail section of a report. Is there a way to change the area between the detail and footer programatically instead of creating 2 copies of the form, one for each user? Thanks Lution

Sorry we can't take your exam for you but here are two starting points: http://www.microsoft.com/sharepoint/default.mspx http://office.microsoft.com/en-us/access/default.aspx

You missed a set of ( ) that Bob included in his previous reply FileOut = FixName("EMPerformance-" & Format(Forms!Main!FromDate, "mmddyy") & "-" & Format(Forms!Main!ToDate, "mmddyy") & ".xls") I've made them red for emphasis. When you use the Format function you need to include the parameters...

Thanks RuralGuy. It pays to read all the details, I missed that you had to lock results to values in the list to get the event to fire. Once I changed that it works like a charm.

All the properties in the header are linked together. If I try to move one down it moves all of them down. If I try to move one over, it shrinks the others. I haven't been able to figure out how to unlink all the header properties. I should note that I'm using the report wizard to generate...

Thanks guys, I was trying to figure out how to do this too and this thread helped. I have a citations form. One of the controls is a combo box with a list of municipal ordinances. If the user types in a new ordinance, I pop up a dialog to get default information for that ordinance and then...

I'm running out of page space for a report (already switched to landscape, changed the margins, and shrunk the font as much as I can) but I still need a little more room. One thing I've noticed with a stepped report that has groups is the groupings take up their full width in the report header...

I'm curious about everyone's opinion of creating an Options table to keep track of things like defaults vs. using the system registry. Example: For a montly report, I'd like to remember the previous end-date the user picked and use previous end-date+1 as the starting date the next time the user...

correct, and each user is at a different site with no need to share data between sites.

How do you tell if they've paid? I'm assuming you'd need some record on your end to flag the client as paid.

I split the UI from the data so I could roll out additional reports/forms/ and general UI fixes to the users without having to mess up their data. In this case, I have an actual change I need to do the to data but I don't want to leave the query statement behind when its done.

I have a database that I've inherited that requires some changes to both the UI and back-end databases. Each user has their own UI and BE database so it's not as simple as going to the server and manually changing the tables. Originally the designer appended (J) to the customers last name if...

Configuration: MS Access 2007 with a front-end UI database and back-end data database. I have 15 or so reports with varying queries behind them. The reports are all in Access and not mail-merged. What I'd like to do is whenever I run the reports, I'd like to save the user from running a 2nd...