Search results

  1. R

    Save EXCEL 2007 to EXCEL 2003

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

    Combined query to table or EXCEL

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

    Duplicated Items to Unique

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

    File Format of EXCEL 2007

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

    Call function not working

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

    Copy recordset not working

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

    Cdate problem

    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!
  8. R

    Where to locate a form in Function

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

    GETOBJECT to know that file existed

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

    Question How to know which user access the system

    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!!
  11. R

    How to quit from ACCESS

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

    How to prevent user delete some records

    In ACCESS 2003, I have created query and then sub-form based on that query. The query may retrieve records which contain monthly records of which I do not want end-users can delete records after official monthly ended process. However, records still can be deleted if they belonged to period of...
  13. R

    Question Which PC should I upgrade??

    I got a FE and BE relationship!! Just want to know which PC should I upgrade will run faster than before as a result, if I can only upgrade one of them?? Thanks a lot!!
  14. R

    How to use barcode gun to scan barcode to ACCESS

    How to use barcode gun to scan barcode to ACCESS and then converted to alphenumeric data which can be understood by ACCESS?? Thanks !!
  15. R

    RESULT before UPDATE RECORDSET

    I got a doubt as follows: No matter it is using ADDNEW or EDIT in recordset, values are assigned to different fields but before doing the UPDATE action, if I assigned those fields to another variables. Those fields content would also be assigned to those variable or only can those fields got...
  16. R

    WRITING records which had been used by others

    Sorry that my Access is a Chinese version and I could only manage to explain what's my problem and the error message complained by Access!! Firstly, I create a form and sub-form relationship of which the sub-form linked with a combobox on main form. When user wondering in the combobox, the...
  17. R

    How to close a file??

    I have the following VBA to open a MSQUARE file.... Set TRANS3 = db.OpenRecordset("select * " & " from MSQUARE", dbOpenDynaset) Then, I would like to close it but I tried the following coding and not working as a result!! Any idea?? Thanks!! CLOSE DoCMD.CLOSE TRANS3.CLOSE
  18. R

    Question How to generate barcodes

    I am newbie to barcode but I need to generate barcode for my invoice with the invoice something likes W12675679. Just want to know how to generate barcodes based on that type of invoice number, and how to store barcodes in ACCESS 2003! Thanks a lot for any ideas!!
  19. R

    Question How to check numeric input data

    I have an input box and wanted user just to input 7 digital data. However, I am afraid user may enter string data. Is there any way to check and ensure user can only input 7 digital data to that input box? Thanks a lot!!
  20. R

    RUN a ACCESS PROGRAM when USER open PC

    How to set up when an user open his/her computer, an ACCESS program will then be run automatically and exit without being noticed!!?? Thanks a lot!!
Top Bottom