Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. cathy68

    portable access database

    ...original code from the master database(.mdb file) is: Set FSO = CreateObject("Scripting.FileSystemObject") SFile = strAppPath & "\traveller2*" ' set source files variable DFile = strTraveller ' set destination directory variable FSO.CopyFile SFile, DFile, True ' copy the files...
  2. cathy68

    portable access database

    Hi vbajock The second method you told me using VBA code. I know Access has a Docmd.trasferdatabase function. When I use: Docmd.TrasferDatabase acImport, "ODBC Database",........(I don't write rest of it) This function will import the tables from SQL server into the master database, but all the...
  3. cathy68

    portable access database

    ...traveller as linked table of SQL backend. Original code as: Set FSO = CreateObject("Scripting.FileSystemObject") SFile = strAppPath & "\traveller2*" ' set source files variable DFile = strTraveller ' set destination directory variable FSO.CopyFile SFile, DFile, True ' copy the...
  4. cathy68

    ODBC call failed

    Hi guys I solved this problem. The answer is: in tblFEMSAudit there is an AutoNum field called"ID " as Primary key. When I design this table at SQL server side, I set up it as "Primary Key", but I forgot to set up its indentity as "Yes", when I link it back to Access application, run the...
  5. cathy68

    ODBC call failed

    Hi Gurus I couldn't fix the question for a couple of days. Please help: When I run the following code I get an--error "ODBC call faileed" 1. This is an Access 2000 application connected to a SQL 2000 database. 2. tblFEMSAudi is linked table from SQL2000 databasse. 3. when debugging the error...
  6. cathy68

    Export data from SQL to excel spreadsheet

    Hi Guru: I tried to use DTS import/export wizard transferring data from SQL to excel spreadsheet. I only transfer one table, there are 30 columns in the table.After finish transferring, I open the spreadsheet, there is only first column of the table I can view, rest of columns don't show up, how...
  7. cathy68

    Insert query syntax error

    Hi Roy-Vidar Thanks for these suggestion. I changed these reserved words as Number and Type. It works fine now.
  8. cathy68

    Insert query syntax error

    I am trying to set up some code to add records to a linking table based on a couple of parameters from the form, using VB in Access Form, SQL backend. I created the linking table (Diary_tb) from SQL server as: NUMBER nvarchar 8 primary key DETAILS nvarchar 50 allowed null STARTDATE...
  9. cathy68

    How can I know which worksheet I chose using VBA for excel

    thanks Zathras, you are really star[2thumbsup]
  10. cathy68

    How can I know which worksheet I chose using VBA for excel

    Hi Zathras I meet another problem. same file, same customized bar, another button call"GoToday", the previous code is: Sub GoToday() cellname = ConvertCellNotation(1, 1) Worksheets("sheet1").Range(cellname).Activate Fcol = 1 Do Until...
  11. cathy68

    How can I know which worksheet I chose using VBA for excel

    Thank you Zathras!!!! [2thumbsup]
  12. cathy68

    How can I know which worksheet I chose using VBA for excel

    Hi Guru I created one sheet in my excel file, and I created a customized bar as “NEW BAR”. In the customized bar, there are 5 buttons. One of them is called “ScrollRight1Screens”, underneath function as: Sub ScrollRight1Screens() Worksheets("sheet1").Activate ActiveWindow.SmallScroll...
  13. cathy68

    change certain columns width using VBA for excel

    What I try to do is I need to repeat "INTERNATIONAL FLIGHT, OVERSEAS FLIGHT, MIX FLIGHT" three text phrases across the entire width of the sheet, these three phrases are difference color. I tried one way as inserting these in column one in fomular bar, repeat it long enough, but when I...
  14. cathy68

    change certain columns width using VBA for excel

    Hi Gurus Are there anybody know how to change columns width of certain cells without affecting the whole column? for example, I want change Range("A1:H1") width, but rest of A or H column width don't be affected except row 1.
  15. cathy68

    comment position in excel 2000

    Thank you combo and xlbo!!!!!!!
  16. cathy68

    comment position in excel 2000

    Hi combo I tried your code. The funny thing is the comment box still in the same position, only I right click mouse, try to edit comment box, I can see its position changed. because I changed around the x, y value. it looks like the comment box having some default position to hold it, I am not...
  17. cathy68

    comment position in excel 2000

    Hi Guru are there anyboyd know how to change the comment box position using VBA. Currently default comment box position is on the top right, is it changed to be under the cell or whatever? thank you very much
  18. cathy68

    let customize bar stay

    Hi Guru I create a customize bar using VBA in excal 2000. it works fine. but when I use minimize or restore button in excal's window,not the minimize or restore button from "Worksheet menu Bar", the customize bar disappeared,and in my VBA code I turn off Formula bar and Status bar, but...
  19. cathy68

    how to deploy Customize toolbar to other users in excal application?

    thank you guys. that is really helpful!!![thumbsup2]
  20. cathy68

    how to deploy Customize toolbar to other users in excal application?

    Hi Guru: I meet a problem to deploy customize toolbar which I create in excal application. this toolbar has 5 controls and I add in different macros for them. In my own computer, this toolbar works fine. When another user open my excel application in his computer, it only shows the customize...

Part and Inventory Search

Back
Top