Search results

Would any of the excel gurus please be able to help me with a macro to run in an excel 2010 workbook? I wish to create a macro that checks the worksheet to the immediate left of the worksheet with the macro in it and looks for a text string in the cells of a column. When it finds the precise...

Hi, Can anyone please advise me how I prevent a step from running in an access 2010 macro? I used to place a value of "False" in the conditions column to block that step from running but this has all changed in access 2010. Rgds Growlos

Hi, I am looking for a more eficcient way to rank some customer orders using the time of the order per day for the ranking. I can get it to rank OK in a query using an "Alias" option but for large record sets it takes hours and hours to run. Is it possible to create a vba module to do this...

Hi, I am getting a "system resource exceeded" message when running a macro in a database on one PC but the same database and macro do not generate the message on other PC's. The PC that is giving the error message is a Win7 64bit PC with i7-2600k CPU, 16gb RAM using Office 2003. Two other...

Hi, I would be grateful if anyone could please assist me in the creation of a query that checks the order date of a record and then retrieves the ordercategory for the record with [orderdate -2] with respect to the original record. To illustrate the result I have pasted below the fields and...

Hi, I would be grateful if anyone could please help me with a query that will provide details of a customers next purchase category based on the category of their previous purchase? Using the example below: [Customer] [Site] [OrderDate] [OrderCategory] Joes Bakery, Rennes, 01/09/2011...

Hi, I have a ranking query that ranks dates for buyers and sites. The record set that is subject to the ranking is approximately 60,000 records and the query takes 100 minutes to complete. Would I be better splitting the query into separate ranking queries via an alphabetic split for the...

Hi, Would anyone please be able to advise me if it is possible to create a query that will produce output where the order is sorted by a subtotal descending? I have a list of suppliers and their regional offices and wish to obtain a list of suppliers and regional offices where the list is in...

Hi, I have used a data definition query to add a new field to a populated table and set the format of the new field to number. The new field contains no data but other table columns do contain data. I would like to be able to change the format of the new field from Number to AutoNumber so...

Hi, Would anyone please be able to advise me if it is possible to add and populate an auto number field to an existing table using a data definition query? If it is possible any help with the SQL would be most appreciated. Rgds Growlos

Hi, I would be grateful for any help on how I can sequentially number some table records where there are multiple records with the same ID. Using the table presented below as an example: T_Customer_Matrix [Customer ID], [Year], [Month] WP-27, 2006, March WP-27, 2006, April WP-27, 2006...

Hi, I have 2 tables, T_Purchases and T_Discounts and what I hope to do is to use the [ProductID] and [PurchaseDate] fields from T_Purchases in a query that will lookup a discount rate from the T_Discounts table. The tables and fields are as below: T_Purchases [ProductID],[PurchaseDate]...

Hi, I would like to be able to run some code from within a macro that will add a new text field to a table and also give a name to the new text field. I do not wish the new field to be populated with data, just an empty field is OK. Would anyone please be able to help me with this, ideally...

Hi, I am using a union query to merge the results of two separate queries. For one of these separate queries I am setting the entire contents of a date field to null, similarly for a number field. However, when I run the actual union query I am getting the data type mismatch error. I presume...

Hi, Would anyone please be able to advise me on the best CPU type to use with access 2003 / access 2007 on a local PC ? For example, do I need a 4 core CPU or will a 2 core CPU be OK for maximum efficiency, ie, does access use all 4 cores / 2 cores or not etc. Also, is there any impact from...

Hi, I would be grateful if anyone could assist me by providing some code to run a Do Loop that carries out the following: 1. Pass a date from a list of dates to a text box on a form. 2. Run an append query in which the query uses the date set in the text box in the form. 3. Repeat the...

Hi, I hope to be able to run an append query repetitively with each occasion of running the query representing an increment of 1 day. I have a date table containing the dates that I wish to use as incremental dates and I can join this table to my source data that contains the values for the...

Hi, Would anyone know if there is an SQL Server Migration Assistant that migrates an ms access 2003 database to SQL Server 2000 ? I can find the migration assistants to SQL Server 2005 and SQL Server 2008 for all versions of access but cannot locate the same type of application for...

Hi, Would anyone please be able to assist with a message I am getting when trying to update the field format in a table using a data definition query ? The complete message is: "File Sharing Lock Count Exceeded Increase MaxLocksPerFile Registry Entry" I am trying to change some number...

Hi, Is it possible to selectively filter the records in a csv file when importing into an access table, ie, only specific records from the csv file are imported ? I have a large number of csv files each with a large number of records and most of the data is not required. There is one...