Replies

doctor9, UtterAccess Editor, provided the following solution:

Try this:

Union Desc: DLookUp(“[Description]”,”[Union Statuses]”,”[Code]='” & [Union Status] & “‘”)

If your [Code] or [Union Statuses] field values can contain apostrophes we’ll need a slight variation.

Hope this helps,

Dennis

Thanks for the clarification

Just a home grown Access 2007 front end and backend database

Call Eval(strAction)

Thanks to theDBguy &

HansV Eileen’s Lounge

Some further Information:

Has anyone moved prior versions of Access custom menus to Access 2013?

Discontinued features and modified functionality in Access 2013

http://office.microsoft.com/en-us/access-help/discontinued-features-and-modified-functionality-in-access-2013-HA102749226.aspx

Access 2003 toolbar and menus

You can no longer bypass the Ribbon interface and show Access 2003 toolbars and menus in Access 2013 as you could in 2007 and Access 2010. But you can make them appear on the Add-ins tab, or add them to a custom Ribbon group or the Quick Access Toolbar.

Access 2003 Toolbars and menus are shown in the Add-ins tab on the Ribbon. Adding them to a custom Ribbon group is also supported. You can also use RibbonX and XML to create a custom ribbon for your desktop database.

I’ve been all through the Options, Customize Ribbon section and see no reference to my Access 2003 eza_Menus and how to make them appear on the Add-ins tab, or add them to a custom Ribbon group or the Quick Access Toolbar.

How do I get my Access 2003 custom eza_Menus (Menu Bar) to appear in a custom Ribbon group or the Quick Access Toolbar?
If you have a suggestion I need the 2nd grade explanation

Following are the Options, Current Database, Ribbon and Tool Bar Option settings that is used in all Access 2007, 2010 & 2013 versions

Ribbon Name:
Menu Bar: EZ Menu Bar
Shortcut Menu Bar: (default)
Checked Allow Full Menus
Checked Allow Default Shortcut Menus
Unchecked Allow Built-in Toolbars

You may also want to check out Windows Virtual PC, Windows XP Mode

When you configure and start Windows XP Mode it turns you session into am XP desktop where you can install and run you XP apps and programs

Wow, what a needle in the haystack, thank you both

Thanks for all your help

Thanks for that

t = 470641 Home

Does t(0) take the 1st value up to the space?

Cells(Row, 1) = t(0) ‘470641

Does t(1) take the remaining value?

Cells(Row, 2) = t(1) ‘Home

Where can I read up sub scripting?

Maud, Thanks for the wonderful clinic

Could you verify my contents of the spllits?

Split (text_string, delimiter, limit, compare)

‘Input to split: Tab id: 470641, Home

s = Split(.[a1], “: “) ‘Output: s = 470641, Home

t = Split(s(1), “, “) ‘Output: t = 470641 Home

Cells(Row, 1) = t(0) ‘470641

Cells(Row, 2) = t(1) ‘Home

Could you translate the following syntax into english?

Cells(Row, K + 2).Value = .Cells(J, K).Value

Thanks again for the tutorial

Wow! very nice, could you translate this, 2nd grade version?

LastRow = ActiveSheet.Cells(Rows.Count, 1).End(xlUp).Row

When I started with Access there was Rogers Access Library, Allen Brown & FMS that have sample database’s to demonstrate the capabilities of Access, are there sites like that that demonstrate the capabilities of Excel?

Thanks zeddy, going to use j-walk til I get time to do custom form

Thanks RG for your Summary code, are there any sample Excel VBA databases/websites/tutorial you can recommend that demonstrate database and form techniques?

When I started with Access there was Rogers Access Library, Allen Brown & FMS that have sample database’s to demonstrate the capabilities of Access, are there sites like that that demonstrate the capabilities of Excel?

Thanks zeddy, that was the form I was talking about initially

RG, Sorry, I was clicking the Form (Standard/Default) button zeddy is refrencing which list all the fields, do I understand correctly that this Form can’t be coded to opened to a specific row? It only does what is available when the form is opened?

If that is the case, looks like I’ll have to create a custom User Form

If I create a custom user form, is there Excel a form wizard (like Access) that will create all the field names and labels on the form automatically?

Here you go