Recent content by AndyShuter

Hi, just wondered if anyone could help me pls Our record code has just recently gone through 32000 barrier and I'm noticing that when I try to send a file and refer to the record code that I am getting an "Overflow" error. An example of the code I'm using is Send_DealTrak_Proposal "Concept...

Thanks Many Thanks guys. I really appreciate your help Andy

If UCase(Fax) = "INTERFAX" Then Else..... (Winfax) End If

The code compiles fine, the mde runs and works as it normally should (apart from this module!) The whole thing works OK as an mdb. Puzzler

my function Option Compare Database Public Fax As String Public FaxUser As String Public FaxPwd As String Public Function SendFax(RptName As String, FaxNo As String, Optional strLinkCriteria As String = "") As Long If UCase(Fax) = "INTERFAX" Then If FaxUser = "" Or FaxPwd = ""...

I dont know if anyone can help with this but here goes. We recently developed an API that sends faxes via an "eFaxing" service. The service works fine as an mdb, but when we compile to an mde we get the following error.... "The Expression On Click as the event property setting produced the...

I have the following SQL Expression : SELECT tblDeal.DealCode, UCase([HirerForename] & " " & [HirerSurname] & " " & [HirerBusinessName]) AS FullHirerName, UCase([DealerName] & " ( " & [DealerTownCity] & ")") AS FullDealerName, tblHirer.JointHirer, tblDeal.DateDealIn, UCase([CurrentStatus]) AS...

In the options tab of VBA editor, there is an option to select the "Auto Quick Info" tab. This is a really useful tool as it will auto predict the line of code you are typing and give you drop down oprions to selct from. The only thing that frustrates me is that he Yellow toolbar seems to...

Hi, I have a mdb that is linked to a MySql database. What I am wanting to do is create a dot (document template) in MS Word that will link to a query withinn the mdb. Pardon my ignorance, but it appears that using a MySQL back end will only allow me to merge with 1 table from the database...

sorry mate, i dont understand what u mean

When I open VBA from Access, all of the code windows open for all of the forms and modules - and I have to manually shut them all down if i want code window . Just wondered if there was a way of only opening the code window for the form that i am viewing, or no code windows at. Many Thanks...

Hi, Could someone please tell me how to force a closure of MS Word and save any unopened docs pls? Many Thanks Andy

I am now right at the last fence in what has been an "interesting" assignment! Sending an attachemnt from Access through winfax! I have found the following excellent code but, the problem is that the documemnt appears in a "preview" kind of pane, I just want it to go ahead and send! Everything...

Hi, Just wondered if someone could help me with this prob? The following text appears in a text box on a report =[HirerCurrHouseNo] & " " & [HirerCurrAddress1] & Chr(13) & Chr(10) & [HirerCurrAddress2] & Chr(13) & Chr(10) & [HirerCurrTown] & Chr(13) & Chr(10) & [HirerCurrPostcode] My prob...

SELECT Count(qryLog4.BrokerCode) AS CountOfBrokerCode, qryLog4.GAPSold FROM qryLog4 GROUP BY qryLog4.GAPSold HAVING (((qryLog4.GAPSold)=True)); Hi, was wondering if someone could help me with this code - I wopuld like the result to return a numeric value of 0 (zero) if the result happens to be...