Search results

The Access help file has an example of this under Msgbox Function (example) Just lift the code from there Regards trevor from www.accesswatch.co.uk

Try this dim MyDir as string MyDir = "C:\Windows\MyAccessApp\." if Len(Dir$(Mydir,vbDirectory)) > 0 then 'Dir exisits else 'does not exist ' You create dir code here end if Make sure that you include the \. as this indicates you are looking for a directory Hope this helps Regards Trevor...

This problem is often related to the DAO library not being registered correctly Check this link out for details http://www.mvps.org/access/bugs/bugs0007.htm Hope this helps Trevor from www.accesswatch.co.uk

When you set the Data Entry Property to yes you are telling Access to 'Put me in a position so that I can start to create a new Record' At this point the Record does not exist. Because the record does not exist it cannot have a bookmark because bookmarks can only be allocated to records that...

Your code is trying to allocate a book mark against a record that does not exist. Logically it can not do that so it fails. You can alter your code to ignore the error if it fails. This is a fairly crude method but may be appropriate in some cases. Or you could check for the new record and...

I have had major grief with Access runtimes in the past however a company named SageKey have addressed most of the (very real) problems. Heres some figures to think about the Access 97 runtime, without any options, loads 56 files and creates 1,097 registry entries Anyone who has tried to...

Hi Chris Any chance of a look at your code for the HTML. Sounds useful regards Trevor from www.accesswatch.co.uk Email Trevor@accesswatch.co.uk

Microsoft want you to use ADO not DAO in 2000. Check your references to ensure the DAO 3.6 Library (DAO360.DLL) is installed and registered. Microsoft want you to use ADO instead of DAO. The default library for 2000 is ADODB. To place the DAO library above the ADODB you will need to uncheck...

Hi Mathew. To edit the Hyperlink you have to right click on th link. The comment is seperate from the Hyperlink. It looks from your example that you are duplicating the work I am doing. I am preparing a database that contains every Knowledge Base Article with multiple Search and Xref...

Everything is obvious when you see it. A textbox does not have a 'text' property it has a value property, the value property is the default property so by removing the '.text' you are correctly picking up the 'value' from the text box. Voila! it works. Note: you could also leave out the '.FORM'...

Roy can I thank you for reminding me to get back to basics. I have just been importing a lot of text files into Memo fields and then parsing them from there (a technique I use a lot) In my current project I have a lot of small text files so the basic file 'Open' method would of been much better...

I have had this problem myself. I have not worked out the exact circumstances that it occurs under but as a work around I place the string in a Memo field and then convert the memo field to a hyperlink field either by going into the table and changing the field type or by using an Append query...

Found this link during my wanderings Screen Resolution, Resolved! Scaling VBA Forms to Match Screen Resolution By Ken Getz http://www.officevba.com/features/2000/06/vba200006kg_f/vba200006kg_f.asp May be of use Regards Trevor from www.acceswatch.co.uk

There was a full reply to this earlier this year which includes all the code. Do a search on 'numbers to words' to find it. In this Reports Forum Regards Trevor from www.accesswatch.co.uk

Reason for the message Basically the Update query is warning you that it will be changing data and that if you go ahead you will not be able to recover from these changes. The Append query does not need to warn you because you are not changing any existing records i.e the Apend query is a...

You can use multiple instances of a form. When you do this can make permanent changes to the master form, changes to the 'cloned' forms must be made in code and are temporary (for the lfe of the clone). Any changes to the clone will not affect the Master form. One of the issues to look out for...

Check this link out It appears to be related to the DAO library not being registered correctly http://www.mvps.org/access/bugs/bugs0007.htm Hope this helps Trevor from www.accesswatch.co.uk Question: Does anyine know how to search the Knowledge base when a search string contains a quote or...

2001 Means Operation was cancelled or You cancelled the operation. or You canceled the previous operation Not a lot of help really Regards trevor from www.accesswatch.co.uk [This message has been edited by accesswatch (edited 09-19-2000).]

Look up help on Hyperlinks. Hyperlinks will allow you not only to open an Excel spreadsheet but will also allow you to open the spread sheet and go to a particular cell. Store the Hyperlinks in a table with field type Hyperlink. Display the table to the user rather than a list box or use a...

In form Design View go to VIEW, TAB ORDER Hope this helps Trevor from www.accesswatch.co.uk