Search results

So we don't even know if you were using action queries... In Access, everytime you open a simple select query you always get the latest data. Unlike some apps like Hyperion...

Sometimes you have no choice but to populate intermediate tables you base reports on.

Seems a bit premature when we don't know anymore than we do about his db -

If you don't have a lot of records to traverse you could write a function to calculate it. Or you could simply store in another fld...

Action queries, the kind that can alter data, typically do not run on thier own. Seems you need to find out what in your application is causing them to run.

Question is confusing. Of course you can run a query on command - Probably need more info on what you are trying to do...

You can do this in 2010.

I would try concatenating before the array line...

What you have will work. Another way would be to have a generic specs table. It eould link back to the parts table. This one be a one to one relationship. In this generic table you would have, say 20 flds named something like fld1, fld2, etc.. Then you have another table which would contain spec...

What about Col?

Thats ok, It seems to be working now - Thanks all the same :)

Thanks for the idea Doc. I have been pecking around and seem to have a solution. If one checkbox is already selected and they select another, in the after update I save the new record id and then using recordsets uncheck all other record check boxes... Private Sub...

Interesting but I'm not sure that would work...

Hi all - I have a table with say 100 rows. There is a pk. There is also a fk. So say 4 of these records share a common fk. Now in the form I show these filtered records. One of the other flds is a check box - yes/no type fld. I only want the user to be able to have this checked true for one of...

a. Turn it all off and turn it back on b. Compact and repair c. Check references

I have some files (pdf and pptx), on a network dirve that I need to print in a report. I was thinking since some of my charts are already in excel then I could somehow download and print the other network documents to pdf and some how merge them all - Make sense? I used the following in Access...

It is simple enough to move old data to an archive file/mdb. I try to make it a point to never throw out data the business has gone to the trouble to collect. Think of it as their potential intellectual business advantage. If you throw it out and they do somehow need it down the road, you could...

The for/next loop you have increments by itself, you don't need the i = i + 1. By the time you get to the bottom i already equals 2... Why not try to get the for next loop to work with out all of your other code to get a better understanding of how it works - ?

Mmmm. Google it :) https://msdn.microsoft.com/en-us/library/bb501030(v=office.12).aspx

Is the header turned on in the form detail sect properties?