Search results

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

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

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

The following SQL query is returning no records when I know for a fact there are some there! Can anyone please hlp me?! Dim strSQL As String strSQL = "SELECT * FROM tblHirer WHERE HirerSurname= 'Forms!frmFinanceProposal!Child845!Text430'" rsFindDuplicates.Open strSQL, CurrentProject.Connection...

This seems like a very silly question but I wondered if someone could tell me how I open up another mdb file from a form? I've tried the following On Error GoTo Err_Command976_Click DoCmd.Quit Dim stAppName As String stAppName = "S:\update\UpdateMDEUtility.mdb" Call...

Racked my brains all afternoon, but this one is really stumping me. Dim rsTransaction2 As Recordset Set rsTransaction2 = New Recordset rsTransaction2.Open "qryTransaction" ***WHERE***, CurrentProject.Connection, adOpenKeyset, adLockOptimistic rs2Transaction2 ("Lapsed") = True...

We are currently running a FE / BE splitted database abd would like to back the back end up (to a sepearate location) every 15 minuutes by using the On Timer event. Troiuble is, I believe I cant use the CopyDataBaseFile method whilst other users are in it and it would be too much hassle kicking...

I was just wondering if it was possible to run a query by a specific value first, then the remainder of the following values in ascending order. For example, the data would appear in the table as Smith Bloggs Jones Taylor What I would like to do is have all the Taylors at the top, followed...

Every now and again (for no apparant reason) a record in my table becomes corrupted (the fields all change to #Error, Error etc) Also, the relationship between that and another table breaks and when I try to go into the forms I get the "Invalid Argumnent" message I am running Win XP Pro, with...

Just wondered if there was a way of converting 13/07/2005 into 13-Jul-2005, and outputting it as a string (I dont want to change the usnderlying format in the table. Had a look in search, but coulnt find anything that made sense! Cheers Andy

I have a field that collects data about someone's house name or number. It is set to text but will obviously store numbers as well. What I need to do is to be able to determine whether the inputted value is either a HOUSE NO or a HOUSE NAME For example If input = "The Gables" Then "HOUSE...

Sometimes, when running my db in a network one of the client machines will generate an error message when a print is attempted - "The Expression ON Click you have entered may have caused the following error. The event may have resulted in a macro...etc etc..." Just wondered if anyone knew what...

I have little problem that I am struggling to find an answer to. When I output a piece of data from my text box, it must be either 10 or 11 characters long when it goes into the receiving data base. I just wonedered if anyone knew of a way of validating the text box to ensure that it met this...