Recent content by Crusado

thanks Dennisk, from looking at your example I've cobbled together something that works in the query: RANK: IIf(([05_FULL_TABLE1].[YEAR]=[YEAR] And [05_FULL_TABLE1].[PERIOD]=[PERIOD] And [05_FULL_TABLE1].[STORE]=[STORE]),(SELECT COUNT([GP]) FROM 05_FULL_TABLE WHERE ([GP] >...

Hi, I have a query which brings back the following columns: YEAR; PERIOD; STORE; PRODUCT; GP. The table it is referring to is called 05_FULL_TABLE and I have changed the Alias for this table within my query to 05_FULL_TABLE1. I'm trying to add a field which will rank the products by GP...

Hi guys, thanks for your comments. Just to clarify, all my Access tables have indexes (but I thought this was supposed to make the DB more stable, not slow it down?). The Pervasive tables have primary keys defined, but no indexing. I only reference the data held in the pervasive tables, i...

Hi I've built a macro that runs through about 12 queries one after the other, which I run every day. They basically bring in data from a data warehouse held on a Pervasive server through an ODBC link, then perform calculations based on other criteria in tables held within the access database...

neileg: I've tried basing the form on a query linking the two tables, but it will still not allow records to be changed. KeithG: Its a 1 to many relationship. I've now changed the Dynaset property, but it still doesn't work. The DLookup answer sounds like the one, but I cant get this to work...

Hi I'm using Forms in my DB to update data held in tables. I've successfully built simple forms that just retrieve data from one table and allow you to change the values. I now need to base the form on 2 tables (one of the tables only contributes one field to the form, which I want to use to...

Thanks! Sounds like a useable process - but you've made me think of more complicated parts I should try and add in! Realistically, I need to recalculate predicted Zero Stock dates after increasing the order for an item, and each iteration should evaluate the item with the minimum date (as an...

Hi I think this should be straight forward, but I'm new to VBA in Access and can't figure it out:confused: Here's what I'm trying to do: I'm trying to create an order of several products from a supplier with different costs associated with each product. This bit is fine, I can work out how...

Hi I want to run queries in MS Access, then append the results to a table in a data wharehouse, which i access through an ODBC link. I can write the append query and have found the table name that I want the data to append to by browsing the network list, but when I try to run it, I get the...

I made changes to code and to data held in tables actually in the database (not the datawarehouse ODBC link). I always open the mdb by navigating to it in windows explorer, so it's not that a shortcut was pointing to the wrong version. I wasn't using the "Backup Database" option to create my...

Hi I keep the production version of my database on a server, and a copy of it for development work on my desktop. Today I've made several changes to the development version, which didn't work. I then opened the production version held on the server in a separate MS Access window to compare...