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

    The expression you entered refers to an object that is closed etc.

    I have a form which calls another form which then closes the original form when it loads. Except it doesn't. I am using the code Private Sub Form_Load() DoCmd.Close acForm, "NameOfFirstForm" End Sub but I get the error "the expression you entered refers to an object that is closed or doesn't...
  2. paulwood

    Could be a newbie question on Forms

    Oops, my error. I left an * in where I shouldn't have. It works! Thanks so much you guys.
  3. paulwood

    Could be a newbie question on Forms

    That limits it to matching just the first two places, but I am afraid doesn't solve it. It means that if I search for Liverpool (L) I can get Plymouth (PL) in the results. When it is a single character postcode searched on it has to ignore any postcode with two alphabetic characters at the start.
  4. paulwood

    Could be a newbie question on Forms

    Almost perfect, but the Like needs to be limited to the first character of the postcode in the field being searched if the code chosen for searching on is single alphabetic character, and limited to the first two characters if the code searched for is two alphabetic characters. Example; If...
  5. paulwood

    Could be a newbie question on Forms

    Kinda getting there I think, thanks so far! Problem now is the one-digit codes. If a one-digit code is chosen, it doesn't differentiate between that and a two digit so as my previous example, choosing the S code could match an SO entry. The postcode is not just the first one or two letters, it...
  6. paulwood

    Could be a newbie question on Forms

    I am far from an expert, so if this is a dumb question, please be kind! I thought the OpenArgs could only be used when opening a form, and I want the focus to return to a form that is already open behind the search form. One other thing, the postcodes are unique but there is a problem that some...
  7. paulwood

    Could be a newbie question on Forms

    Oh, I see. In your example I am right in assuming that PersonKey is the field to be checked in the table and lstnames is the result of choosing a specific postcode from the dropdown. This would certainly be more elegant than the rather long-winded way I have done it. I will see whether I can...
  8. paulwood

    Could be a newbie question on Forms

    It may be that I should mention a few other things about the forms. The main form (MyForm1) with all the data showing has a button on it which opens MyForm2 for searching purposes. MyForm2 only has the dropdown list of postcodes on it. The searching is done via VBA using a Do While construct...
  9. paulwood

    Could be a newbie question on Forms

    I normally do battle with ASP on the Internet, but none the less I cannot believe I am having problems with this. I have a table with names and adresses and stuff which is displayed in a regular form, we'll call it MyForm1. I need to search it for a postcode which is chosen from a dropdown box...
  10. paulwood

    Disk fragmentation on Exchange db

    OK, I understand the issues to do with defragging and I think I would be inclined to take the exchange files off then defrag and put them back. I guess what my question then is, isn't fragmentation of 48% a bad thing, or is it likely that it's being mis-reported and there is no issue. If it is...
  11. paulwood

    Disk fragmentation on Exchange db

    I really don't know if this is a problem or if it is, what the answer is. I have an Exchange server which shows 48% total fragmentation, report as follows. Fragments File Size Most fragmented files 1,004 2,538 MB \exchangedb\priv1.edb 412 174 MB...
  12. paulwood

    DoCmd.SetWarnings False in Access 2002/3

    OK, just tried that, afraid it didn't make any difference. On another tack, is there any way of turning the Action Query option on and off programatically?
  13. paulwood

    DoCmd.SetWarnings False in Access 2002/3

    I am considering that, but it's a program-wide option rather than mdb-wide isn't it? I'm not keen to turn off all Action Queries for all database as they are heavy Access users and they may need it turned on in some db's.
  14. paulwood

    DoCmd.SetWarnings False in Access 2002/3

    I have had a script running perfectly in Access 2000, but now the client wants to start running 2003. When it gets to DoCmd.SetWarnings False mySQL = "DELETE * FROM table_name" DoCmd.RunSQL mySQL stDocName = "query_name" DoCmd.OpenQuery stDocName DoCmd.SetWarnings True...
  15. paulwood

    Everything working except incoming mail

    If I try and telnet from outside the lan I get through but get 550 5.7.1 Unable to relay for <name of email account> when I try and rcpt to: a valid email address. This means the firewall is OK and SMTP is passing through, so it must be that the settings for the domain haven't taken on the...
  16. paulwood

    Everything working except incoming mail

    Internal mail works, sending external mail works, but all incoming external mail produces an Action: failed Status: 5.0.0 error So I telnetted in and RCPT'd to an account and it validated, but sent a Status: 5.0.0 error back to the external account. I have gone through everything I can think...
  17. paulwood

    'Known' bug stops owa with sbs4.5

    Hi Manoj Thanks for the reply, they are indeed running Outlook 2003, so I'll check it out when I'm next in their office. Many thanks.
  18. paulwood

    Access 2000 as frontend

    Thanks, I guessed that was the most likely scenario, worth a try though. Would save having to login to make sure the db for my footy message board was still intact, and seemed like a cool thing to try. Anyone know a program to view a downloaded sql backup file rather than having to access the...
  19. paulwood

    Access 2000 as frontend

    Thanks for rapid reply. :) So if this was the backend on a website, most likely all external access at this level is blocked even though the database can be accessed via phpMyAdmin on the site? I know my ip is not blocked specifically, but is there any way of finding out other than contacting...
  20. paulwood

    Access 2000 as frontend

    I know this is an 'old chestnut', but I have been trying to add an ODBC connector for MySQL frpm mysql.com. It downloaded and installed correctly, but when I came to configure it, the dialogue looked different from the picture on mysql.com help page. I figured it had just changed and made a best...

Part and Inventory Search

Back
Top