Activity Stream

How can a file be accessed via an email address? Attach file to post. Follow instructions at bottom of my post.

Yes, yes, I know. I have seen the "warnings", even though it is a canned function ("Lookup Wizard") in MSACCESS. Creating a form (and hooking to a...

Thanks Minty. I did try that code, and the file is NOT open. I even tried creating the Excel a different way, instead of automating Excel I used...

I don't understand "drive" or "share with the email address". I couldn't find where to download the dB. I'm not having any fun. :( So much easier...

I believe I found the problem. It seems that 1 of the tables in the working version was local and when I imported the tables after deleting them so I...

Not with a macro. If you use Outlook Automation it is relatively simple to create an email with the users default sig in place.

Ajax, I am trying to debug now but so far no luck, All I did was add a user that's why I am so puzzled, also puzzled about can open in design...

I know the principle, but as I'm not experienced, I need the redundent data to control my Procedures and dependencies... and in Table1+Form I decide...

sumif is an excel function not used in access. try monthsLost: -sum( is null and monthsEarned<>0)

using lookups in tables is a bad idea - use a form.

almost certainly some code that runs when the app opens. check if your login form open, load and current events for code and step through it You...

Use Max() on the end date and group by CarID for the sub query and link on id from main query?

More importantly, why do you want to duplicate data from Table1 into Table2? Data should only ever be stored once so this situation should never...

Thanks, I just tried that but it does the same thing

I don't make 2 recordsets! the data in the form are those from/for the underlying Table1 !!! but when I finish a line I would like just to type on...

the data in the master form MUST be saved before you can copy it or add/copy any data in a SUB form. New data must generate the key (autonum), then...

Must be a setting within Outlook as I can open links without any Ctrl key? I do only have 2007 though?

I'm sure that is an Outlook setting to prevent accidental opening of dodgy links, nothing much you can do to control it. I think Once, A long Time...

Absolutely nothing that I am aware of. It was just a very big number and is a prime. Unless of course... You are a paid up member of the tin...

instead of importing manually each time,do it this way: 1. save the file (excel, or text) to a generic name everytime: c:\temp\File2import.xls ...

I can't see how that macro knows what the cross out field reference is. Maybe it would work if you included the form reference - don't know, don't...

I have hardly ever used macroes for this very reason. I have just tried with a Tempvar and that works. I only have 2007 so have to do it in...

I doubt that very much. It likely runs but doesn't do what you expect. Examine the query, especially the sql view. Perhaps that view will point out...

What is the significance of that number?