Recent content by RickBerem

I was wondering... I get paid only once a week! Maybe this guy gets paid only once a week also... then 0 cuts would be needed! :) SG

Me.txtFTE.Text = Me.txtHours.Value / Me.txtWorkWeek.Value Just replace the "txtFTE.Text" to "txtFTE.Value" you should be able to access Value without the focus! Hope it helps SG

DrLex sig: Be there, be square. SG

Hey Clint! Make sure your default value is between "" "2006-07" That should do :) SG

Hello, You should make sure that when you enter your form it opens up in a NEW record. Using something like : DoCmd.GoToRecord acActiveDataObject, Me.Name, acNewRec should do the trick. SG

Thanks for the help! Yes, I ended up doing more pixel per tick to speed it up. By Marquee I meant the equivalent of the <marquee> tag in HTML. I thought it was the correct name for "scrolling left to right text" Thanks again for all your inputs. SG

Hey, Ok info coming up The timer is set to interval : 1 the graphics are drawn in the Paint event using the Invalidate function of the control I paint on. Fired by the timer. Hope this clears some fog. SG

right, little detail. it's displayed on a 1680 X 1050 screen So the Marquee is pretty big. SG

Hello everyone! Ok, I made this program that is, mainly, a Clock that displays messages stored in a db. (it can also show a slideshow of images but this part works) My problem is: The scrolling speed is slow... The computer that will be used to run this is a 733 with 256mb ram and Windows 2000...

Hmmm, Well, if it's a report for you alone, you could use IIS on your own machine directly. if not, I guess that building the HTML Page via VBA is a good solution. Hope I make sense SG

Hello, ASP code could do that for you. And it would be dynamic. Hope it helps you out :D SG

Hello, Couldn't you call your stored procedure for EACH element selected? If there's 4 elements selected you could run a loop and 'call' your storedproc 4 times. Hope it is of some help. SG

Hello, You probably tried this, but you could try putting the second field criteria in the OR part of the query builder. Should work if I understand you correctly. SG

Hello, When you try to make a multi line statement in VBA, make sure that each line ends with [Space]_ where [Space] is a real space. so your code should look like "INSERT INTO TblScore ( AssessmentID, ParmsID, SiteID )" & _ " SELECT Assessment.AssessmentID... after each line in the VBA...

Hello, Not sure if it will do, but you could try setting subform 1 Cycle property to 'Current Page' instead of 'All records' Hope it helps you a little. SG