Search results for query: *

Hi, We are using a MS Access database (.mdb with .mdw security) that is stored at a central server. The persons that work in this database either have MS Access 2010 or MS Access 2016 installed. If a user that has got MS Access 2016 installed opens the database, everything works fine. But if a...

Hi, We are planning to move from Access 2010 to Access 2016 (using Windows 7). Our databases are in .mdb format and they are 'protected' using .mdw files. This works fine in Access 2010. But if I try to open the same database in Access 2016, I get following error message: "Cannot open a...

Hi, I'm using an Excel-2003 spreadsheet with 20 columns: A: Productname B: Quantity C: Productname D: Quantity E: Productname F: Quantity etc. untill column T. The Productname-columns contain Text and the Quantity-columns contain Numbers. On every row, a maximum of 3 Productname columns are...

Hi, I've used the macro-recorder in Excel 2010 to create a script that imports the data from a 'data-workbook' (data.xls) into a 'master-workbook' (master.xlsm). So I just used the standard button 'Import Data' and recorded the VBA from that button. Now the script itself is working fine, the...

Hi, I'm using MS Access 2003. Table 'T_discount' has got following fields: Customer Brand From_week To_week So following records are in the table: A - X - 2 - 6 A - Y - 7 - 8 B - X - 3 - 5 B - Y - 4 - 9 B - Z - 1 - 5 So in the table the discount periods per customer per brand are maintained...

Hi, I'm using MS Office 2003 and have got a question about importing an Excel file with VBA into an MS Access table. The Excel file needs to be imported once a week. It's exported from another system to a default folder and the Excel file always gets the same name (let 's say 'data.xls'). Row...

Hi, I'm using a database on a SQL-server that contains the sales from a few dealers to different endusers per period. So each dealer has got his own endusers. Now the goal is to analyse the number of new endusers compared to the previous period. Outcome should be grouped (on row-level) per...

Hi, I'm using a MS Access 2003 database. One table in there contains almost one million records. Performance is quite bad as there are a lot of complicated queries running on this huge table. I've copied a test-version of this database to SQL-server. Now copying the tables to SQL-server was not...

Hi, I'm using an Access 2003-database that contains table T_Orders. Some fields in this table: Order_Date Article_number Article_group Quantity I've created an administrator-user in the .mdw-file who can administer the database. Besides that I've also created a user-group in the mdw-file that...

Hi, I'm using Access 2003 and have a question about "topvalues". I've created table T_Sales with following fields: Customernr Period Productgroup Sales Suppose we've only sold in Productgroup A, B and C. Following example records could be in the table: 1000 - 200701 - A - 850 1000 - 200701 -...

Hi, I'm using MS Access 2003 on Windows XP and I've got a question about selecting specific records from my database. The tables are defined as follows: Table 1 : T_Customer Customernr (primary key) Customername Table 2 : T_Sales Customernr Periodnr Article_group Sales_euro (primary key is...

Hi, I'm using Office 2003 and have an Access database in which I use the following code: DoCmd.OutputTo acOutputQuery, "Q_export_all", acFormatXLS This works fine, except for the fact that I have to save the exported excel-file as an "Microsoft Excel 5/7 (*.xls)"-file by default. In the "save...

Hi, I'm trying to create a "scheduled task" in XP that opens a specific Excel workbook (C:\Data\test.xls) each Monday. Can anyone tell me how to do that? I've managed to create a scheduled task that opens up Excel, but I cannot create the task in a way that it automaticly opens up the workbook...

Hi, I'm using Microsoft Access 2003 and got the following question. Table T_Sales contains the following fields: Customernr Date Sales Now I'm looking for a query that gives me the 2 records (per customernr) that contain the largest sales. So suppose the table contains (custnr, date, sales)...

Hi, I'm using Excel 2003 and have the following question. I'm looking for a formula that gives me the right-most value in a range of cells. I tried the following formula: =INDIRECT(ADDRESS(ROW(A1);MATCH(0;A1:E1;-1))) This formula gives me the rightmost value in the range A1:E1. That works fine...

Hi, I recently switched from Excel 2000 to Excel 2003. It seems like Automatic Recalculation is taking a lot longer in Excel 2003 than it used to do in Excel 2000 (for exactly the same workbook). I opened a workbook (created in Excel 2000) in Excel 2003, waited untill the calculation was...

Hi, I'm using Access 2000 on Windows 2000 and got the following question: In Table "Sales" I have 2 fields : Customernr and Articlenr. I would like to create a query that displays the unique number of articles per customer. So suppose I have got the following records in the table: 10 E4500 10...

Hi, I'm using Excel 2000 on Windows 2000 and got the following question. I have 2 workbooks: 1. Total Sales 2. Detailed Sales In workbook 1 I'm using the following formula: =SUMIF('[Detailed Sales.xls]Sheet1'!$A:$A;A2;'[Detailed Sales.xls]Sheet1'!$B:$B) As long as I keep workbook 2 opened...

Hi, We're using Word 2000 on Windows 2000 and got the following question: If you go to "File" in the Word-menubar, you get a list of recent Word-documents. But you don't see the complete pathname of the file. Is there a way to retrieve the full pathname? Thanks for your help! Regards, Robert...

Hello, I am using Outlook 2000 on Windows 2000 and got the following question. In the status bar on the bottom of the screen, you normally see the number of mails that are in the box that is selected. But right now I only see the status bar but not how many items a box contains. Do you know how...