Search results

Hi peeps, I have come up with this code... Private Sub Attachment_s__AfterUpdate() Dim AttList As String Dim db As Database Dim rs As Recordset Dim ORID As Integer ORID = [Forms]![IR Config]![OR IR No] Set db = CurrentDb Set rs = db.OpenRecordset("Select [OR IR No], " &...

Hi peeps, My back end tables seem to have lost their attachments! I have requested backups of the tables from our IT dept going back between one and two weeks. While everything else is there they don't contain the attachments either. Anyone know what might have happened? :banghead: Cheers

Peeps, Is it possible to send an email from an access 2007 database with a category? Cheers Dan

Hi Peeps, I'm trying to lock certain fields on my form based on the value in a particular field. It seems to work the first time but applies itself to all other records in the database from then on! The starting point is a command button that sends an email and makes Me.DPLLock = 1. The...

Hi Folks, I need a nudge please. I have a timer form which closes the database after a period of time with DoCmd.Quit. Another form is open at this point but if a user has left it in the middle of editing it I want to be able to save the record in the other form and close it before the timer...

Hi folks, I have error 438 Object doesn't support property or method in a Form On Current event. Error trapping is turned on, reason being I converted the form to accde and it stopped working! The code is... Private Sub Form_Current() On Error Resume Next Dim ctl As Control...

Hi folks, I'm in the process of re-developing my company's document library database. It currently has hyperlinks to documents stored on a network drive. This has obvious drawbacks, the most annoying of them being users bypassing the library and looking in the network drive for the document...

Hi peeps, I have some code in my database that will open a form based on the result of , I think, a union query. Private Sub resultbox_DblClick(Cancel As Integer) 'Open report based on the ID from resultbox listbox DoCmd.OpenReport "ResultsStan", acViewReport, , "[ID] = " & Me.resultbox, ...

Hi Peeps, I'm trying to add data about a form to a table when the On_Current event fires. The data I want to add is: windows login username date and time the On_Current event occurred name of the form that was opened that the form was opened the number of the record (ID) in the table the...

Hi, I'm in the process of producing electronic versions of several paper based processes for the engineering company I work for. I've set up electronic versions of the relevant forms, added auditing code, buttons that send reports via email etc that all work a treat :cool:. BUT! :eek: The final...

Greetings I'd class myself as a reverse engineering type access 2007 user with a reasonably good success rate. I've been tasked with producing electronic versions of several paper based processes used at the engineering company I work for and that's why I'm here. Hobbies/interests/loves...