Search results

That I have not tried. Thanks for the suggestion. I'm not sure I have enough permissions to do that. I think I have just enough to link to the table. I will ask the person holding the keys if they want to give that a shot. I'm assuming that's going to seem a little risky to them and...

Thank you ridders!!!!!! You pointed me in the right direction. It was an inner vs outer join issue. I just had to swap it up to get rid of the error message and then I was able to see that I could in fact pull both queries and they had different names even though they came from the same field...

I get this when I try to do it the way I mentioned above: The SQL statement could not be executed because it contains ambiguous outer joins. To force one of the joins to be performed first, create a separate query that performs the first join and then include that query in the SQL statement.

I took over an old Co-Workers Program and there are some people wanting a few changes. The only issue I'm having is on a report that is pulling from a few Queries. Its pulling the sum of the Total Time field When the Type field = AO. Well now they want to also be able to see the sum of the...

I have an Access front end with a linked table to SharePoint. There are only 3 Fields. Number Name REV Everything is fine for the first 4,500 records. But for some reason, the last few 100 are missing the Number. Its so weird. The items are on SharePoint. If instead of creating a...

Thank you ridders!!!!

Hi.......... I added in some email functionality to one of my program which now will not work for the one user who happens to have a 64 bit version of Access. I know what bit of code is causing the error and I was wondering if anyone new what I need to change in it so that it will work for 64...

I have an Access program on Citrix that has been working just fine. First thing this morning everyone was able to print. But all of a sudden around 10ish, a message now comes up for everyone when they try to print that says: "Before you can use the feature, OneNote must start for the first...

Absolutely! Our local SP guy is not in today so I have to wait till tomorrow. I want to start with him and not jump the chain of command. But I'll let you know everything I find out one way or another.

Thank you. I will start there.

I have a program I'm running off the server with no issues. More then one person can be in it at a time. But if I add a linked table to SharePoint, only one person can be in it at once. It pops up with an error message saying its locked and currently in use. Is there away around this?

We have a new engine coming soon and the guy who wrote the LabView program for our current engine has retired. I've been tasked with coming up with a program for the test bed for our new engine. I see that we can read/write to an Access table with LabView so as of know, I'm going to make the...

For anyone who uses this thread I wanted to save you a ton of time. Make sure you go into Tools and Reference Microsoft PowerPoint 15.0 object Library. Or whatever version you have. It might not be 15.0.

That the one!!!!!!! Thank you so much!!!!

Actually I know how to open it. Just need to tell Access that is the Slide I want to write to.

Ok I think I will be able to add the data I want using those links. Last I just need to figure out how to open it and set it. Those links show how to create a new one. I need to adjust one that already exist.

(Sorry if this is in the wrong place I didn't see anything for Power Point and I really think its an Access issue more then Power point but I'm ok if it gets moved) I have created a Power Point slide with a few graphs and text boxes. I want to place a button on an Access program that will feed...

Ok I will start with my Citrix Administrator. Thanks Doc!!

I don't know a thing about Citrix. I just drop my program into a fold IT gave me access too and then give them a list of people I want to be able to use it and they set it all up. And then I give everyone a link, that was given to me, so they can log into my program. When you say, "Try...

I have recently moved a program from running off our server to Citrix so remote users can use it. Its working amazingly but I found while making the transfer, it didn't like to reach out to Outlook. When a form was created, the program would send out and email to the next person to let them...