Search results

pdx_man, you are thinking like me. That's what I did. James

When I copy and paste a table a box appear asking me if I want to copy the structure only, structure or data, or append data to exisiting table. What I want to do is copy a table and only copy the structure and then rename the table. But, I want to do this with code. I do the following but I...

OK, It works now. However, I used different code. Look below. Dim fso As Scripting.FileSystemObject Set fso = New Scripting.FileSystemObject YYYYMM = Format(Now, "yyyymm") DirName = Format(Now, "MMMyy") MkDir "X:\Accrual Files\" & DirName fso.CopyFile "c:\Jennifer Files\*.*", "X:\Accrual...

sPath = "c:\Jennifer Files\*.*" sFileName = Dir$(sPath) I am trying to copy files from C:\Jennifer Files to x:\accrual files with the following code. I first make a directory then try to copy files. It does not copy files in new directory. Can anyone help with my problem? Thanks, James...

Just started a new job that uses Access 2002. Does anyone know what's new in Access 2002? or does anyone know where I can find out? I would like to take advantage of new features but only if I know them. Thanks, James

Try using the ShellExecute API call. http://www.allapi.net/apilist/apifunction.php?apifunction=ShellExecute Hope this helps. James

I found out that I wasn't part of the workgroup. I added myself and now I can convert the DB. Thanks, James

I am trying to convert an Access '97 database to an Access 2002 but I am getting the following error: The current user account doesn't have permission to convert or enable this database. Does anyone know how I can fix this? I can open it with Access '97 but not with 2002. Thanks, James

ghudson, Thanks, you were right about errors in my modules. I was missing a reference that was once there but somehow was unchecked. Thanks, James

I am trying to create an MDE file. I have done this in the past. But for some reason I can not create one today. I keep getting an error stating "Microsoft Access was unable to create an MDE database." Does anyone know why I am getting this error. Please Help James

FYI, I found that I can use the ADO command object to disable the trigger. All I did was use the "Alter ... disable" command in the command text and then execute the command object. This disable the trigger. I believe any Oracle command I've used in SQLPlus will work with the command object. James

Let me ask my first question in a different way. Is there a way I can use SQLPlus commands in VB? Or is there anything in the VB Reference Library that I can use to use SQLPlus commands? If this is possible please help. Thank you, James

Does anyone know how to disable an Oracle trigger using VBA in Access 2000? If so please provide the code. I already have a connection and a recordset working with the Oracle DB. I just don't know how to disable the trigger. Thanks, James

Travis, Do you have a url to the help file compiler? James

I am trying to open a help document, that is a MS Word document, from a command button on an Access form. Is there a macro action that will open a MS Word document? If not, can some point me in the right direction. Thanks, James

I am trying to import a excel spreadsheet into an access database. The import works, but any cell that has both alphabetic and numeric character does not import. Those fields are left blank and a error log table is created letting me know which row the error occur. Does anyone know how to import...

Ok, I found out why I could not add a record to oracle using addnew and update. For some reason the Microsoft provider "MSDAORA.1" in my dns-less connection string did not allow me to use the addnew command. I change the provider to Oracle's provider "MSDASQL.1" with a dsn connection. Now I can...

Does anyone know what I'm doing wrong with the problem I have in the previous post??? Thanks, James

I am trying to insert a record to a Oracle DB but keep getting the following error: Run-time error '3251' Object or Provider is not capable of performing requested operation. Does anyone know how to correct this. My code is below: Dim cnMaximo As ADODB.Connection 'Maximo connection object Dim...

The Browse drive for files will not work for me. I was going to use the Microsoft Common Dialog box, but then discovered that Browsing for a file will not work. What I want to do is allow a user to select the file they want to import. I want to be able to grab file names in a directory and...