Recent content by Senjen

Top notch, works perfectly. Thank you both very much. I have been out of coding for some time and your posts were both very helpful and educational. Thanks again.

Using the given code this was my result (data pulled from aqryAllSales since there is no field named ThisMonth in the table): StartDate QBSales ThisMonth 12MoRollAvg 1/1/1994 $9,005.00 23928 $63,060.60 2/1/1994 $8,521.00 23929 $63,060.60 3/1/1994 $9,743.00 23930 $63,060.60 4/1/1994...

what I want to do is compare the average monthly sales over the last 12 months with this months sales. The original table has the following fields: ID, StartDate, QBSales among others. The query where I am comparing data sorta looks like this: StartDate QBSales ThisMonth 1/1/1994 9,005.00...

I was afraid I wouldnt make myself clear, allow me to try again. You are correct as far as the data I have, what I would like the report to do is give me totals by month of all the values combined: Month Value 1 24063 $330,000.00 2 24064 $275,000.00 3 24065 $315,000.00 I want to...

oh boy, I hope I'm not repeating someone elses post. I have searched without luck. I am trying to pull a valuation of our stock on the first of each month and report this with the following 2 columns: Month/Year, stock (inventory) value (I want a total, not the value of inventory on each item)...

Originally I could use the chart wizard but now when I try I get the above error. I dont know what has changed but I even tried removing and reinstalling Office 2003 and still it continues. Any help would be appreciated.

I tried the Round([your number],-3) and got an error before I posted. Looked good to me too. Could be the formatting of my data. Never really looked at it too hard.

Skip your the best, just couldn't see it. Works perfectly.

In a query I would like to round up to nearest thousand if over 500, to nearest hundred if over 50 and leave any smaller values alone. Any thoughts?

I am an experienced Access developer new to .net. I have VS.net 2002 and I need to develop an ap that will allow a user with a plain jane computer to enter multiple name, email, zip in text boxes on a form which he can then upload or email. I have thought perhaps writing this to a csv file would...

when i use the suggested code i get an invalid outside Procedure error. i am running XP. any suggestions?

I am having the same problem, where did you get the replacement? If you could emial it to me that would be great.

I would like to add blank lines to the bottom of a repot for employees to make field notes. It is probably an easy fix but I am just not getting it. My problem is that if the sub reports are long the notes section continues onto a new page. I want to limit the report to one page and just fill in...

'set the load event to call procedure Private Sub Form_Load() Form_Timer End Sub set the procedure to update your field. Private Sub Form_Timer() Me.TimerInterval = 1000 [Your Field Name] = Now() End Sub i found this under another thread.

my original goal was to export 2 queries to an excel workbook with two worksheets when a user enters an incorrect password 3 times. that has been a problem so i would like to be able to export to 2 seperate workbooks then, from access, import the first workbook into the 2nd workbook as a...