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

    Mousewheel scrolling to next record

    They are opening a form to a filtered record from the parent form. I guess I could run a query as the recordsourse to only include the 1 record, but it is easier to just use the openfrom command with the filter option. Some of the the values on the new form opened refer to the parent form. If...
  2. jimati

    Mousewheel scrolling to next record

    That mousetrap from papwaler.com works great for windows xp, but again, the ocx won't register in vista x64. Let's forget about the mousewheel for a second. Maybe there is a way just to prevent the user from going to the next record, even if they click the next arrow. Is there a way to capture...
  3. jimati

    Print report using info on form

    What is in your table that lets you know the dog is transferred? Is it a yes/no field or a date field? Once you move a dog from untransfered to transfered, something would have to be updated, right? Make your report use that criteria. Does that make sense? If you make your question a little...
  4. jimati

    Mousewheel scrolling to next record

    yeah, that uses the mousewheel.dll, which won't register with vista (x64)
  5. jimati

    Mousewheel scrolling to next record

    Where are all you smart people at?
  6. jimati

    Number of records in a query

    http://support.microsoft.com/kb/94397
  7. jimati

    Printing form not printing what is displayed on screen.

    You might want to put me.refresh after you update your last textbox (use the "afterupdate" option) and before you print. See if that works.
  8. jimati

    Form is blank until PartNumber is selected

    Put all that same code in the forms onCurrent event. Then when the form opens, or changes records, they will still be there. you may need to do an error check on the onCurrent, because if you go to a new record and your comboBox doesn't have anything in it, it might give you an error. Something...
  9. jimati

    Data entered into form does not immediatly update underlying table

    use me.refresh. You can use it in the field's "afterupdate" event or anywhere that works for you.
  10. jimati

    Run-time Error 3061 - Too Few Parameters. Expected 2

    Assuming your empid and and courseID are numeric, it should look like this instead. strSQL = "SELECT lnkCourseEmployee.EmpCourseID, lnkCourseEmployee.CourseID, lnkCourseEmployee.EmpID, " & _ "lnkCourseEmployee.DateComplete,lnkCourseEmployee.HoursTrained,lnkCourseEmployeeCompleted, " & _...
  11. jimati

    Mousewheel scrolling to next record

    OK, So I've seen the demos all over the internet about the mousewheel.dll, and getting that setup in the load event and close event of the form. That works great for windows xp, but I have vista x64 and the dll won't register. So, I still need to stop the mousewheel from moving to the next...
  12. jimati

    Run-time Error 3061 - Too Few Parameters. Expected 1

    Did you figure the query out? It looks like there are a few errors in what you posted. but if you figured it out already, it doesn't matter.
  13. jimati

    Clone Record With Primary Key Indexed as No Duplicates

    This might help, I needed to do the same thing you are doing and I simply created an append query that had the ID field of the query = to ID field of the form. I selected every field in the table except the autonumber field. When I ran the query, it added the exact record to the table and...
  14. jimati

    Text in a listview

    That showed me how to center the column headers, but I didn't see where to center the actual text in the columns. Any ideas?
  15. jimati

    Text in a listview

    Sorry, I posted this yesterday, but wrongly asked regarding a listbox. I actually need to know if you can center the text in a listview column? Thanks.
  16. jimati

    Center text in a list box

    Is there a way to center the text horizontally in each filed in a listbox?
  17. jimati

    Horizontal Lines in a listbox

    Currently, vertical lines seperate my fields in a listbox. Is there a way to have horizontal lines as well or do I need to change the control?
  18. jimati

    command buttons

    make sure your in your properties for the button that enable = true. Then in the onClick event for your button you do this docmd.setwarning false 'I do this so that it won't remind me I am about to append records docmd.openquery "YourQueryName" button1.enable = false 'this will disable your...
  19. jimati

    Formating Textboxes on forms

    That worked like a charm, thank you. One more question. Is there a way to center the text vertically in the textboxes? In one control, I have notes, which expands all the boxes. In another control, I have a date field. And becuase the notes field makes all the other fields increase in size...
  20. jimati

    Formating Textboxes on forms

    I'm not sure I can explain this, but I'll try. I'm trying to make the detail section look sort of like a spreadsheet. Meaning that there are rows and columns. Some of the "cells" or fields are set to "can grow" because some of the text is long and needs to wrap. The problem is that when just...

Part and Inventory Search

Back
Top