Answered my own question again (I think):
I used this function:
Declare Function GetUserName Lib "advapi32.dll" Alias "GetUserNameA" (ByVal lpBuffer As String, nSize As Long) As Long
to nab the username, and used the result in the where clause of a query filled with...
Start you're batch file with these lines:
@echo off
echo Please wait: Database is loading...
Allow the window to pop up as normal, but then use a function that runs automatically when MS Access starts up to minimize or hide the window until it closes on it's own. This is still not the...
Hah,
Problem solved...
I simply deleted the linked files, and re-imported the files in the same spot on the same slides with the same properties as embeded after each time I update them. A little more time consuming, but much more effective.
One last question concerning Access Report to PowerPoint Conversion:
I'm attempting to copy arbitrary objects from Access Reports to PowerPoints. I have no idea how to accomplish this.
So far, I've tried:
Object.SaveAs (filename) ' Unsure of syntax... but it's correct in my procedure...
Well, I should have asked this to begin with, but now I've found the solution. I only wanted to close it so that I could open it visibly with the ability to edit it. The servers for objects will always remain running as long as the code is running. Rather than closing it, I just made it...
Unfortunately, my computer still has no love for me. Thank you for that though. I tried it, it works faster for some reason now, but still doesn't work. There it is... powerpnt.exe staring at me on the list of processes.
I'm not sure if I'm correct on this or not... I've been programming for years, and within the last 9 months I've been working with databases (first time ever). I think that when the record is found, focus is shifted to one of the fields. Meanwhile, the programming selects the record and...
I Am creating a massive procedure which creates a powerpoint based on information which is E-mailed to my database's E-mail address (yes, it has it's own E-mail address). It gather's information from an XLS attachment in the E-mail. All of that works just fine. The problem I'm having seems...
Using MS Access 2000, I need to make a main menu that is different depending on the group the user logged on as. I've figured out how to display the username, but not how to nab what group they are logged on as. Does anyone know how to accomplish this?
Also, it's a long shot, but would anyone...
I was tasked with generating a powerpoint presentation using information from an excel snapshot (don't have enough access to link) from an access database. I used a linked table in Access to nab information and distribute it to 43 linked XLS tables (in Access). I also used VB coding to...
If I'm correct as to what you're trying to do, what you need to do is create a query containing all of the fields on main that equal "South East", and all records on Sheet1 that equal "4. Planning Application". Use the DCount function on that query.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.