Search results for query: *

Hi all - basics of the problem are as follows: I have a dataset with many records. Each contains 12 variables, representing the status of an account at the end of each month in a given year. Is there an easy way to compare these variables (without a lot of if - else statements). I need to...

Hi folks I have written a piece of code to populate cells from a source data file. There will be no more than 12 rows of data in the source file, one row per month. However, sometimes one or more months will not produce any data and the number of rows of data will be fewer. My code works fine...

Hi all - can anyone explain why the following code is returning an error2015 against the 'myVar=' expression? The SumProduct expression is valid when entered in the spreadsheet as a formula. I thought I'd found the answer in thread707-1158104, hence the Evaluate command, but no joy. All is well...

Hi all - today's problem is as follows: I'm looking to return a value in Excel, based on data in a second workbook, subject to two conditions being met. Here's an example of the source data: Criteria1 Criteria2 Value1 Value2 Apples A 10 100 Apples B...

All - I am trying to do a lookup based on the same range for all worksheets in a workbook, and return the results to another workbook (one column of results per worksheet). I'm just trying to get some test code to work at the moment, but (based on Watches) it's falling over when it gets to the...

Hi all I have a formula which multiplies together a number of percentages (too complicated to explain why!), so an example would be: =O3*P3*Q3*R3*S3*T3*U3 Obviously, if one or more of the cells contains zero, the result of the calculation is zero. Is there any way (preferably without...

Hi all. I have previously posted this thread on the Forms forum, but to no avail, so apologies to anyone who is reading this for the second time. I have used the code within FAQ702-1177: Search multiple fields simultaneously and set form to record found many times over the years, in order to...

Hi all. I have used the code within faq702-1177 many times over the years, in order to create a user search form. It has been invaluable. My problem now is that my users require the form to enable them to search, on the same form, between two dates, as well as by text variables. MyCriteria is...

Hi all - stupid question time. How do I make a cell in Excel into a list box, where the user can select from a drop down list which is based on a range elsewhere in the spreadsheet? I know I've dome this before but can't remember how! Any help as ever greatly appreciated.

Hi all I have an Excel sheet displaying various graphs. It was created by saving a sheet under a different name. Each chart has a title, which should display across more than one column, as the width of the text is greater than the width of the column. This works fine in the original sheet...

Hi all - this should be simple, but in fact it's driving me nuts! I have several similar charts in Excel. The title of the 2nd 'Y' axis is the same in each chart. In all except one chart, the label is displayed n one continuous line of text. On the other chart however, the text goes on to the...

Hi all. Is there a way to convert a SAS dataset into an SPSS .sav file without first saving it into a delimited format? I reckon the answer is probably 'no', but I thought I'd seek the wisdom of the forum before abandoning the idea.

I have a number of Excel spreadsheets containing 6 pages of graphs. I have to print these double sided. At the moment, I have to go into each of the 6 sheets in each spreadsheet and select File/Print/Properties/Flip on Long Side. This usually works OK (although sometimes if I'm printing a few...

Hi all I have a database of mortgage applications. I have a query 'QryCasesToWork' which identifies applications to work based on a complex set of criteria. Once the query has run, I need a field called 'ToDo' to update to 'yes'. Unfortunately, one of the preceding queries which goes to make...

Difficult to explain but I'll try: I have a table containing details of all credit applications placed on our online system (thousands each week). One record = 1 application. To identify misuse of the system, I then trawl the table to find instances where, for example, forename, surname...

Hi all - I have a composite database - all it contains are 3 linked tables from other databases. What I need to do is do a total count of duplicates form one particular field in each of the tables. Then display instances only where the total accross the tables is >5 So, for example, If "John...

Hi all I have 2 databases, used for specific tasks in the office. I want to create a new DB for a new task. I would like the new DB to include the functionality of being able to search for a specific value (a customer number) in a specific table of the other DBs and simply say 'yes' or 'no' if...

I have a very simple DB - one table, one form, one subform. I recently deleted 2 fields from the table, and replaced them with 2 others (there was no data in there). Now, when I open the DB, pop-up boxes appear asking for the parameter values for the deleted fields. I am running an Autoexec...

I have a table containing job descriptions & salary details. There are >20k records in the table. In order to filter out statistical anomalies, I want to delete certain records where the salary details are unusually high or low. Is it possible to create a query or continuous forms view which...

Hello – sorry to re-post this problem but it’s driving me mad! I have a search function which builds an SQL statement in VBA using AddToWhere. This is something I have used a lot of times (I think the original code came from some kind member of this forum!) Suddenly, Access refuses to...