Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. RickBerem

    Cutting A Gold Bar

    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
  2. RickBerem

    Calculating value from two text box fields

    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
  3. RickBerem

    Amusing names

    DrLex sig: Be there, be square. SG
  4. RickBerem

    Default Value Truncates Zero

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

    Append Problem

    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
  6. RickBerem

    Scrolling Marquee too slow!

    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
  7. RickBerem

    Scrolling Marquee too slow!

    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
  8. RickBerem

    Scrolling Marquee too slow!

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

    Scrolling Marquee too slow!

    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...
  10. RickBerem

    Creating HTML page from report

    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
  11. RickBerem

    Creating HTML page from report

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

    How can I pass multiple values for a single parameter?

    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
  13. RickBerem

    Searching by multiple parameters?

    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
  14. RickBerem

    SQL in code

    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...
  15. RickBerem

    can't tab between 2 subforms

    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
  16. RickBerem

    If then else, not sure what the else should be

    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
  17. RickBerem

    Main Switchboard resize problems

    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
  18. RickBerem

    How to reduce space between report lines in code

    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
  19. RickBerem

    How to reduce space between report lines in code

    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...
  20. RickBerem

    Verify Null value in text box

    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

Part and Inventory Search

Back
Top