Search results for query: *

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

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

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.

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

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

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

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

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

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

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

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

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?

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.

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

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

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

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.

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

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

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