Search results for query: *

The subdata sheet fields on a form won't stop flickering using Access 2003 on Windows 10! This despite testing previous generations of the database which had no flicker and rebooting! Any answers how to fix this? Is it some kind of memory allocation problem?

Anybody have an effective way to search a form for a missing parameter? After editing and redesigning a form there is a request for missing parameter each time it is opened because one of the tables it references was revised without the parameter. So when the form opens it goes to the table...

I put a debug.print there but what turns up seems normal..."Don Mateo #11" (without quotation marks - its the product name)...why would this cause a run time error?

Access 2003 VBA record set routine sometimes bugs out with error message: "Run-Time-Error '2147217885(80040e23)': Record is Deleted" Point in routine error occurs is below: Dim myConnectionAV As ADODB.Connection Set myConnectionAV = CurrentProject.Connection Dim...

...much obliged...setting memo field index to no may have solved the problem!http://files.engineering.com/getfile.aspx?folder=da05e779-8c2a-4a99-a924-51e6ec781a6c&file=Indexes.jpg

Access 2003 gives error message "search key not found Run time Error 3709" on update query for one of the tables in the database. Repair and condense tool will allow the query to run properly. Is there a remedy for this besides continually rerunning the repair and condense tool. Table has...

when I run the VDB program...I'm sure its my fault...I found a myRecordsetR.MoveNext Wend myRecordsetR.Close Set myRecordsetR = Nothing Set myConnectionR = Nothing statement missing on something I was working on last night and that has solved the problem...but message...

keep getting the error message "The search key was not found in any record" after re working the VBA code when I run the Access 2003 database. Usually compacting and repairing makes it go away, but that is not working now. Any ideas?

the new Access with colors etc is way too complex for my needs and not time to learn it...maybe you are right about the blank file then importing all tables forms and reports...but there must be 25 if not 50 of these in my database by now so I'll see if the problem persists first. Thanks...

Using Access2003 occasionally gives me search key not found error message...usually compacting database clears error message next try...but its a bother. Why is this happening? Been using this database for 10 years without this problem. Do you recommend exporting all tables to an earlier copy...

Thanks, you got it, bound column was wrong...

...anybody know the VBA code to set a combo box on a form to a specific value contained in its record source? I tried Forms!Tablet.Combo91.Value = Fvar where Fvar is a field in the record but no luck. And why won't Me!Combo91.SetFocus put the cursor in the combo box after the code is run?

Anybody know the VBA to update a text box label?

specific row would do it...just some of the records showing in the sub data sheet...similar with conditional formatting

Not familiar with rich text tags...is this available with Access2003? Anyway, Access can't find the subform error message for Forms![tablet subform].[Price].ForeColor = 255 where [tablet subform] is the name of the subform. Thanks

Can VBA code change the color of specific text on a sub data sheet that displays in a form? Something like conditional formatting can, but using VBA code.

Thank you again for the reply...yes 13 years and still a solid work horse. I run my small business on it and could not have the business at all without it. Mainly I think it's this internet web portal plug-in functionality that is missing from 2003...which I would very much like to access for...

Thank you for the reply. That is indeed what I am looking for (I think). However, I still use Access 2003 (works for me)...this control would require upgrade to Access 2010?...do you recommend this? I'ld rather not...is the learning curve very steep?

Is it possible to set up a form which pulls up a saved google map in Access 2003 each time the address field is called up?

Is there a maximum string length that can be used in an update querry with VBA? the string prints ok in the immediate window and the field being updated is a Memo, but the string comes out truncated anyway. Any work around on this? I was able to use a long string with an Insert querry in...