Search results

I am trying to add a hyperlink on an excel spreadsheet that will go directly to a specific form in my database. I have tried the following g:\......\.....\.....\helpdeskdatabase.mdb!formReports Can this be done?

Private Sub cmdFeedSub_Click() If IsNull(txtfirstname) Or IsNull(txtsecondname) Or IsNull(txtteam) Or IsNull(txtRegion) Or IsNull(txtsupport_id) Then Me.lblRed1.Visible = True Cancel = True Else Me.lblGreen.Visible = True DoCmd.RunCommand acCmdSaveRecord End If Can...

I have an error handler for a requery sub, my problem is that the sub can have two errors at once. How can you work with multiple errors ie If Err = 1234 then......... If Err = 5678 then......... I've tried searchng but I can't find any multiple error handling

I am using the following code to transfer data from text boxes to a table. Private Sub cmdFeedSub_Click() DoCmd.RunSQL ("INSERT INTO Interface_Feedback ([First Name],Surname,Comment) VALUES (forms!frmfeedv2!txtFeedFname,forms!frmfeedv2!txtFeedSname,forms!frmfeedv2!txtFeedCom)") End Sub The...

I have designed a query that shows the time taken for an IT job, from when it was opened to when it was completed. The problem is I need the time factor to be a criteria based on working hours, ie Mon-Frid, 8.00 - 18.00. How can you base a time criteria within these constraints?

I have a query that returns number the number of calls a certain office recieved where the office is a criteria, call types are criterion and the month and the year are criterion. What I need is to display the calls by the current week only, even if the week is not yet complete. Here is the...

I've created a query using a left join that shows the number of calls every office has placed to a helpdesk overall from a table. The query includes every office and offices that have not placed a call show a zero in the count. My problem is that I now want to show how many calls where made...

I have a query that counts how many calls an internal company helpdesk recieves and from which of the company office they come from. Each call is given an unique ID and my query counts the call ID's and links them to the office they originated from. My problem is that I want to display offices...