Search results for query: *

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

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

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

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

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

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

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

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

You're welcome. cew657

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