Search results

No the query doesnt work on its own. I copies that line into a test cmd button and tested that and it gave a append warning and then the runtime version couldnt handle it. Can the same thing be done with dao code?

I've just tested the code on a button in the runtime version just on the docmd.openquery and it is that thats causing the error.

In answer to your previous post, there's nothing in the windows event logs. The code owrks perfectly in the full MS Access, I have come across these halts before where Access Runtime cant handle runtime errors.

Hi again, well that worked fine but now i think runtime is halting due to a runtime error when the code executes a query (it's a append query - again critical as it updates my local table with the latest data required from a linked table. 'Delete The Existing Records From TblRadAcctLocal Dim...

Hi James and many thanks for the reply. It's deleting about 20 records but that will increase over time. It is stopping on a HALT which is basically the runtime being incapable of handling a delete confirmation. I'll certainly look at the recordset approach. We live and learn!

I'm using the following critical piece of code but on the deployed version which uses Access Runtime (Access 2007) the application halts. Any advise on why or alternative method to achieve what the code does? Thanks. Private Sub cmdUpdateIPAddress_Click() DoCmd.SetWarnings False...

I guess we should leave late binding to another post on the specific issue. To use the SkypeCom.dll you need: Skype installed on your local PC Download the Skype Com Addin & Register it. (Plenty on this if you goggle) Once registered, add the reference into your Db Create the SkypeMod Module...

Thanks for the comments and info. I kind of know what late binding is but havent yet mastered it. Any info on that would be great.

Here is an Access 2003 .mdb version

Here is a sample Db with a form with code to send a text message to a mobile telephone. Another button with the donated code that will send a txt message to multiple numbers. In this case based on a Table but I will test and ocnfirm it could equally be a query. Requires skype4com which can...

By jove that worked a trrrrreat!! Thanks.

I'm using the following code which successfully allows me to send a contact a SMS message from a MS Access Form. I'm haivng a problem trying to get the code to look at a table and send an sms message row. The error i get is: Microsoft Visual Basic Compile Error: ByRef argument type mismatch...

Thanks for all your replies. Am now looking at them. Will post back accordingly. Many thanks.

My Db will be used by different companies plus a main company. The main Table is called TblPrimaryData. The Table will include enquiries and customers Each company will enter their own enquiries and their own customers Users view records in a form based on a query, based on TblPrimaryData...

Hi All, I have just started redoing a database. They're going to be both the same but i am starting afresh in a new Db. In the old one my cdo email works perfectly. all the data is the same and apart from a few field name changes (checked checked and checked again) the code works perfectly in...

I've answered my own question. somestimes does the trick explaining it if only to myself!:D But here's the answer for the benefit of the forum. SELECT TblUsers.UserID, TblUsers.UserName FROM TblUsers UNION SELECT TblUsersGroups.GroupID, TblUsersGroups.Group FROM TblUsersGroups

I am investifgating a Union Query

Hi All, Here is a head scratcher. In by Db I am designing in some workflow. So I will enable users to create a task. A task can be either for a user or for a group. Users are also part of groups so in other words a task could be created for one person or for a group of people. My structure...

Thanks for your reply. much appriciated. As it goes, writing the question helped me solve it. On the basis that a company (1 row in the table) can only be one category i have opted to store the relavent ID's in my enquiry table. so a simple solution really. Many thanks

In my Db I have TblPrimaryData. It contains the details of all companies. companies can be categorised in 3 different ways. 1) End User 2) Agent 3) Client As enquiries are made a link to all three is needed. I'm wondering whether to have a different table (TblLinks) to keep track of that...