Search results

Is there a sql statement that will allow me to change the name of a column? Thanks, James

Microsoft has done it again. I been working on importing an Excel 2002 spreadsheet into Access 2002 all day. It was simple with prior versions of Office. If any Access 2002 users or developer recieved the message "External table is not in expected format" when importing a 2002 spreadsheet; and...

I am trying to create a table in vba docmd.execute("create testing (test1 char(2))"). It seems the the create statement doesn't work in access 2002. I've used it with oracle. I need a statement that will do this. Please help. James

The line of code below gives me an error. I believe I get the error because the name of the excel file has a "-" in it. Is there a way I can keep the hypen in the filename?I don't want to check the file to see if it has a hypen then remove it before the transfer. Attached is the error message...

I am sending mail and attachments using Access 2002 and Outlook 2002. When my code send the mail Outlook gives me two prompt for each Recipients. I attached a word file with the prompt images. does anyone know how I can bypass the prompts. This applications is a batch mail application and sends...

I posted this on Modules & and VBA but maybe someone can help me here. Is there a way to check if certain fields exist in a table using SQL. I want to add three fields if they don't exist after I import the table from an excel spreadsheet. Thanks in advance, James

Is there a way to check if certain fields exist in a table. I want to add three fields if they don't exist after I import the table from an excel spreadsheet. Thanks in advance, James

Is there a way I can update part of a field. For example, I want to change "Accruals - Subcontract" to 'Accrual Reversal - Subcontract" I just want to change "Accruals" to "Accrual Reversal" But I want to keep everything after "Accruals" Please help, James

I have a drive that have the following folders. Jan02 Feb02 . . . Aug02 A new folder is created manually each month i.e. in October I will create a Sep02 folder. What I need to do is grab the folder name of the last folder created. I know how to use the dir$ command but I don't know...

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...

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

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

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

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

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...

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...

Is there a componet that will allow me to browse a drive for files? If not is there a way to create one? I am trying to import a file, but I want to user to be able to search their computer for it. Please help. james

I am using the below code in a module to access a table. How can I do this using ADO. The database is already open. I can not declare the ADO as a database. Dim MYdb As Database Dim MYrs As Recordset Set MYdb = CurrentDb Set MYrs = MYdb.OpenRecordset("select * from UploadInventory"...