Recent content by cew657

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

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

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

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

I came upon this post and thought I would throw my two cents in. The following code is what I use to import several hundred .CSV files into my database. It will loop through each file in the directory specified and pull in the file according to the extension. You will need to modify the...

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

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

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

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

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

Below is the code you will need. Sorry it took so long. We have had internet problems the last few days and I wasn't able to get back on. Anyway, what I did was create a form and then placed a button on this form. This is the code for my button. What it will do is go to a specific...

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

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

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

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