Search results

Can you zip and attach the file, maybe I can take a look for you. Graham

Any chance of zipping and attaching the file, and I'll try and take a look at it. Graham

jk Using the On_Current event of the form Private Sub Form_Current() EnableIfNoNull 'Navigate to the current record's Web site 'If there's no URL stored in the field ([strWebsite]), then display 'default website ("http://www.nitlc.com") If Len([strWebsite]) > 0 Then...

Has a scroll bar appeared to the right of the screen that will allow you to scroll and review the database window? Graham

Are you using Access 97, 2000 or 2002? What problems are you having? Graham

Try Here The Word Expert There is a section relating to Outlook in their Forums HTH Graham

Tim Set the properties of the form being opened to Data Entry >> Yes This will open the form up at a new record. HTH Graham

This May Help You.... Awes Take a look at the following site that contains info regarding tab colours: Tab Control Colours HTH Graham

John I don't know weather there is a maximum number of criteria but you can add rows to the criteria section of the query design. If you click in the criteria grid then go to Insert >> Rows , this will allow additional rows to be added. HTH Graham

Hayley Copy this into your browser address bar, see if this helps http://www.candace-tripp.com/_pages/HTML/default_HTML.asp graham

Phredd On Candace Tripps website there is an example database containing many coloured command buttons Coloured Command Button Example Go to the MS Access Downloads Link HTH Graham

James This should be the one you're after: ACC2002: What's New and What Are the Enhancements in Access 2002 Graham

Greg Try searching the forums, loads of topics on this one. This one should help: Screen Resolutions HTH

Phil I'm sorry, but I don't think there is anyway that you will be able to do that using this feature. Basically you are wanting the functionality of the VLookup, but don't have the space to store all of the data. Sorry but you may need to look at alternative options. Graham

Phil The filter will return only a Part Number (Or whatever you wish to filter by) from the list of Parts in the database. Are you saying that you want to include a cell reference in this list or are you wanting to return the actual results to Cell A2 in the worksheet? Graham

Phil Please see attached document for details. I have had to remove a lot of the pictures as the size exceeded the limit. Hopefully this should show you enough for you to go along with. If not I'll have to e-mail you the full document. It may actually be as quick to do this whole process in...

Phil Unfortunatly, the test database does not contain any records or tables.... Can you repost Graham

Philip Would you like to attach a copy of the database (zipped) to this thread. I will then take a look at it for you. Graham

Dave You can remove the Access icon from the forms title bar by selecting not to show the forms Control Box HTH Graham

Philip You can apply a criteria to the import once you get to the filter section of the wizard. For example in your Part Number field you can return a value equal to ABC123. HTH