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!

Register Log in
  • Congratulations Chriss Miller 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. cew657

    Connect Microsoft Access To Business Objects

    Thanks for you assistance. This will give me a good start. I am going to mess around with it and see what I can do with the response times. Thanks again. cew657
  2. cew657

    Connect Microsoft Access To Business Objects

    Business Objects is used to query data from our mortgage servicing system and contains a lot of tables we can pull essential mortgage information from. It is driven by what they call Informent. It's essentially a huge oracle database that is updated nightly which prevents us from using...
  3. cew657

    Connect Microsoft Access To Business Objects

    I have a Microsoft Access 2000 database which contains a table of loan numbers I want to use in Business Objects. How would I go about linking this table of loan numbers to the tables in Business Objects? I want to add information from the tables in Business Objects to the list of loan numbers...
  4. cew657

    Extra Basic Macro-Printing

    This is what I use to print to a printer: Sub Main() Dim Sessions As Object Dim Sess As Object Dim Sess0 as Object Dim MyScreen as Object Dim System as Object Dim rc% Dim MaxColumn% Dim row% Dim MaxRows% Dim filenum% Dim Screenbuf$ Dim linebuf$ Dim FileName$ Set...
  5. cew657

    importing data from excel

    ...As String, FinalName As String Dim InputMsg As String InputDir = "c:\my documents\ddr backup\" ImportFile = Dir(InputDir & "\*.csv") Do While Len(ImportFile) > 0 tblName = Left(ImportFile, (InStr(1, ImportFile, ".") - 1)) DoCmd.TransferText acImportDelim, ...
  6. cew657

    Updating existing records

    Do you have the employees names in the spreadsheet? If so, you can import the spreadsheet into your Access database and then create an update query joining your tables by the employee name. If you don't have the employee names in the spreadsheet then you will not be able to do this unless...
  7. cew657

    IMPORT Button/Macro to import a Excel file

    The brackets are what is causing the problem. The brackets were to show the components of the command. This is what your command would look like: DoCmd.TransferSpreadsheet acImport,acSpreadsheetTypeExcel9, "Outlets", "u:\Extract.xls", True HTH cew657
  8. cew657

    IMPORT Button/Macro to import a Excel file

    You will need to use the DoCmd.TransferSpreadsheet command. It works like: DoCmd.TransferSpreadsheet [transfertype][, spreadsheettype], tablename, filename[, hasfieldnames][, range] If you want more information on this and an example, then click on help and type in TransferSpreadsheet. cew657
  9. cew657

    How we can change thefield size in MS access....

    You will need to go into the design of your table. Then select the field you want to adjust. Near the bottom of the screen there will be a section called Field Properties. The first option is the Field Size. The maximum is 255. I hope this is what you are looking for. cew657
  10. cew657

    Importing from Excel into existing tables?

    I ran out of posting room. One more thing, you will need to change acSpreadsheetTypeExcel9 to the version of Microsoft Excel you are using. cew657
  11. cew657

    Importing from Excel into existing tables?

    ...ImportDir, tblName As String, SheetName As Integer, Counter As Integer ImportDir = "c:\test\" ImportFile = Dir(ImportDir & "\*.xls") Do While Len(ImportFile) > 0 SheetName = 2 For Counter = 1 To 4 tblName = "Import" & SheetName...
  12. cew657

    Importing from Excel into existing tables?

    Let me play around with a few things based on your reply. I will see what I can come up with. cew657
  13. cew657

    Conversion of Date

    If you wanted to use this in a report, you could create a text box and place the formula in it. When you ran the report, the date would show up like 2002.07.26 HTH cew657
  14. cew657

    Importing from Excel into existing tables?

    I have some questions. Is this process going to occur only once, or on a regular basis? How are the Excel files named? (IE. file1, file2, file3, file4...) How are the worksheets named? (IE. Sheet2, Sheet3, Sheet4, Sheet5). cew657
  15. cew657

    Print Active Record

    I have this attached to my button for printing a form: DoCmd.DoMenuItem A_FORMBAR, A_EDITMENU, A_SELECTRECORD_V2, , A_MENU_VER20 DoCmd.PrintOut A_SELECTION What I do is go into the design of my form and get it set up the way I need it to look printed (IE. landscape, set margins, etc)...
  16. cew657

    Conversion of Date

    I posted this in your other message. I would create a new field in your table called NewDate. Then I would create an Update Query and place this new field in the Field grid and Update it to: Left([your field name],4) & "." & Mid([your field name],5,2) & "." & Right([your...
  17. cew657

    Conversion of Date

    I would create a new field in your table called NewDate. Then I would create an Update Query and place this new field in the Field grid and Update it to: Left([your field name],4) & "." & Mid([your field name],5,2) & "." & Right([your field name],2) I don't like updating...
  18. cew657

    Returning the day of a week

    Try the following function: Function fn() Dim mydate As Date mydate = Date 'Returns current date Select Case WeekDay(mydate) 'Returns the weekday number of mydate variable Case 1 fn = "Sunday" Case 2 fn = "Monday" Case...
  19. cew657

    Open an ExcelSpreadsheet

    You're welcome. cew657
  20. cew657

    Opening ASP Form In Access

    I am using Access 97. I have a form with a button set up. When this button is pressed, the website is embedded in the form. This website is used by our company to view imaged documents. I want the documents to appear in the database so users don't have to go to different applications to...

Part and Inventory Search

Back
Top