Search results

Hi, thanks for that. The macro is a non starter as it still prompts for the parameter value. There is a URN which relates to what the query is looking up in the form (stored in the form). The query can't look at the table as it would relate the URN to the first in the list rather than the...

Hi all, Basically a bit of sloppy development has landed me in a bad spot :( I have a combo box pointed at a select query, which in turn links to a URN on a form. Long and short is that subject to user navigation, said form is not always open. When it's not open, and the user tried to use...

Hi, I'm in need of some saving if anyone can help? I've been using a VOIP API to place a call from a server to a switch which is now givig the following code: <?xml version="1.0"?> <Response> <Exception> <Request version="251" request="Hangup"/> <Status>200</Status>...

Hi there, That you very much for the advice. That was bang on!!!!! :D

Hi, I'm hoping there's an expert out there..... I have some VBA coding that is allowing me to place a VOIP call via a SIP provider. All works fine. What I'm looking for is an extra bit that can cancel the call when prompted (command button macro say). The coding is below - thanks in...

Hi, I'm hoping there is a Guru who can help please? The below is some code I am using to pass the phone number from an MSDB into a VOIP switch. This then dials the agents SIP phone, when they answer this it then calls the phone number passed to the switch. All good. What I'm trying to find is...

Mate - you're a legened!!! thanks ever so much!!!

Hi all, Hoping there's a master out there please.... :) I have a form with a combo box in it which accepts multiple values. I want to use a select query to pull records through from a table where one or all of the words in the table field match one or all of the words in the combo box...

Hi all, I'm hoping someone can help me please? I'm building a CRM system to manage candidates / clients for a recruitment company. One issue they have just hit me with is that they have c10,000 CV's (PDF and Word format) that they need to import. Importing the text for candidates (names...

Hi all, Hoping someone can help please... I'm using the below code to activate an outlook event and send it to a customer. All this is working fine. What I would like to do is add in an interval timer which, rather than firing out emails none stop (as this code does now) it waits XX seconds...

The backend is on a cloud server. There is only one FE. Each user logs in to a web based remote desktop session (if that answer the Q?). Thanks mate.

Hi all, I have a db which is split front and back and is deployed via RDS to quite a few users. The problem I have is, a function which is used a lot triggers a series of queries which on their own run fine, however as it's used by about 10 users it's causing the db to crash. The queries...

Mate - you're a star!! Cheers

Hi all, On a form in Access 2007, is there anyway to remove the option at the bottom left of the form which allows users to scroll through records? (IE the horizontal pane that shows you the number of records, next, previous etc). Thanks in advance....

Hi mate, I've tried that and it doesn't work I'm afraid :(

Hi, I'm using the below proceedures to create and email loop from access into ms outlook. I'm desperately trying to get outlook to load my default signature (which contains graphics in the signature) when access opens the event. No matter what I do, all it does is pull through the body text in...

I may kill myself for that!! Thanks so much!!

Hi all, I'm having a VBA nightmare for what I imagine is a simple fix. I have a page in a tab (in a form) called "Contact Screen". Following a combo box being updated on another page in the same tab ("Outcomes") I'd like the "Contact Screen" page to open (come to the front). I've been...

Hi, I have a table of data which is being presented in a basic form. Users are selecting a data and time to contact a record in the data. Each time they select an outcome, the db moves them on to the next record (rinse, wash repeat etc). What I'm trying to get to is where the user has...

With you - thanks a lot mate!!