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 Chriss Miller 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. shelron

    enter key behavior for text box

    you da man, thanks, Ron
  2. shelron

    enter key behavior for text box

    I have created a text box so a user can enter in the number of a project, then click a cmd button that opens a form and displays that project. I would like to place the same code on the txt box so that the user could alternatively just enter the number and hit the enter key and launch the code...
  3. shelron

    object variable error at runtime

    I removed the declaration of the text box and all is well, thanks anyway, ron
  4. shelron

    object variable error at runtime

    I am trying to update a textbox on a report with data from a table that is not part of record source for the report. I am trying to get the sum of the field "admin_amount" from the table "tblAdminAllowance", then pass the result to a text box "txtAdminSum" on the...
  5. shelron

    Take time with your staff.

    Another benefit will be "employee buy-in". Most people want to be part of a team that is achieving a worthy goal. (success) Finding value in ones work is an important and crucial element in the morale and productivity of any unit.
  6. shelron

    MOTIVATING YOUR TECHNICAL STAFF

    Girth, my two cents: Look with in for solutions. Get the book and do the best you can while asking here for assistance. Assess what you section needs are and provide remedies. Managers usually welcome employees who can resolve problems with little assistance. Take what is given and maximize...
  7. shelron

    How to Debug a Scroll Bar in SubForm

    My original purpose in setting this form up this way, was to allow viewing but not changing of previous records, and still allow entry of new records on the same screen. Assuming the above, why don't you try this, Dump the subform, set the following properties on the main form. allow edits =...
  8. shelron

    Want to Open Form for 5 Seconds Then Close

    you can also use the forms on timer event, set the timer for 5 secs, then docmd. close
  9. shelron

    How to Debug a Scroll Bar in SubForm

    cmd button, new record
  10. shelron

    How to Disable a Mouse Scroll wheel in Access

    I'm pretty sure there is a faq with code to solve this, ron
  11. shelron

    Handling fields with no data in Word mail merge

    wow carr, pretty cool stuff,, star ron
  12. shelron

    return last change date in a cell

    WORKSHEET change event will do it. Run it with a now function.
  13. shelron

    create record in many table after the one table is entered

    Yes Melinda, it does make sense, normally, I just have a unique situation here. (as usual due to the longggggg story, it never all gets posted for people to consider) I solved this by doing a runsql command and creating the new record. Thanks to all who helped. It's appreciated. Ron
  14. shelron

    create record in many table after the one table is entered

    Private Sub cmdSpecialConsiderations_Click() On Error GoTo Err_Command19_Click Dim stDocName As String Dim stLinkCriteria As String stDocName = "SPECIAL CONSIDERATIONS" stLinkCriteria = "[SPROJ_NO]=" & "'" & Me![ProjNo] & "'&quot...
  15. shelron

    create record in many table after the one table is entered

    I don't want the user to have to enter the information twice. I have a header (in the form header of the many form) I have the one side displayed so that when the user opens the form, he can visually confirm that he is adding information to a specfic project. Let me try to restate: A user...
  16. shelron

    create record in many table after the one table is entered

    I am trying to create a record in a many table from a form. user creates a new record in the one table via a form, then I want them to be able to open a new form so they can enter the details for that table. problem is that I need to create a record in the many table before I send them to...
  17. shelron

    formula displays rather than result???

    well carr, You were on the right track,, There was some kind of space or novisible character in front of the equals sign,. I deleted it and now it work fine, thanks all, Ron
  18. shelron

    formula displays rather than result???

    Interesting observation, I just noticed that when I try to copy the formula down the column, it copies it exactly, like it is an absolute reference
  19. shelron

    formula displays rather than result???

    =VLOOKUP(B2,'NEWEST DUMP2-26'!A:C,3,FALSE) yup,,,
  20. shelron

    formula displays rather than result???

    I am doing a vlook up, but the formula is displayed not the result??? Everything is formatted as text, save the file as a 97/2000/2002 excel file. I am working in 2002 I have other formulas on the same sheet that work fine. What's up? Thanks, Ron

Part and Inventory Search

Back
Top