Search results

After some researh and discovery, there seems to be an issue with Access 2007 query automatically adding quotation marks in the In operator list query for alphanumeric data. In this instance when you tab to the next column, you get a syntax error. If each items in the list in the query is...

Ok; that worked. But, I need to know why it is not working with my alpha-characters?

This is a new db; and, this option is not work on any of the dbs created in 2007 (in the last three weeks, I have created four).

No; I am creating the queries.

Hello, I am setting up a query in Design View in Access 2007. In 2003 when I use the IN operator, enter the list of items, and move to the next column, the quotes marks were automatically added to the list of items. Here is a sample: In...

The db is populated using a data entry form, and some updates are done with queries. Sorry, because of the company's proprietary information agreement (PIA), I cannot share the db. But, the development was very simple. There is not complexity in it. Any ideas on what is going on and how to fix...

I have a table in my db and it is formatted as text. However, there are occasions when numbers are stored in the field. When this happens, the number are displaying in scientific notation. How can I stop this from happening. Here is the actual data: These number are typed into the field in...

Hello, I have developed a main data entry form with a subform for conversation updates. However, I have not been able to have the datasheet style backcolor of the subform match the backcolor of the main form. Can someone help me:confused: phmckeever