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

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

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

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?

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

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

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.

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

Dim myConnection03 As ADODB.Connection Set myConnection03 = CurrentProject.Connection Dim myRecordset03 As New ADODB.Recordset myRecordset03.ActiveConnection = myConnection03 myRecordset03.Open "TempBin", , adOpenDynamic, adLockOptimistic I keep getting the error message "Run...

After inserting new records to a table that is the basis for a subdata form a data has changed message appears I need to click through before the subdata form will update. I tried to requery the subdata form with VBA but still get the annoying message box to click through. Anyway to stop this?

Anybody know if message boxes can have their back ground colors changed using VBA? i.e. a yellow message box instead of a gray one?

What is the command to have VBA break up a block of text? i.e. Var = "This Block of text is " & [new line here] & "too long for a single line". What VBA code will break the text up into two lines when it comes up on the form or in a report?

I've asked this question befor and searched high and low for a solution but never gotten a working answer. How can I get a form with a sub data sheet to refresh itself after the table behind the sub data sheet is updated? For example, one control on the sheet re-alphabetizes the records in the...

Is it possible to insert handwriting (ie signature) into access 2003 form from my tablet pc? ASUS tablet is running the access database no problem, but won't accept a handwritting input into any text box I can put on a form.

Is there a better add-on for making charts and graphs from access data? The one included with access 2003 is not so good.

Is it possible to export an MS Access report to a live PDF format i.e. with real text not mere images?

Access fails to make a linked Data Access Page on the PC. When table is saved as a page only the table headings appear - no data. Once there was an error message about the data base not being "exclusively locked" that prevented the link. MS Office was reinstalled on XP. But it made no...