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

  • Users: applevacross
  • Content: Threads
  • Order by date
  1. applevacross

    Needed: Combo Box to reuse removed data later

    I have a combo box which contains all power supply serial numbers. When a power supply gets re-issued to a laptop, I want the serial that gets replaced in this combo to be able to be reused later as opposed to just getting written over. Is this possible without having to creat another table for...
  2. applevacross

    In a bind on combo box or text box search? Which one?

    WinXP Pro, Access 2000 I need to create an advanced search,This search will be it's own form with a subform. Ideally I'd like to create a text box search where I can put in any criteria relating to the database table. Meaning, If I want only hp laserjet printers, I can enter that and the...
  3. applevacross

    Text box search multiple fields with subform?

    Hi all, I am currently using a frame with two radio buttons controlling two combos to switch between search requests. I can enter by name or switch to serial and enter likewise. The output is generated in a sub-form of all records by that name or serial. Mostly name, since of course serial is...
  4. applevacross

    Query output to excel not working?

    Windows XP Pro/Office 2000 I was able to output to excel before fine, now all of a sudden I cannot. I keep getting a message when I go Tools>Office Links>Analyze with MS Excel: "Cannot access "xxxvac_Inv_DBQuery.xls" It's wierd. It won't output the data, but it still creates the spreadsheet...
  5. applevacross

    Combo Box "Value List" Default Values Automation

    Good morning all, I'm updating some data in my DB and have been requested to make a combo box with default values to choose from. I've already got two fields in my table; NT USername, and Full Name. I don't want to touch the default data, instead, I want the value from the combo box on the...
  6. applevacross

    Notes and Outlook Future full compatibility?

    This is basically a user environment question. Does anybody know if Lotus has any plans for the future to integrate their email client with outlook and the office suite? There are so many issues which certainly is par for the course; all things considered. However, Notes seems to be a very...
  7. applevacross

    Value List / I don't know if it'll work. Checking with the experts

    I have two combo boxes I would like to create. The information in one is UserName, the other is NT USerName I did a system audit and created an RTF file which has 4000 of each. I'd like to add these to my value lists without having to manually add the quotes and semi colon. Is there a way to...
  8. applevacross

    Notes won't update until I click the synch button

    I know with outlook there was a problem regarding Service pack 2 where emails wouldn't come in until you clicked on another email or sent an email. The solution for that was to do the office service packs. Here I seem to have the same problem with a user where they do not see any new emails...
  9. applevacross

    Who updated this record? How can I find this info?

    Is there a way to find out who updated a record without having the person actually select their name from a list noting they updated that record? Reason being; my manager has requested I put this in the DB w/out the users knowing, (I guess he wants accountability). Ex. John Doe opens the form...
  10. applevacross

    Printer keeps losing default connection?

    I have 5 users in our Pittsburgh airport terminal who's printer refuses to stay on the manually set default printer for their location. For some reason after restart it goes back to the previously set default printer which is in another airport terminal. These are not roaming profiles either...
  11. applevacross

    Prompt for proper user address twice? Any Solutions?

    I have a user who when entering the user name, ex. john doe, a list opens prompting to select the proper john doe address, (ex. jdoe@msn.com, john_doe@yahoo.com, doe,j@excite.com). She selects the proper address then hits send. However, it opens another list asking her to choose the proper...
  12. applevacross

    Macro to Output current data only to Word (Not a Merge)

    Access 2000 WinXP Pro Good afternoon all, I'm looking for your expert knowledge. I've created a form which is pretty simple. Each time a request for hardware of software comes in through the intranet, I enter that data into the database form. I created a macro "submit" button which will...
  13. applevacross

    combo box to open subform showing requested records.

    Good morning all, I have a search frame which is set to toggle between two combo boxes 1 to search for user, 1 to search for serial. I'd like the user combo on click to open my subform and show all records held by that particular person, ie. computer, laptop, monitor etc. I'm guessing I can...
  14. applevacross

    Filling empty fields with same value

    Does anyone know if there is an easy way to fill over 1000 empty cells in the same column on my main table with the same value? Besides of course going one at a time and pasting? this would be greatly appreciated. As always thank you for your help!
  15. applevacross

    Combo Box in form/searchable by 2 values

    I've created a combo box with the combo box wizard. It is currently set to lookup the record by the value set which is serial #. However, I've been asked to have this searchable two ways. Management wants to be able to search by either username or serial. How can I set this up to be able to do...

Part and Inventory Search

Back
Top