Search results

You are not going to be able to open a word doc and resave it as a txt file from within access. You can open the document with word but thats about it (I'm sure someone will correct me if I'm wrong). Once you have the txt documents do you want to create a new table or append the data to an...

This will not automate the import of data into a table. You will need to write a routine to do this. I have done routines to automate excel imports and csv imports, but not with rtf files. If you want to send me your database I will see if I can help you.

It allows you to open up a file window and browse through your folders. You can limit it to specific file extensions etc. You can then use the selected file name within your app. Have you tried re-installing office 97?

I don't have Hotmail. You can email me if you want.

Give this a try. http://www.microsoft.com/downloads/details.aspx?FamilyID=6a7d785f-c2e0-471d-a33b-82ad1d514737&DisplayLang=en

You could try downloading the Microsoft Data Access Components 2.6 file.

On the 'ToolBox' menu bar there is an icon with a hammer & spanner on it (more controls). Click on this and you will get a drop down menu.

Use the Microsoft common dialog control. You will find it under 'more controls' on the tool bar

Ian, I don't know if this will help. I use this in a sort of database management DB. It will open up a secured database to the log in box. Dim StrDB As String Dim StrCmd As String Dim StrSec As String StrQt = Chr$(34) StrDB = Me![Location] StrSec = Me![SecFile] StrCmd =...

The reason that it will not work on other machines is because they will not have the required .ocx file. If you check the references on the client machine you will probably notice it says MISSING. You will need to copy the .ocx file to the correct location on the client machine and then register...

Basically the If .execute() >0 Then means that if the file search finds the file (or any number of files depending on what you are trying to do) it will return a non 0. If it does not find any files it will return a 0. I have not tried it with any other office apps so I can't answer that. As...

Make sure you have got the 'jpg interchange format' filter installed. It should install automatically with Office 2K but you have to do it manually with stand alone Access.

Jet Replication Objects. It's an extension to ADO used for compact/repair.

Thanks for the replies, from what I've read, XP seems the way to go. IMO, I will give your code a go. Thanks again.

Has anyone ever used Access to import XML data. My boss has been told that it is possible but I've never used it. I have searched the forum but there are not many threads on XML. Can anyone offer any advice??

Have you tried using the Task shedule in Windows. I do a similar thing but it exports an email at a certain time everyday. Even if Access isn't open you can open it, run your code and the close.

Are you using Office or stand alone Access? If it is stand alone Access you will need to install the 'jpeg Interchange format' filter.

With Application.FileSearch .NewSearch .LookIn = "c\:ABCD\123." .SearchSubFolders = False .FileName = "Paused.ini" If .Execute() > 0 Then Run your code Else Exit Sub End If End With

Are you getting any error messages or is it just not opening?

I'm using Windows 2K and Nero burning software and it works everytime the CD is inserted.