Activity Stream

I am totally confused...... Maybe you would post the SQL of the record source (queries) for 2 or 3 of the reports?

research ms access Application.FollowHyperlink and use that in your click event.

Looks like an un-normalized design, which is likely the root of the problem. Yes, if 2 or more reports are basically the same, it is a common error...

SIMPLE SOLUTION! ... seems I am having more and more grey moments ... might be time to throw in the proverbial towel ... completely forgotten that...

I'm continuing to update this thread for posterities sake; maybe someone will come looking for some messy barcode parsing code. I've managed to...

That is seldom really true, but you might have an exception. The thinking is that forms and reports should do calculations on the fly in case any...

I never knew that! :idea: And yes I'd agree about the tag method as well. Use it all the time.

That's probably good advice in general, but in this case I needed it stored in the table. I found a way around it in Excel which is where the data...

These form procedures are in the form module and not a standard module, yes? Rather than remove a whole module, I prefer to click the property sheet...

Proble solved. My form module was declared as Private Sub tbSearch_Dirty() rather than Private Sub tbSearch_Dirty(Cancel As Integer) One...

You say you don't have the file name as part of the path, yet you can display the file in a web browser. For that, do you not need the complete path?...

No joy. When I compile I get this:

Unfortunately that did not solve the problem.

The saved off PDFs are on a server. They are used as a reference. I would like to be able to print the after they have been stored so when we have...

This sounds like a rare form of corruption: dis-association of a form from its code module. If that's the correct diagnosis, the fix: In VBE go to...

Is that the code version of keyhole surgery? :)

Do you have a procedure called Error_Handler (it should just be a label inside the other procedures)? EDIT: sorry didn't see all the code inside...

Yes, if you put them in a standard module, not behind a form/report.

Where are the pdf's - in the db or on a server? You want to print this some time after it was created, or perhaps at the same time? You're actually...

I have just red it, yes, this is exactly what I need. Thank you. I am not sure (of course can try easily): if I put these functions into a...

I have written some code that successfully handles 2 dimensional barcodes, where all of the data is entered in one line. This assigns each piece of...

Did you see the link in post 3?

I need to insert records into a table, and there is a field where I need to put the highest value out of four other fields. If there would be a...

FWIW, TypeOf...Is is an operator. IIRC it's not even listed in vba - because it's VB. So oddly enough, the control types are not ac constants thus...

This type of thing? http://allenbrowne.com/func-09.html

Can you give a fuller explanation of what you are trying to do.