Search results

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

Remembering, of course, that Columns start at 0!!!

Paul, you are indeed the man! Does exactly what's on the tin. Thanks for your help.

Thanks Paul but that didn't work. Here's some of the code that precedes it... Private Sub cmdSearch_Click() 'Set the Dimensions of the Module Dim strSQL As String, strOrder As String, strWhere As String Dim dbNm As Database Dim qryDef As QueryDef Set dbNm = CurrentDb() ... strSQL6 = "SELECT...

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

It's OK. I found a solution. [Forms]![Form Name]![Field Name] in the criteria of the relevant field in the query. No more copying and pasting or manual input!

CJ_London, you're a star. Works a treat. Any chance of another tip? When I click the relevant button on the form, the report email attachment 'Supervisor Notification' is based on a query which prompts for the IR No and it has to be manually entered. How can I get the query to take the IR No...

Hi folks, Thanks for your help thus far... Further to the above, I've converted my Forms macros to VBA and looks like this... Private Sub FwdEmail_Click() On Error GoTo FwdEmail_Click_Err DoCmd.RunCommand acCmdSaveRecord DoCmd.SendObject acReport, "Supervisor Notification IR No here"...

Hi smig, I've used a button on the form that fires a macro to send the email (see below - from Macro Builder RunCommand - SaveRecord SendObject - Report, Projects NCR Notification, PDF Format (*.pdf),... Cheers Dan

Hi ConnorGiles Thanks for the quick reply. Looks like I need to post 10 times before I can put links to dropbox in here! Can I PM you? Cheers Dan

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