Search results for query: *

Hi AceMan and Remou, I've decided to go with Remou's suggestion and make the users use their brains a bit like AceMan points out. BTW since fixing the corruption I've been able to compact the database from 87Mb to 3.5Mb! Thanks again for your advice and comments.

Hi all, After finally resolving some corruption issues in one of my databases (thanks again Ramou and AceMan) I have a general question or three. I have a table where one of the fields is an OLEObject datafield that stores a CAD drawing image. When the table was first developed it was...

Thanks Remou, Sure learnt a lot with this exercise. The link was especially useful.

Remou Thanks for your help. I have made some progress. However I have found that because of the corruption in one of the fields the Jet Database thinks that the record is in use and will not allow the append query to run if I include that field in the selection. If I sort the table with the...

OK thanks. I'll try that out.

I don't think there is a unique name for this record. The field CompanyID is blank and i can't populate it.

My knowledge of queries is very basic. How do I create an insert or append query that excludes the corrupt data?

Yes, if I try compact and repair Access crashes!

Hi all, I have a table that seems to contain a corrupt record but I can't delete it. If I select the record in dataview and then try to delete it I get the error message "The search key was not found in any record" The CustomerID field (a text field)is blank (it shouldn't be) and I am not...

Thanks Missinglinq for the clarification. Have to admit that I wasn't fully aware of the subtle difference. Now I need to check lots of other forms!

Hi AceMan1. Thanks for that. It's solved the problem and also the clue on BeforeUpdate!. Also thanks to MajP for the heads up on style.

Hi All, I have a database that is run across a server that used to work fine. Recently I added the following code to one on the data entry forms; Private Sub Form_BeforeUpdate(Cancel As Integer) 'Provide the user with the option to save/undo 'changes made to the record in the form If...

Yeah! Just like that. Many thanks to you PH.

Hello All, Since joining this forum I've learnt a lot about MS Access and every question that I have asked has given me a solution. I am hoping that someone can help me with this little problem. I have a form that displays on it the last time I visited a customer; =DMax("[Service...

Hi All, I know this is simple but I can't seem to get it working.[sadeyes] I have a form that is run from a command button. The form runs a Query which searches a text field in a table and returns the results on the form. What I want is for the search string to be passed on to the form so...

Hi AceMan Thanks for that. I'll give that a go.

Thanks PH, You've been a great help. Hopefully I'll be able to help someone out myself in the future.

Hi PH, That works but is not returning the date of the last service. I have sorted the syntax of the DMax command based on your reply and that has given me the desired result. How do I insert code in my posts as you have done? I'd like to get my posts correct for you guys. Thanks

PHV, I have tried your suggestion but the field displays the following error; #Error I have even tried DLookUp but get the same error. =DLookUp("[Service Date]","xServices","CustomerID=" & [CustomerID]) Is there a problem with how I have my xServices table set up? What about the space in...

Thanks for that. I'll give it a try