If I get this to work, could we switch over to Yahoo! chat or AOL Aim?read this:
https://www.accessforums.net/faq.php...b3_attachments
you may have an unaccepted type or it might be too big. forums always accepts ZIPs. you can always zip it. also, compact it before you upload. it may be bloated if you haven't done this
Thanks
I will be working on something else here at my house, but my messaging options are next to my name. I have yahoo and aim.
BTW, I loved the taskbar on top like you have on your machine. Did you know you can rotate your screen 90 degrees by ctrl+alt+arrowkey??
I found that by accident last week. It works on xp and vista, but apparently not on 64 bit machines? my DT is 64. weird! I was looking forward to reading upside down tonight.
Alright, after trying everything. I zipped her up for you.
Last edited by yes sir; 08-31-2010 at 07:38 PM. Reason: removed attachment
send me a message if that's what you want to change to
LOL. I didn't know that about rotating your screen. I'm going to mess with that later.I will be working on something else here at my house, but my messaging options are next to my name. I have yahoo and aim.
BTW, I loved the taskbar on top like you have on your machine. Did you know you can rotate your screen 90 degrees by ctrl+alt+arrowkey??
I found that by accident last week. It works on xp and vista, but apparently not on 64 bit machines? my DT is 64. weird! I was looking forward to reading upside down tonight.
I threw the taskbar on top and have liked it ever since. But the real reason I did it was because I tossed a screwdriver across my room one day and it nailed my screen and left a small dent (lucky me) on the bottom where the taskbar originally was. Now the dent is in a spot where I hardly look.
is this what you want?
Yes it is. I'll also want that for the Agent as well (currently shown as N/A and N/A). Is that possible? And yes you are a genius.
A GENIUS. LAUGH.
put this in the tbox control source:do the same for the agent box. I'm sure you can do that yourself now.Code:=[first name] & " " & [last name]
I did this earlier, but with capital letters. Would that matter? Maybe I did something else.
Also, wouldn't the code need to be adjusted for the Agent? Its not as simple as adding another text box and typing in the same control source, it would just put ### again.
Last edited by yes sir; 08-31-2010 at 07:41 PM. Reason: professional reasons
character case is irrelevant in most parts of access (for all practical purposes, unless you are at expert level doing coding).
if you notice on your rpt, the agent fields are called LAST NAME_AGENTS (etc...). You changed them using the AS keyword in the query.
I used the same control source as you, but subbed First Name_Agent instead of first name and did the same for the last name, but now I'm back to getting the parameter value message box upon opening the report.