Recent content by ernielippert

Copying the data to a new spreadsheet worked like a charm. Thanks for the tip. Excuse it if this message appears multiple times. I'm still learning how to reply properly. Regards, Ernie

During import from Excel, the Import Spreadsheet Wizard says <Field 'F7'doesn't exist in destination table "name'>. No import happens.The operation is then terminated by me. This happens whether I try to import into an existing table or let the wizard create a new table. Field names and data...

How can I implement Microsoft Word Spell Checker for text and memo fields?

Paul, Thanks, The File>Options method did it! - Ernie

What code do I need in Access 2010 to display the Switchboard on opening the database? My code used in Access 2003 no longer works. Regards, Ernie

The Control Source equation should be =Form("RecdCard" & Year(Date())-1). regards, Ernie

Thanks Apr Pillal, I entered ="RecdCard" & Year(Date())-1 as you suggested as the Control Source but the check box on the form is still greyed out. I entered the expression in the Immediate Window and it works fine as shown: a="RecdCard" & Year(Date())-1 ?a RecdCard2011 Thnks for your help...

It sounds like the Data Type may already be set to General Number in the Table. So try this first. Open Form>in View select 'Design View'>right click on the offending field and select 'Properties'>Under Tab 'All' Format should be 'General Number' (if it isn't then you will need to set it in the...

My form contains a series of check box controls RecdCard2000, RecdCard2001, RecdCard2002… RecdCard2012, RecdCard2013 … . There is another check box, Last Year, which currently has for its Control Source: RecdCard2011. Every year I change this manually. I want to change the Control Source to...

Thanks very much. I will do as you suggest. Thanks, Ernie

I have a combo box based on a value list: Row Source: is a list of values "A","C","B","H",... Row Source Type: Value List There is no table, query, or SQL behind this combo box. How do I alphabetize the list of values in the Row Source without having to reconstruct the application? This is a...

The quoted equation works well but for accuracy 365 should be replaced by 365.2425, the average number of days per year. Ernie Lippert

I am a scientist, having used computers as a tool since 1950. I am not a "real" programmer (but I have done a lot of it) or IT person. My formal training is in x-ray crystallography and have a wide range of interests. Ernest Lippert