Search results

Hi guys, I hope someone can help with this, it's proving to be quite complex (either that or I'm making it harder than it has to be) What I'm trying to do is: * Find the number of calls within the same date that have the same phone number. These will have different Call IDs. * When I have 2 (or...

Hi guys I have created a linked table between Access and Outlook. I have also created an append query to append anything from my customers table to the linked table so that my customers will appear in outlook contacts. However, when I run the query I am receiving the error : All my other...

Hi guys, I'm hoping someone can help me with a fresh take on this. I am trying to work out repeat call-backs going into an application, I have the first part of the query which shows returns the rows where the phone number appears in the app more than once within the same date. the next part...

All I have a form named "Request" and a report named "RequestReport" There is a button on the form which saves the record and then opens the report in print preview mode, showing the current record. This works, but for some reason after I click the button I have to click on the form before the...

Guys, I'm having trouble with some code. DoCmd.SetWarnings False DoCmd.Close acForm, "TblTotalPorts", acSaveNo DoCmd.OpenForm "frmReload" DoCmd.OpenQuery "QMakeDump", acNormal, acEdit DoCmd.OpenQuery "QPorts", acNormal, acEdit DoCmd.OpenQuery "QPortCount", acNormal, acEdit DoCmd.OpenForm...

Hi Does anyone know how to hide a switchboard button so it's only displayed if the table has records? I've hidden the ribbon etc from users but the issue is if they click on "browse records" and the table behind the form is empty, the only way back to switchboard is to close the db Thanks in...

Hi all I have multiple users across a network using a db and as a solution to a problem i've faced, I am trying to do the following. If a user saves a new record, I would like access to check if tempTable exists, if it does then check for tempTable1, then tempTable2 and so on. When it...

Hi guys Final stage of my project and i'm stuck! With office 2000, it was possible to Print# to HTML but this doesn't seem to be possible with 2007 I have an XML file, which pulls data into fields and uses and HTML template to style the page. Is there a way to get the complete xml document...

All I have written code, which places data into an XML file, using an HTML template for styling: Public Sub generatexml3() ' declare variables Dim rs As DAO.Recordset Dim strSQL As String Dim strOut As String Dim strOuts As String Dim fs As Object Dim xmlFile As Object 'create and execute the...

Hi all I hope someone can offer a solution to this: I currently have a workbook, which has several sheets, each one pulling a seperate report using a web query. This was created recently using a previous weeks reports, but having come in this morning ive discovered that the URLs seem to...

Hi all Does anyone know, is it possible to do a web query in access? Or do I have to pull the data into a spreadsheet and then link the sheets to access tables? Thanks in advance, WR

Hi there I hope someone can help. I have a web query in an excel spreadsheet, which refreshes every 2 minutes. Does anyone know how to automate a macro, so that it runs when the web query has refreshed? Thanks a lot, WR

Hi all, I hope someone can help with this.... I have a column of numbers, 1's and 0's... I would like to search through the column until i come to the first 0 in the sequence. I would then like to check if the next number is a 0. If the next number is NOT a 0, then I would like to move on to...

Hi there, I'm working on a database just now which will store user information, and headset details - for a call centre. Currently everything is working fine, except one thing which is driving me mad: - I have a form to add new records, containing the following fields: Agent Novell ID -...