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 John Tel 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. banks13cu

    MSMQ Unattended Install

    I need a little help... I'm trying to install MSMQ (Microsoft Messaging Queuing) service unattended using a batch file. I get the batch file to open up sysoc.inf however my answer file won't put in the answers an automate it. Any idea what I'm doing wrong? c:\msmq.bat contains: Sysocmgr.exe...
  2. banks13cu

    Default Password

    Apparently that has been changed as well. Didn't work, any other ideas?
  3. banks13cu

    Default Password

    I have a switch that we pulled out of service a couple of years ago. We have changed all our admin passwords and had personal turnover and no one knows the password to the switch. Does anyone know how to crack the password for a 3Com 3C17300 SuperStack 3? Any help would be greatly...
  4. banks13cu

    Auto Size Adjusting

    I am wanting Access to auto adjust the size of the report in the Detail secion to fit the record information. For example, in the notes seciont of my report, if it takes up 1 line to show the data, then it will take 1 line on the report. If it takes 3 lines to show the data, it will take 3...
  5. banks13cu

    partial match

    PHV, thank you that is exactly what I was looking for. Aceman, thank you for your help you defently got the wheels turning!
  6. banks13cu

    partial match

    I really appreciate your help TheAceMan1! But it's still only pulling the exact match. If I put in a partial it gives me the error message that I have in the code of not being found. Here it is: Private Sub Text0_AfterUpdate() Dim RecNum As Variant Dim FrmLnkCriteria RecNum =...
  7. banks13cu

    partial match

    Ok. I've updated the code and its still not taking the 'wildcard' * into the equation. Its only doing exact matches. Here is the code... Private Sub Text0_AfterUpdate() Dim RecNum As Variant Dim FrmLnkCriteria RecNum = DLookup("[Model]", "Inventory", "[Model] = '" &...
  8. banks13cu

    partial match

    Sorry but I'm not following what you are saying. Do I need to keep it as an After_Update or do I need to change it to something else. I know enough about access and VB to get myself in trouble. Just explain a little more for me please! Thanks
  9. banks13cu

    partial match

    I have created a form to search for a model number in a table. Say the model number is ABC-123. The current code I have written makes an exact match so ABC-123 would have to be entered for the return of the data record. I want it to be able to pull a partial match, so if you enter ABC it...
  10. banks13cu

    2 Criteria in 1 Query

    I need to be able for a Query to take information from column if it is present but if it isn't then take it from a different column. For example... Table has a Room Number column and a Birthday column. I need the query to sort by Birthday unless the Room Number is present. For query named...
  11. banks13cu

    Presence of Data in a query

    I have a table that has general information in it such as name, address, birthday, etc. I have it queried into seperate rooms, which are divided by their birthday. (For example... if your birthday falls between 01/01/2005 and 03/31/2005 it queries into Room 100. If your birthday is between...
  12. banks13cu

    Presence of Data in a query

    I have a problem and am not sure how to solve it... I am creating a database and two columns are Birthday and Room Number. I have it set now, that everyone is sorted by their Birthday into different queries, however I need to go further with this. I need to be able for it to sort everyone by...
  13. banks13cu

    Button Command to Uncheck all Checkboxes

    I have a form that is linked to a query/table. I need a command that when a button is pressed on the form it will automatically uncheck all the checked checkboxes in a particular query/table column. I need this to save the table too. If you have any ideas or suggestions please let me know.

Part and Inventory Search

Back
Top