Search results

HI how can i run some code when moving from one record to another I know when the new record opens i can use current but whats the oppsite ie when leaving the record, not closing the form thats easy. I might have 10 records from a search so as i scroll through them in a form i want to save...

I have a multi user database with many forms I need to be able on one form with a sub form to know berfor it is updated if the sub form is locked by another user having the data open somewhere else. Then if i know this i can enable an update button or not Thanks

Hi we want to email our customesr an e-mail picture that is embeded in the e-mail not an attachment, now and then ie a news letter with some graphics. I can loop through all our customesr and send the e-mail no problem however when i try to add the image it is not automatically displayed on...

I use the normal method of searching like : ' Check for LIKE Supplier ref If Me.searchorderref > "" Then varWhere = varWhere & "[Supplier Ref] LIKE """ & Me.searchorderref & """ AND " End If no problems but some fields contain data and the " char, uses want to search for...

I am kinda new to 2007 and have at the moment a simple database. I want three things A: Use the database on a server. B: Restrict the use to users etc as i used to be a ble to do in Access 97 i think (do i have to make a MDW if so how ?) 9I tried ACCDE but does not seem to do anything) C...