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: *

  • Users: jrf
  • Order by date
  1. jrf

    How do I display a timed message, o

    How do I display a timed message, one that appears on the screen only while a routine is running. Such as "Please wait while calculating billings." while the bill writing program is running.
  2. jrf

    VBA to access text boxes from subforms

    Thanks, Tyrone, it looks like the answer for me. I won't get to this until next week. BTW, I checked out your web site, is there anything you don't do? (Hypothetical question)
  3. jrf

    VBA to access text boxes from subforms

    The faq was interesting but a coder would somehow have to develope code to test the number of rows returned in the subform (that I referenced above) and then define each column to pick out specific instances of data. I guess I'll do some research on that. John
  4. jrf

    VBA to access text boxes from subforms

    That coding is fine if the subform has only one line of data, but what if there are several, such as am item form having a sales record subform with many records in it and a specific field from say the first or second record is needed in the main form or a new record or whatever? That's been my...
  5. jrf

    Win98 SE Re-install - Problem with Internet Connection

    I am having exactly this problem with a laptop and cannot begin to know why. However, nothing is asking for addresses. The modem connects and logs on to the isp or the company server, then nothing, not another bit goes out over the modem, nothing is ever found, no error messages. I'm almost...
  6. jrf

    Loading combo box

    Thanks for the help Joe but using the .itemdata(0) didn't do a thing whereever I put it. I've tried versions of that along with trying several other approaches including using .listindex(x), etc to no avail. Using .listindex(0) will actually put the correct item into the combo box window but...
  7. jrf

    Loading combo box

    Jes, your reply doesn't seem flippant at all, I've spent a lot of time trying to set the default. However, I cannot come up with a way to reference the 1st (listrow(0)) and make any or all the columns from the query appear. Remember, there is no default until the previous combo box, picking...
  8. jrf

    Loading combo box

    I am using a combo box to select work the authorization for a preselected client. When the client is selected the afterupdate drops down the list and sets the focus, but the combo box itself remains blank until an item from the dropdown list is selected. As the first item is the correct item...
  9. jrf

    preloading combo box window

    Believe it or not, I had the requery already in there so I remain with the results above. I'll check back in the am but I'll be thinking about this all night. The microsoft help for combo boxes specifically states there is no data in the combo box window until the arrow is clicked and a row...
  10. jrf

    preloading combo box window

    Terry, Both combo boxes are on the same form. Entering your code in the afterupdate of the first combo box drops the cursor to the second box window and opens the dropdown list. However, it doesn't put anything into the window, and interestingly enough, the second combo box accepts only the...
  11. jrf

    preloading combo box window

    Sorry, Terry, but I couldn't make this work for what I want. What I'm after is -- as I exit the first combo box, the first row item pops into the window of the second combo box, already visibile when the cursor gets there. I have no trouble getting the correct info into the second combo rows...
  12. jrf

    preloading combo box window

    I am creating a form that uses a combo box result to provide a criteria for the query on a second combo box. I works just fine but the second combo box window remains blank with all the retreved rows exposed when the arrow is clicked. I would like the first retreived item (98% what is used) to...
  13. jrf

    Find second set of records in a form

    I give up. Something that seems so simple is complete eluding me. I am creating a form for entering timeslips. We have claimant records and each claimant can have one to several authorizations. I have created a form that looks up the claimant records perfectly. I can find each and every...
  14. jrf

    SQL install problem

    Sorry, Kari, but that's not it. Now matter what drive\directory I propose to the setup program the setup fails because it cannot copy files into "c:\mssql7\data" which is apparently hard wired into the install program. The install up to that point works properly with the files placed...
  15. jrf

    SQL install problem

    I cannot get my ms sql 7 to install to any drive but c: for both program and data. Any attempt to load the program to my E: drive that has lots of room and the data to G: with is a mirrored raid drive fails due to "unable to open c:\mssql7\data\log" which seems to be hard wired in the...

Part and Inventory Search

Back
Top