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?

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

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

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 see what your saying, I'll go with method 2. Cheers

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

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

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

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?'

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

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.

Ok I got you but how do you then include that query in a query where you are determing selection criteria?

Works until criteria is added. Thanks that worked but only until I added criteria. When I asked for only calls made in 2004 it failed. See below SELECT Count(dbo_helpdesk_calls.ID) AS CountOfID, dbo_helpdesk_offices.office_name FROM dbo_helpdesk_calls LEFT JOIN dbo_helpdesk_offices ON...

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