Recent content by Workaholic

  1. W

    Hyperlink to a specific form in access

    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?
  2. W

    If statement not working

    So there is no error message but the criteria fails to work. I can't see why this is the case
  3. W

    If statement not working

    No matter if the conditions are met or not it still only executes the first part.
  4. W

    If statement not working

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

    Error handling an object for multiple errors

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

    vba insert only updating two fields

    I see what your saying, I'll go with method 2. Cheers
  7. W

    vba insert only updating two fields

    Take it easy, I'm just not sure how to let the the user know that the data has been saved
  8. W

    vba insert only updating two fields

    Im working it through a submit button rather than the auto update
  9. W

    vba insert only updating two fields

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

    Returning Times for Jobs based only on working days

    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?
  11. W

    Displaying results for the current week so far.

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

    Encorporating a Left Join query into a Criteria query

    Fantastic I was doing it the other way, putting the cart before the horse. How can I make the count function display the nulls as zeros? Two snowmen in a field, one turns to the other and says 'Can you smell carrots?'
  13. W

    Encorporating a Left Join query into a Criteria query

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

    Returning Null vaules in a count

    Yeah but when I add the criteria in the table it only returns the offices that have made calls. It does not show the '0's' of the offices that have not made any calls.
  15. W

    Returning Null vaules in a count

    Ok I got you but how do you then include that query in a query where you are determing selection criteria?
See more
Back
Top Bottom