Recent content by BeffyMar

I always open a form that I want maximixed with a docmd.Maximize then I use the docmd.Restore in the on close event. This will keep the other forms from being maximized. It has worked for me every time. BeffyMar Hope this helps

I want to create a query that sums all the fields by week so that I can chart the values.&nbsp;&nbsp;I cant seem to accomplish this task and my time-series graph never gives me what I want.&nbsp;&nbsp;Any suggestions??<br><br>THanks in advance<br>Mary Beth

I have several charts that are based on a query. The criteria for the date field is<br><br>Between Now() and Now()-[Enter Number of Days]<br><br>This works well... but I want to get the number of days that they entered and put that on the heading of the chart<br><br>ex. All Equipment in the Past...

I have a main report that is produced according to an embedded query.&nbsp;&nbsp;The person must enter in a Fiscal year and the dates are pulled from a fiscal year table and used to compare date fields in another query in the main report.<br><br>The subform uses the same first query that gets...

I figured it out... I just did iif statement within the query then calculated that field... I didnt realize that you couldnt sum a calc field... or something like that..<br><br>Thanks you for the advice.<br><br>Mary Beth

Thanks I like this one more... I will use it..<br>

#error is showing up in the field.&nbsp;&nbsp;What I typed is:<br><br>=DCount(&quot;[Laps Time]&quot;,&quot;YearlyQry&quot;,&quot;[Laps Time]&lt;0&quot;)<br><br>I also substituted the first Laps Time for Person Responsible because that is what the footer was that it was in<br><br>The Name of the...

I cant seem to get this to work...I will keep plugging away.<br><br>Any other suggestions would be greatly appreciated

Samara... got it... It worked... I have to just call it onOpen and onClose.<br><br><br>When I did it onCurrent, wherever I was within the records became #1.&nbsp;&nbsp;<br><br>Thank you so much.<br><br>Mary Beth

I have created a field that counts the records in a report but what I really want to do is count records with this twist.&nbsp;&nbsp;I want a count of all records that contain a negative in lapstime field and I want a count of all records that contain a positive in lapstime field.&nbsp;&nbsp;How...

Samara,<br>For some reason this isnt working for me.&nbsp;&nbsp;I dont know if it is because I am calling the function at the wrong place.&nbsp;&nbsp;It did manage to totally mess all of my numbers up hehehe.&nbsp;&nbsp;I am sure that I am doing something wrong.&nbsp;&nbsp;By the way, I called...

Thank you samara... I will try this first thing tomorrow when I get to work... after viewing your code, I think that this may be the answer to what I am looking for...I will let you know...<br><br>Thanks again,<br>Mary Beth

I realize that this seems like an unordinary situation.&nbsp;&nbsp;They want the number to change.&nbsp;&nbsp;If record 6 is deleted then they want record # 7 to become ID# 6.&nbsp;&nbsp;I know that this really doesnt make any practical sense, but this is what the company...

Sorry... maybe I need to be more specific.&nbsp;&nbsp;At the bottom of each form there is a data control that allows you to scan through the records.&nbsp;&nbsp;It contains a bar with a number in it according to what record you are viewing ( ex.1, 2, 3).&nbsp;&nbsp;I need to capture this number...