Recent content by RiotSloth

*smacks forehead* DUH! Of course, what a fool I am! I put it down to the stinking headcold I have today... many thanks!

Hi guys I am designing a report where I have an invoice address and site address in the report's page header. I am using the canShrinkLines function as suggested by microsoft to remove blank lines in the adresses, as there are two addresses side-by-side and so canShrink willm not work The only...

Thanks Galaxiom I'll try it that way.

Ok, reading up on tempVar it seems they only accept string or var, so that probably explains why I can't do it that way... any suggestions as to a nice, easy way to have access to a JPEG attachment from a user table following a logon?

Yes, jpeg data taken from an 'attachment' field in a client record table. basically IF (login authorised) Set tempVar(user photo) = userPhoto(attachment datatype) from user table So then whilst they're logged in it shows their photo instead of a greyed out head (or whatever)

Hi there all I am trying to store a JPG as a tempVar when a user logs in, but it will not display. If I assign it to a text box it gives the images name eg 'RiotSloth.jpg' But if I use an attachment control it remains empty. Am I missing something? Do I need to specift 'FileData' when...

A2007 switchboard uses macros to generate the switchboard from table data.

Many thanks, Dave, but your reply leaves me none the wiser unfortunately! All the controls for the switchboard are in a macro, what do you mean 'test the option'? kind regards RS

Hi Guys I hope this is the right forum to post this. I am using Access 2007, so have the Switchboard where the buttons are stored in a table. I want to hide buttons depending on the security level of the user. I have the security level as a TempVar, but for the life of me I cannot figure...