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 found my problem table was missing this is how you do it. ("create table testing (test1 text(2))"). this is how not to do it. ("create testing (test1 char(2))"). James

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

I've already try that. The variable does not have a "$" at the end of it. I don't know why the error has it. When i take the last character off it removes "s" form "xls". James

I'm on Windows 2000 and Access 2002. I forgot to mention that I am getting the file name from a commonDialog box. I used xlsName= "C:\Documents and Settings\tvail\Desktop\subcontractactuals09-02.xls" as an example. Maybe the commonDialog box is causing my problems. I try without it. 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...

Replace varResult = Nz([SumOfTotal Days], "") with varResult = IIf(IsNull([SumOfTotal Days]), 0, [SumOfTotal Days]) James

Create a procedure that has two parameter. Then when you call the procedure from the LostFocus event pass the name of the first and last field to the procedure. In the procedure do something like this: sub NAME (1st field, 2nd field) place code to set focus to the 1st field. end sub This...

Just type the procedure name in the line above the code for compacting the database. James

After downloading the COM object from the link that Drevlin provided above I did the following to send batch emails w/attachment without the Outlook 2002 security alerts. Keep in mind that I modified the code below. It will not send batch emails just a single email. One problem I ran into was...

Drevlin, Thank for the info. I will download the com object and play with it. We are also looking into other options. I will keep everyone posted with the results. James

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

Ok I solved my problem. If anyone wants to know how I got the field names from a table look below. Thanks, James Dim MYdb As ADODB.Connection Dim MYrs As New ADODB.Recordset Dim fld As ADODB.Field Dim sql As String Set MYdb = CurrentProject.Connection sql = "select * from...

Ok I solved my problem. If anyone wants to know how I got the field names from a table look below. Thanks, James Dim MYdb As ADODB.Connection Dim MYrs As New ADODB.Recordset Dim fld As ADODB.Field Dim sql As String Set MYdb = CurrentProject.Connection sql = "select * from...

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

Thanks Sohaila, Since I am doing this with VBA I just parsed the field and removed "Accruals" then concatnated "Accrual Reversal" the the field. Thanks, 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...