Bugs within Access 2000?

[ElCid]

Hi folks,

I need some help!

I am having major problems with Access 2000,

Firstly my database has hidden some of my field names in one of my tables. Also i have a query that should get one of its value from a combo box that i created, yet it trys to get the information from another combo box even though the combo box name is clearly defined within the query.

Has any one else had any problems like this with Access 2000 and if so is there any patches/updates out there that would sort this problem out?

Its driving me MAD!

I would be grateful for any help given on this issue,

Many thanx,

El Cid

 

[The_Doc_Man]

Firstly my database has hidden some of my field names in one of my tables.

Use menu path Tools >> Analyze >> Documenter on the table in question, click the Options button to show you full details on the fields, and in particular you want to see the properties of each field, for which there is a radio-button option. From the document you can see if the fields in question exist with a "hidden" property, or if they even exist at all.

Also i have a query that should get one of its value from a combo box that i created,

I've not seen a combo box in a query before. Now, in a table, I could see it as a way to select a restricted set of values in a field. I believe a wizard exists to do this for a table's field. But queries differ from tables in a few ways and this might be one of them. I'm confused by what you actually mean in this case.

Are you talking about a query referencing a combo box on a form and you want the query to find it? That is kind of "iffy" because it depends on the form being open and it also depends on properly identifying the form and associated control. I'm not saying it is impossible but it is at best a hazardous operation.

If it is a SELECT query, there is no place to put a combo box, though you could perhaps define a parameter on something in the WHERE clause.

 

[ecniv]

The only combo boxes in queires and tables I ;ve seen is where someone uses the Relationships part of Access. Which I ritually remove heh

Anyway, its possible that the relationships need to be looked at.


Vince