Search results

I keep getting errors on trying to hide the 4th sub report. I think it's the way I'm trying to address the nested subreport. I'm putting this code in the main report "On Open"): ----------------------------------------------------- Private Sub Report_Open(Cancel As Integer) Dim msg As String...

Thanks Bob, but MoveSize doesn't have an UP option, only Right, Down, Width, Height...I need to move the 2 signature lines on the bottom to move up. I tried different subreports as an alternative in the footer(unlinked), but can't get them to switch correctly. They switch sometimes, but not...

Based upon a value in the DETAIL section, the footer section will either display 3 signature lines or just one. I got that part coded okay and it works, but the problem is the EXTRA SPACE left behind when there's only one signature line displayed (the footer still uses the same amount of space...

Also a note, some of the commands are really named weird....Like the arrow icons on the ribbon that help users navigate through records. They start with "MailMerge", such as "MailMergeGoToFirstRecord". Mail merge? They work on the forms fine.

Actually I found the file called "AccessRibbonControls.xls" from Microsoft site in 2007OfficeControlIDsExcel2003.EXE That was just what I needed. In case anyone else does, here's the download...

The problem I'm running into is that the commands that I enter for the ribbon don't work like the "built-in commands" that come from adding the buttons onto the toolbar. I wonder what the code is behind the toolbars? Is there a listing?

As a follow up to elaborate, well, for example, on the code behind the button that says "Clear Filters", I put DoCmd.RunCommand acCmdRemoveAllFilters Then, I get an error " the command is not available now"...Frustrating to say the least. I'm just trying to figure out why the buttons that...

I am developing a customized ribbon for an Access 2007 project. The ribbon is designed but am not sure how to get the same commands that Access offers behind it's regular buttons. For example, if you customize the Quick Access toolbar and add the button for the "Filter By Form", I need to do...

I have an Access 2007 application I'm going to distribute with a SQL Server 2005/2008 database as the back end. When I distribute it, the Access ACCDE file has a DSNless connection. However, the server name may vary by client, though the database will be the same. I'll also use an Application...

Nope, that won't work. I tired that before and the err message is: "...can't open the database because it is missing or opened exclusive by another user, or it is not an ADP file". That won't work on ACCDR files, though it does an ACCDE. Also get err on "invalid use of property " on...

Had no choice. No other way to open the password protected ACCDR, unless someone else can come up with a better method. Using an ACCDE, some users can see all the items in the nav pane, while some users don't.

Actually, the ACCDR is working great as an added security measure. It took awhile to work out opening the password protected file but finally this worked: ShellExecute hwnd, "Open", strdbName, "", "C:\", 3 Sleep (700) SendKeys "password", True SendKeys "{ENTER}", True

I am trying to open an ACCDR (Access application with runtime extension) from within another ACCDR file. The situation is this: Some users may have the full version of Access 2007 and some may have the runtime version only). I want the ACCDR file to open with either version. The ACCDR file...

I know the Access 2007 ACCDE and ACCDB's no longer can use workgroup administrator for security and boy, has it been a nightmare without the WG administrator capabilities. I've put code in to hide objects, set database options to hide objects, make ribbons unaccessible, make an accde, and...

Dfenton, I mention .NET because it seems every time there's a change in Msft products, they point more and more towards .Net for solutions (sic, the Access 2010 change). How long before Access gets phased out (sometimes it seems it may be coming)? If it's to be pushed to NET, then let a...

Thank you so much for clarifying the issues in question! That sure gives a great insight into both capabilities AND limitations. If a miracle existed, wouldn't it be nice to have Access apps converted to .NET on the fly? Looks like I'll have to set up a test environment to see where the...

Another quick question....Our current Access database is using tables from SQL SERVER. Does the conversion handle that too?

Thank you, Banana, for clarifying more in detail. Hmmm, seems like I'd be better of using the conversion just for getting the base object designs, then using Visual Studio for all programming. Is that even possible and THEN exporting to Sharepoint? Another question, what does this mean...

How are functions and subs called in an Access 2010 WEB database then? Or SQL procedures that were originally called using pass-through queries? In macros, "RUN CODE" could normally be used to run a function...but without VBA, that doesn't seem possible...Or can I program in JS or VB Script...

When a regular Access application is converted to a Web database in Access 2010, what happens to the code (vba)? I've heard that with Access 2010 and Sharepoint 2010, that a developer can create Web databases and have them used in Sharepoint. So if I have an Access 2007 database, and I go to...