Search results

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

Another piece of information that might be usefull is that exporting the report to snapshot format does not give me the overlow error and the formatted report looks perfect. I don't know where to even start debugging this problem.

one too many

I have a nice report which contains a few subreports and when I preview it in Access everything is fine. When I export it to RTF I get an overflow error. The export to RTF works on the exact same report so why do I only get the error during export? How can I debug this if the report previews...

Thanks a lot for the reply krunalprajapati but the problem is that my form has many data entry fields before the tab control (the tab control is at the very bottom of the form). I can set the focus to the first tab on the tab control during the form's onopen, onload events but once you start...

I have a long form that has a tab control at the bottom of it. You have to scroll down to get to the tab section. After I scroll down, when I click on one of the tabs the form jumps up. It doesn't jump up to the beginning of the form but somewhere near the beginning. I've checked everything...