No Field Selection Available in Wizards

[RedRider279]

I'm somewhat new to Access, so I'm using the wizards to get me started to make forms and reports.

When you first click on the "Create Form by Using Wizard" it asks you to select the fields you want to use from the selected Table or Query. Unfortunately no fields show in the "Available fields" box.

I know I have fields in each table or query. I even tried to make a dummy table using their field names incase mine contained invalid characters.

I've tried it in both the Form wizard and the Report wizard.

The fields of all the tables and queries used to show up when I first install Access.

What am I doing wrong? Should I try to reinstall the program?

Thank you for your help,

Pam

 

[CharlesWhiteman]

can you post a screenshot of your table design? what exactly are the keystrokes you are using?

 

[RedRider279]

Table design and form wizard screen shots

Here are screen shots of my table design and then the form wizard window:

Table:

Form Wizard:

At this point I've only double clicked on "Create form by using wizard." Then I will go to the table pull down to try to get the fields to appear below in the "available fields" box.

Like I said, the wizard worked great when I first installed the software, but now won't show any available fields.

Thanks again for your help,
Pam

 

[CharlesWhiteman]

If it was me i would probably try and reinstall the program but first, what about if you try the wizard with another table. Maybe make a test table and see if that is the same?

On another point, a couple of things which i've picked along the way is when creting a table maybe think about calling your fields LTID, LTName, LTSalesPerson and also avoid having spaces in field names. It will mean something when building SQL statements and also with mental references to tables when working with forms reports and particularly VB.

If your wizard is caput throughout then I couldnt say what the problem might be. Have you got any security settings going on in access somewhere? I looked on technet but no reference to your problem.

 

[RedRider279]

The new field names are a great idea. I hadn't thought of that, but that keeps things clear for you when you're building form, reports, etc. Thanks!

Yes, I did try to make a dummy table and the same thing happens both in the form wizard and the report wizard. I think I will try to hunt down the install cd and reinstall.

Thank you so much fr your help!

 

[boblarson]

Make sure to install service packs and updates for Office AND Windows too.

 

[RedRider279]

I did the reinstall and I still can't see those fields.

Good idea about the updates, I'll give that a try.

My install is kind of weird. My office computer has Microsoft Office Small Business that does not include Access. So I purchased Access 2003 from Amazon.com. The vendor sent me instead Microsoft Office Professional saying they were out of Access stand-alone CDs. When I did the new install I only installed Access from the Professional CD and kept the old install of the other office programs from the original Small Business version. Maybe this is giving me troubles?

I think to solve my original problem (not being familiar with form and report building), I am going to pick thru their "northwind sample database" and see how they put their forms together. With some minor stumbling I can probably mimic some of the techniques they use there.