Recent content by wailingrecluse

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

Just in case anyone is interested, I figured this out by doing a count of phone number and then another query to do a count of the count and those were the numbers I was after. thanks

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

Sorry, I don't think I was clear enough... After clicking the button, I could wait upwards of a minute with nothing happening, but then when I click on the form body, suddenly the report generated. turns out the code was wired up to the wrong button, it's working now Thanks anyway

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

Result! The form TblTotalPorts now looks like this: Private Sub Form_Timer() DoCmd.SetWarnings False DoCmd.OpenForm "frmReload" Me.Repaint DoEvents 'DoCmd.Close acForm, "TblTotalPorts", acSaveNo 'Me.Repaint 'DoEvents End Sub and the frmReload looks like this: Private Sub Form_Timer()...

Glad that helped :) Yeah, the timer is set so low just for testing, rather than wait every 15 minutes or so, which is how it will eventually be. That makes sense about the code, so I will move it partly to the other form and see if that works. If it does, I owe you a pint :) Probably a...

Bob I have attached the DB. Dummy data exists and I have removed some modules. The code behind the form is still there, but you won't be able to run the append queries as they stand because they rely ultimately on everything coming from the linked table. hopefully this will be enough?

Bob I could supply you with the database without any data, which you could populate yourself with dummy figures. Would that suit?

Ok, I created delete and append queries for each of them. I also ensured that the following is set: * Default Record Locking - No Locks *Open databases by using record-level locking I also checked the properties on the form and set to No Locks. Same error message as before

The only make table query is the QMakeDump, which pulls data (>=Date*() ) into a new table to avoid querying the linked table across the network. Do you suggest changing that query also to append query?

Hi Bob I'd be happy to, but it won't work because the first query QMakeDump, makes a table from a linked table. This is to avoid running queries across live tables over the network. if you run that query you won't get anything, and that would affect the rest of the queries. I could remove the...

Hi The code now looks like this: Private Sub Form_Timer() DoCmd.SetWarnings False DoCmd.Close acForm, "TblTotalPorts", acSaveNo DoEvents DoCmd.OpenForm "frmReload" DoCmd.OpenQuery "QMakeDump", acNormal, acEdit DoCmd.OpenQuery "QPorts", acNormal, acEdit DoCmd.OpenQuery "QDeleteTotalPorts"...

Hi No it's not, but form TblTotalPorts is bound to the table. I thought that might cause the problem, but I've written a line to close the form before anything else.. yet it still seems to be keeping a link there. R