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!

  • Congratulations strongm 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. DanEaton

    Want a record number text box beside each record

    Thanks for all your input, I'm still looking for answers. I agree with PassingBy, having a number displayed in search results is not at all confusing in this context. It's simply display aesthetics for me. However, I'm at my last day of work, and the project is complete, so thanks for all of...
  2. DanEaton

    Want a record number text box beside each record

    Where can I find this property? Is it the case that it is only used in reports? If so, this may be a problem as I need one in a continuous form. Dan Eaton deaton@caemachinery.com
  3. DanEaton

    Best Way to set up a searchable form

    I had the similar situation. The best way to do a search form is to first create a query with every that you want to search for and everything that you want to display. There are different ways that you can search. Probably the best way from a user perspective is to set-up combo boxes from which...
  4. DanEaton

    Want a record number text box beside each record

    No, nothing has worked, some people have been a great help by giving me code that was basically a compromise that just never really worked correctly. I have giving up as of now. But if you find something, drop me aline, I would be most grateful. I figured that it must have something to do with...
  5. DanEaton

    Want a record number text box beside each record

    Almost worked, but the problem is that I have duplicate records taht come up (they aren't unique)...Thanks anyway Dan Eaton deaton@caemachinery.com
  6. DanEaton

    Want a record number text box beside each record

    On my search form, my search results are in the detail of a continuous form. I want a text box to show the currentRecord beside each record. I tried to make a text box called txtCounter that would show this results. I put this in as the control source: =[Me].[CurrentRecord] This did not work...
  7. DanEaton

    Want a record number text box beside each record

    On my search form, my search results are in the detail of a continuous form. I want a text box to show the currentRecord beside each record. I tried to make a text box called txtCounter that would show this results. I put this in as the control source: =[Me].[CurrentRecord] This did not work...
  8. DanEaton

    Want a running count of record number on continuous form

    Wasn't exactly what I meant, BUT, I used the counting text box (which is similar to what I wanted), works great, thanks. By the way, what I meant was that on the continuous form I wanted a text box in each matching record that was the same as the little record selector indicator at the bottom...
  9. DanEaton

    Want a running count of record number on continuous form

    I have a search form that matches control's values with an underlying query. The unbound search comboBoxes are in the form header, and there are continuous results in the 'detail' section. Some people at work have complained that they get confused about what record they are at when they scroll...
  10. DanEaton

    Want a running count of record number on continuous form

    I have a search form that matches control's values with an underlying query. The unbound search comboBoxes are in the form header, and there are continuous results in the 'detail' section. Some people at work have complained that they get confused about what record they are at when they scroll...
  11. DanEaton

    Hyperlinks not always working...strange

    I'm sorry, I still don't understand. By label, are you meaning to say textbox? I can understand what you mean if you're saying: In the table, the data type is text NOT hyperlink. You then have code that somehow changes it from text to hyperlink (on the form only). This makes it work everytime...
  12. DanEaton

    Hyperlinks not always working...strange

    Sorry, I don't think I understand how this is accomplished. If I'm not mistaken, labels simply display a caption. They don't display dynamic data do they? My text box is based on a table with different internet addresses based on different suppliers. If I have totally misunderstood the process...
  13. DanEaton

    Hyperlinks not always working...strange

    I have a search form that displays the results of a cross-reference catalog search. The results are displayed on a continuous form such that many results are seen at once. I have among other things, a text box that shows a company's web-site in hyperlink form. This works about 50% of the time...
  14. DanEaton

    Tab order problems

    Cool, thanks! However, upon changing these properties I realized that I have another related problem. I have a subform on the main form. So in my tab order I would like it to go thru the subform, then to the 'submit catalog' button on the main form. However, once in the subform, it doesn't want...
  15. DanEaton

    Tab order problems

    In my main data entry form (frmCatalogDataEntry) I have several controls that are mainly for viewing purposes (auto-fill) that don't really need to have focus on them within the tab order. I also have three command buttons that I would rather not get the focus unless clicked. Like my 'delete...
  16. DanEaton

    Tab order problems

    In my main data entry form (frmCatalogDataEntry) I have several controls that are mainly for viewing purposes (auto-fill) that don't really need to have focus on them within the tab order. I also have three command buttons that I would rather not get the focus unless clicked. Like my 'delete...
  17. DanEaton

    Clearing the query on open of a search form

    Figured it out, Thanks for your help. Dan Eaton deaton@caemachinery.com
  18. DanEaton

    Clearing the query on open of a search form

    Thanks for the responses. JimInKS, are you suggesting that I have the combo's set to defaults value's in the OnOpen event of the form? This might work if I set the combo's to obscure values that wouldn't be in the query I guess...As for EnidTheDog's list boxes, I like the idea, but my boss does...
  19. DanEaton

    Clearing the query on open of a search form

    I have a "Cross-Reference Search Form" which has several combo boxes to choose from. I finally got this thing to work but there is one minor problem that is a major annoyance. I based a form on a query, and put in SQL criteria for the query which pretty much said ie. ....WHERE...
  20. DanEaton

    changining to autonumber after 1300 entries

    Thanks for the help, Got it! This will save me some serious time. Dan Eaton deaton@caemachinery.com

Part and Inventory Search

Back
Top