Activity Stream

So kind micron but I wouldn't say my database is carefully crafted. I just don't want to go too far linking things up only to find something else...

How many columns did you end up with? CROSSTAB queries are often not practical for report output.

post deleted - misread the original question

Thank you, I had found that code elsewhere. My problem is I don't really know how to use it !! I have easily minimize the displayed Access Form - ...

For info, you can open PDF files in Access using a Web browser control. No need to open an external app such as Acrobat Reader to do so.

Yes. Have a look at the latest version of my example app showing ways of controlling the application interface....

Figured it out, it was a time delay setting in Acrobat Reader. Everything is now working fine.

The PDF files are not in the DB, they are in a separate folder with a link.

Thank you for your response. I got my result using Crosstab Query.

There is an old, proven technique with relational database --1 fact 1 field -- that works great. User interfaces on the other hand are under no such...

Benjam26, Further to Mike's and Vlad's comments: Do you know what each of the records means? That is, have you identified how each of these relates...

Build an aggregate query and/or report using its Sorting & Grouping features and aggregate function in textbox. Have you studied an introductory...

Would be simplified if date part were available. Otherwise, take the elapsed time string and parse it to recalculate to decimal hours. Let x...

I think you need to inspect the code behind the double-click event and the module for the form that contains the bound frame to see if you spot...

Have a look at the attached and see if that is what you're after. Please note that you might need to apply a patch from Microsoft (if you haven't...

I would import the text files in a temporary table that you empty every time before starting a new file (like Mike did in his example above) then you...

Could someone explain to me why, if I chose "Arm weights, R hand 3lbs L hand 2lbs" from a combo today that I would want to make that "Arm weights, R...

Well, you could have the combobox after_update event insert its value into a textbox on the form. That textbox is bound to a field in the table. You...

Why start another post for the same problem in the same forum? Or was it somewhere else? You might hurt your chances of getting an answer here...

It's been a long time since I checked but for lotteries local to me, they had this info. If I wanted to know how many times 46 had been drawn in the...

Concur with Paul.

I just did a test with empty strings in text field with numeric type data and find I was wrong. The numbers will return as Max() value so empty...

NP. Glad you got it solved, though I'm not understanding how you could get away with specifying the target field is a double yet the source file is a...

Sounds like you are trying to do something with a combo that it wasn't designed for. Once the row source is created (be that value list or table or...

I actually reformatted the excel file and on my import spec put the commit, obligation and expense fields as double. I am going to try the Replace()...