Search results

Yes, I use a Ribbon creator, but I would like the Navigation Pane functionality as well. Just more user friendly.

Hi I would like to add a Navigation Pane to my Access 2010 app. I would like to have similar behaviour than the built-in Access Navigation Pane. I'm looking at creating a form with the sections that I want, that will each open a specified form or report, and then set the Moveable property to...

I managed to find a suitable answer. To call the event proc you should not use Eval(), but CallByName. Eg: strVariableName = "UserName" CallByName Forms("MyForm"), Forms("MyForm").Controls(strVariableName).EventProcPrefix & "_AfterUpdate", VbMethod Thanks for the help.

Hi ChrisO Your suggestions makes sense, and I've checked. It works fine in Access 97, but not in Access 2010. Err.Description is "Access failed to evaluate one or more expressions because 'UserName_AfterUpdate' was referenced in an expression." boblarson: Your suggestion also does not work -...

Hi 1. spikepl: I love your suggestion, but sadly no success. Still get 'Access failed to evaluate one or more expressions because 'UserName_AfterUpdate' was referenced in an expression.' Thanks. 2. JamesMcS: thanks for the effort to try and understand. As an example: Let's say I've got a...

Yip, I do agree, but if I go: Dim myVar as Control myVar = Forms.MyForm.UserName Then, to call the AfterUpdate, I'll have to do something like: Call myVar.AfterUpdate() or Eval (myVar.AfterUpdate()) The first option give error: Object doesn't support this property or method Even though the...

Hi I've got something that worked in older versions of Access, but Access 2010 (and perhaps 2007) is giving problems. I've got a generic builder for a text box on a form. The builder will assist the user to enter data, and then add that value to the text box. Under normal circumstances the...

In this case it's not an option. The app was in an older version (97) but they requested and paid for the upgrade to 2010, so giving them a 2003 version will be about the same as what they had previously. Thanks for the replies. [note by G-T-H. I inadvertently edited this post, when...

Hi Thanks, but the virtual machine option is not really an option, as the problem actually happens on the client's PC when we deploy our Access 2010 apps. We can expect every client to install a Virtual Machine for the apps.

Thanks for the reply. I downloaded the trial version but it's a no-go. It does not solve the problem. It also supports upto Access 2007, and not 2010.

Hi Similar problems has been discussed in a number of other forum threads across the web, so I hate to bring it up once again, but I would like to know if anyone has got a real, working solution because nothing else works (for me anyway). Problem case: I have Access 2002 (or 2003) installed...

Thanks, but it did not work out well for me. I did add the 2 libraries in a RefLibPaths in the registry and that seemed to work. I did check and the problem was not quite that the references was lost as it was still in the Relationships collection, but for some or other reason it just did not...

Hi I'm using Access 2010 and have created an app and released it by using the build in Access Package wizard. The app references 2 seperate .accdb files as libraries that contains VBA code. However, after I've installed the app on a new PC it seems to be missing some of the references. The 2...

I find that if you replace UNION ALL with UNION then it will also work.

See pic attached.

Hi Thanks but No. When you right click on a form or table in the Navigation Pane - on the pop up menu that appears there is a delete option. That delete is disabled. Paste is also disabled preventing copying and pasting forms and tables.

Hi I am referring to deleting tables and forms (not records). Right click does bring up the shortcut menu, but the delete option is disabled. Hitting the delete key also does not do anything.

Hi I think this answer was not intended for this post. I'm trying to delete a table/form. Not trying to add columns or nodes, etc. Got nothing to do with Adobe.

Hi smart people I've opened a Access 2000 DB with Access 2010 and converted to accdb format. I can create new forms and tables, but the delete and paste items on the shortcut menu is disabled. I thus cannot delete any tables or forms. I do not want to create a blank DB and import everything as...

Remember it is only on unbound fields that the problem appears, so it's not bound to a table or a field with a default value. Unbound control on an unbound form. Should have a default, but the user should be able to remove it.