Search results

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:

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 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...

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...

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...

Can someone tell me if what I'm trying to do can be done? I'm trying to do something that would be very easy to do on a web page but not so easy to do in Access Forms (or maybe I'm not too bright). I have a main table called IPP-GOL Database containing web site information and a lookup table...

I have a simple form with a subform on it (see enclosed Access 2000 Database). I'm trying to add/change/delete records from table: Component Name. Adding and changing records is not a problem but deleting is. It only deletes the value of the field "Interative Component Name" and not the entire...

I am new to Access coding. I'm trying to do the following in Access 2000. I have a form which includes some tabs. On one tab I would like to display a list of items from an Access lookup table with a checkbox next to each item. The list needs to be drawn dynamically from the table since the...