Search results for query: *

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

Hello, Joe pointed you to the good solution. you should be doing If Dir("C:\Group2.xls") <> "" Then DoCmd.TransfertSpreadsheet ... (specific to your Group) End If For each 'group' and then you can define specifics for each. Hope it helps you a little. SG

Hi, It might not be the case but I had this trouble with a db once. Make sure that the DETAIL section of the form is VISIBLE = TRUE. Hope it helps. SG

I was able using rpt.Section(acDetail).Height = 100 to reduce significantly the space between the lines but this is assuming that you left the report on default sizes witch I now doupt. It might help. Let me know if it does. SG

Hello, I tried your code and ran it in a empty DB. What I found is that by default, REPORT DETAIL is at 3cm. So it might be the reason why you have to much space between each line. My suggestion is that A) You modify the report DETAIL height by code to the minimum. or you can also build a...

Hello, as Skip said, NULL is not the same as "" but you can (and probably will want) to verify if your field is not null. many ways to do this I guess I use vartype(me.txtTextBox) <> vbNull for the "" use the sample code you sent with the "" Good luck SG