Search results

Thanks for the reply... as much time as i spend at that site, you would think i've seen that before! thanks again, norm

check to see if the actual sub form is an appropriate size as well as the container on your form... good luck,

I'm doing something similar and am pretty sure you need to carry the subtotal over via the main report and only from the subreport's footer section... i think. i'm following http://support.microsoft.com/default.aspx?scid=kb;en-us;Q208835 but haven't gotten it to work yet. If something works...

Has anyone an idea how to fairly easily have a line or colored control grow vertically to match a section? I can see there being a way in the print event of the section to get the size of the section?? Have never done it though. But then again if it's already in the print section, i can't...

Sounds like fun. Have been there before... am close to there now. Not much we can do in this economy. Maybe a week of good faith will show enough progress to satisfy them. Contracts sound stiff but hope you have one. maybe even 1 or 2 weeks trial followed by 1/2 up front and half on...

Not sure specifically... but check out the vba class DateTime in the object browser. It looks like there is something that might help you out like maybe the month method in combination with something else. Also maybe the DatePart function which returns something like the first day of the year...

SubReport property procedures Can user defined property procedures be used in a subreport (be set from the main report)? I'm trying to pass a value to a subreport so it can then be used as a variable in the report module. Thanks for any help :)

ms kb article http://support.microsoft.com/default.aspx?scid=kb;en-us;Q208835

Well i don't totally follow what you mean but, i suppose it's possible. i tried re-opening the db though and it still happened.... I hope it's something stupid that a good nights sleep will solve. any other ideas??

well if the problem is that it is always rounding up, try doing the rounding in the text box. for example: =Round([Field Name],0) or specifics: =Round(8.45,0) would equal 8 =Round(8.55,0) would equal 9

time to re-install, man... to the 95 platinum edition... kidding. time to upgrade though, or at the very least, re-install access 97.

i'm opening a 3 section report from a form... and setting the section's visible property onopen. in the following example: 1 [off] 2 [on] 3 [off] section 1 header & footer is not visible. why would it still group by section 1?? any ideas?????? thx, norm

dude, ROCK ON! Can't believe i didn't find datediff!! ...and for some reason my function WORKS NOW?????? It wouldn't work yesterday for the life of me. This is what I ended up doing yesterday...

Look into an application property called UserControl (ac2000, not sure about 97). It returns true if the application was launched by a user, false otherwise. I need to deal with that issue sometime soon too. Let me know if it works out. good luck, norm

I'm trying to display the number of months contained within a report grouping. I have a typical date field to work with where dates can range over years. Is there an easy function for this that has eluded me?? Or/Also, is there a way to use user defined functions in text boxes?? I have a...

I don't know of any easy way to do what you're asking but this may help: press [Ctrl]['] and Access will duplicate the data from the appropriate field in the prior record.

Try adding something like the following: 'Or Is Null' or 'Or IsNull' or (<your expression> Or Is Null) to the expression. Hope it helps, norm

I can't guess exactly right now, but i can get you started. Look into end/beginning of file properties (EOF and BOF). By using them, you can figure out when you're at the end of a recordset. ie. If rst.EOF then 'you're at the end. end if Then look into methods to navigate through...

I'm not sure i understand the question right but here goes.... It sounds like you want a user to choose a filter when the form opens. If so, you can do it any number of ways but here is one: In the first forms Open event, open another form (in dialog mode) for user input on which filter to...

If you don't have many images (& it's not dynamic), try putting them all on the switchboard and change visible properties. Otherwise, try the docmd.setwarnings method before & after import. on = -1,True off = 0,False