Recent content by Never4Get

Don't bother. I got around the problem by using the old DOS-names for the directories. Yet, if someone has a better idea, it would be appreciated.

I'm desperately looking for a solution to the following problem: In my application I open several reports in another application. These reports however can't be opened if the pathname contains blanks. The program opens, but then an error message appears: "File Not Found". The statement looks...

Create a macro which runs the code to send the e-mail. Then save this macro under the name "AutoExec". When the user opens the database, this macro will run automatically.

Hi, I'm not really sure, but I remember having a problem when opening a file if the filename contains white spaces. Try changing the filename like "Shift_End_Report.xls".

I'm currently working with Access 2000 and the following references are selected in the VB-Editor: - Visual Basic for Applications - Microsoft Access 9.0 Object Library - Microsoft DAO 3.6 Object Library - Microsoft Office 9.0 Object Library - OLE Automation My application is running with these...

Try using the following API-functions: Private Declare Function apiGetClassName Lib "user32" Alias "GetClassNameA" _ (ByVal Hwnd As Long, ByVal lpClassname As String, ByVal nMaxCount As Long) As Long Private Declare Function apiGetDesktopWindow Lib "user32" Alias "GetDesktopWindow" _ ()...

Huge problem... I've created an application which creates a database from scratch and opens several other applications. On my main form there are several buttons, one to create the database and two buttons to open two other applications. These buttons all work fine. The applications open as...

Thanks digruntled, Your SQL-statement worked fine.

Now that I found a way to import a .dbf-file, I would like to insert a column in the resulting table. Could someone tell me how please??? Thanx in advance

You were right. Using the TransferDatabase method is what I did.

Never mind, I already found the solution myself...

I can easily import a .dbf-file using the option <Import...> under the menu <File> but I would like to import the same file using VB-code. I already tried DoCmd.TransferText but this method has to many arguments. What method should I use instead? Thanx in advance

I've created VB-code which reads several tables and generates different reports according to the values in the tables. I can print each report before the next one is generated, but actually those reports should be saved in an RTF format. How can I export these reports using VB-code.

I've created a form with several buttons. One of these buttons opens a Windows Application. This application should however open only once, so when the user presses the button again, an error message should appear. Is there a possibility to know weather or not the application is already running...