Search results

In an application, I used to download 5 to 6 EXCEL 2007 files to work. Then, my ACCESS 2003 only can upload EXCEl 2003 files. Just want to know, besides the manually saving lower version in EXCEL, is that any VBA or MARCO in EXCEL which can automatically all EXCEL 2007 to EXCEL 2003 file...

I have created 3 web link in TABLE to link 3 EXCEL files! Then in QUERY, I have create a query with the following SQL language..... Select * from TEMP1 union all select * from TEMP2 union all select * from TEMP3 And the query do exactly what I wanted .....which is the combined result of all 3...

Thanks! But my idea is to save the items in a file but not using query to have summary query result!!

I got a long EXCEL file with many same items name, such as follows: Orange 3 Apple 4 Orange 5 Orange 6 Apple 6 Orange 4 Just want to know is there any way just to have unique item in an Access File after I import that Excel file to Access. In the file, I just need the following 2 records...

ActiveWorkbook.SaveAs Filename:="D:\TO2007" & str3 & ".xlsX", _ FileFormat:=xlExcel14, CreateBackup:=False I used to work with 2003, but one customer would like to have an Excel in 2007 format. I used 2007 version to open a 2003 Excel sheet. The above VBA is trying to save the EXCEL sheet...

I re-added a ADO and it worked well ! Thanks a lot!!

I have read some articles! It seems what I should get is 2.8.1 or .2 version for XP !!

Thanks JHB for your reply! However, when I run the ACCESS, it telling that my msado15.dll should need a 6.1 version! Under what environment did you run the ACCESS?? I don't know where to obtain a 6.1 version masado15.dll!!

I got the functions coding from the web, and I just using a command button to call the function. But it is not working and given some error message that I couldn't understand! I have used a Chinese version to run that coding, but it also could be run under English ACCESS version. Thank a lot...

Dim rsRecordset As Recordset With DB Set rsRecordset = .OpenRecordset("TRANSACTION where NAME = '" & TTNAME & "'", bOpenDynaset) End With Dim sqlStatement As String sqlStatement = "INSERT INTO TEMPFILE1 VALUES" & rsRecordset ' With rsRecordset rsRecordset.MoveFirst Do rsRecordset.RunSQL...

So I do think it is the problem of the ACCESS 2003 itself but not any linkage!!

I gave up to link according to table fields and created a text box! Putting the value to text box firstly, and then query according to text value! But the ACCESS 2003 simply didn't recognized the linkage! When I ran the system, ACCESs 2003 asked me to fill up the value of the linkage which is...

My case is may be different from yours!! I got 2 different systems but a form/subform relationship had been built in both systems! They are exactly the same, one worked well but not the other. The other got the same problem as yours!! Any idea??

It's the problem of space!! Now is working well!Thanks a lot!!

TDAY = CDate("STR(Me.Combo25) & " - " & Me.Combo21 & " - " & STR(S1)") OR TDAY = CDate(STR(Me.Combo25) & " - " & Me.Combo21 & " - " & STR(S1)) I have tried both, but both were not working!! Any help ?? ThankS! Me.COMBO25 and S1 are TEXT data and Me.COMbo21 is numeric data!

Public Function CalendarFor(txt As TextBox, Optional STRTITLE As String) 'On Error GoTo Err_Handler 'Purpose: Open the calendar form, identifying the text box to return the date to. 'Arguments: txt = the text box to return the date to. ' strTitle = the caption for the...

GREAT! Thanks a lot!!

I got the following VBA code, just want to know how to know the file in the GETOBJECT existed! MY idea is to know 1) if the file existed then do the Marco inside the file and 2) if it is not existed then put the file name in a table?? RIght now, when the VBA encountered this GETOBJECT statement...

In internat, is there any way for ACCESS to know which user access the system, and may record something like IP address or ID in a log!!?? My idea, is to display the user ID in an invoice which is created by him/her!! Thanks a lot!!

I got the following batch file command "C:\Program Files\Microsoft Office\OFFICE11\MSACCESS.EXE" "C:\COMMON\PRINTACCESS.MDB" of which is to trigger a autoexec marco to print some table automatically. However, after print the last VBA is DOCMD.CLOSE. But it only quit to close the...