Search results

HI All, I have a crosstab query that runs in about 9 seconds.. pretty good i would think. My issue though is everytime I try to turn it into a form, access stops responding. I tried specifying an ID to narrow down the query and now I cant even save the query... Does anyone have any tips on this?

im not sure you can create a expression and call from it. You need a table or query to pull from. TablenameN is an expression in your current query As for your 2nd problem, you have just tablename in there. You probably dont have a table named tablename...

Here is an msdn link on how to change the font using vba http://msdn.microsoft.com/en-us/library/aa195892%28office.11%29.aspx

Are you using the windows username of the user? You can use =environ("username")

Sadly, afaik you cannot do this

There is also the folder redirection option that you can do with AD. Works pretty good. Good for giving desktops and other stuff too!

Yup We are running it right now for the whole district. No issues

In AD there is a homedrive option. You can map the users homedrive directly to their network path and it will give them that drive and files no matter what computer they log in to. We use the letter H: so everyone knows that their h: drive is their documents folder now.

Windows 7 has whats called libraries. We are using it here with AD and have had no problems mapping their documents to their network drive

if you've installed it more than 3 times, id say that they might give you a hard time about it...

you need to do >= 10/1/10 for it to work Edit that wont work either. The issue is that you have a bunch of differnt possibilities. 10/1/11 is greater than 9/30/11 and greater than 10/1/10 so it will show for both and since it gets to the 9/30/11 one first it takes that

how did you create this button? Your code needs to look something like Private Sub Command27_Click() On Error GoTo Err_Command27_Click Dim stDocName As String stDocName = "17 CASES WITH ALL DEP POT EMANC Q" DoCmd.OpenQuery stDocName, acNormal, acEdit stDocName = " 18 CASES...

ok you are missing something you have On Error GoTo Err_Command27_Click but you dont have an Err_Command27_Click in your code

you only need to do this once Dim stDocName As String

im liking plants vs zombies too course i like those defense type games....

Ah crap I missed it. Happy Belated boB!

I gotta say, as an avid soccer fan, that the game yesterday was pretty bad. It was a ugly ugly game! No way should 2 of the top teams in the world hack and slash their way up and down the field like they did. Felt like I saw a card every 2 minutes!! As far as the game play went, I don't think...

Cool? That's too bad. We've had 90+ degrees the past 3 days. It's been amazing. Sun and fun! It was a great weekend.

Actually Dr. Nick used to say Hi Everybody... not hello. Get it right :)

You felt it too eh? I didn't personally but some in my building said they did.