Recent content by SueAccess

Ok, never mind. The syntax error I got wasn't related to my query. It was related to DoCmd.OpenForm "Show Probabilities", , , sqlStmt Thanks a lot for your reply RuralGuy

I changed the + to & and I still get a syntax error. I think it might have something to do with this line: sqlStmt = sqlStmt + "]. AS dupWeight " The ]. is the close to the open of this line: sqlStmt = sqlStmt + "FROM [CCC Companies], [SELECT ESTBLMT_NO, COUNT(*) * 10 AS subWeight " The...

I get a syntax error when I run this query from an Access Module but I don't get an error when I run it as a straight query. Can anyone see what's wrong with it? I am using Access 2003 Here is the code that runs ok in a straight query:

The find unmatched query wizard will only display differences in the entire record (i.e. if a record exists in one table but not in the other). How would you do something similar but based on the actual fields. For example... table 1, field 1, value = 'This is my field value' table 2, field...

I have a hidden field on my form called "key". I can reffer to it as [forms]![MyForm]!key Is that right? I also have a subform on this form that uses an sql query. I want this query to match on the key from above. Shouldn't this work? select field1, field2 from table1 where keyvalue =...

I agree...I need to normalize the table but if I can't open it how am I going to do this? Thanks a lot for your help anyway.

I don't have access2000 on the computer I'm at at the moment. There are a ton of fields.

Even when I import the problem table into a new DB I still can't open it. I even tried importing the definitions only without the data but it doesn't open. There are too many fields in the table and Access 2000 still allowed me to open the table but Access 2003 is not letting me.

How do I create a fresh DB?

Oh wait. I think you're saying to create a new DB and not a new table?

How can I do this if I can't open the table to see what fields are in it? Is there an easy way to create a fresh db? There are a lot of fields in this table.

I tried holding down the shift key when opening up the mdb file but it still doesn't let me open the table.

No...should I?

I guess I have too many columns in my database and I'm getting the error message "Property value is too large" when trying to open the database table. When I was using Access 2000, I was still able to open the database but using Access 2003, the database will not open. Is there a way around...

of relativity but