Search results for query: *

Hi, Apologies, it's been a while since I've done anything in Access and my brain has turned to mush! I'm sure this is very simple.... I have a table with some amounts with differing local currencies. I have another table with the currencies and the GBP equivalents. I need to run a query to...

I have the below code which used to work perfectly well in Access 97 some years ago but now doesn't, either in Access 97 or 2003. The problem is, once the query is created it just doesn't retrieve the recordset? If I go into the query after it has been created and retype one of the values then...

Access 2000. I have a report, based on a query, based on a simple table, that shows a list of individuals, a number field, and a date field. I want to show the historical trend (in a chart which I've done) whereby the x axis is date, y axis is number, for each individual. Now, and here is the...

Using Access 2000: I have created a pivot table based on a pretty basic select query. However, I need to filter the query by certain dates. Now, if I hardcode the dates into the query, for example, 'Between 01/01/2004 and 01/01/2005' then the pivot will run fine. However, if, as I would like, I...

I have created a PT with the wizard, based on a query in my db, but now have modified the query and wish to include an additional field from the query into the Pivot table. However, Pivot tables seem to turn into a different beast altogether when created in Access and I'm completely stuck and...

I have a two tables. Table 1 contains my data and Table 2 is a lookup table containg 2 fields (columns) of values. I would like to create an update query that will try to match the values of a field in Table 1 to the values in field 1 of the lookup table. If a match exists I'd like to then...

Can anybody please let me know if there is a easy way to check whether, 'IF', the CurrentUser belongs to a particular Workgroup? If so, this would lead to a 'THEN' argument. Something like this is what I'm looking for: IF CurrentUser In (or =) WorkGroup 'Name of WorkGroup' THEN ...... Regards...

Can anybody help with the following? I have an Autonumber field as my Primary key. I want to replicate my Database and understand (have tried) that the Autonumber cannot be maintained. However, is there a way, perhaps using the DMAX function instead, whereby I can continue from my last number...

I'm sure this is quite straight foward using a DLookup function of similar, but can anybody help with the following: I have a main table with a number field. On either the BeforeUpdate or AfterUpdate events I need the number the user enters into this field to lookup another table to see if the...

Hello All, Does anybody know how to remove a custom created workgroup (mdw) file and replace it with the default 'system.mdw'? Access Help seems to cover the creation of custom mdw files, but I can't find anything covering the removal of them? I do not want to have to copy/export all of the...

I would like to know if anybody has a general function which can be used, perhaps in the form's OnLoad or OnOpen event, to change the backcolor of all controls on a form depending which control currently has the focus, without having to add an event to each individual controls OnGotFocus event...