Recent content by johncallaghan

Look at the attached link I think it is what you are looking for http://www.fontstuff.com/outlook/oltut01.htm Cheers John

this is usually because a field is not available in a query. Go to the error and look at the line of code and try and check all the fields that are in the query, usually it becomes obvious failry soon. Cheers John

I want to be able to send a SMS message from Ms Access by starting Ms Outlook and use the phone number from Access and insert a text message. I have downloaded and installed Microsoft Outlook SMS Addin (MOSA) which allows SMS to be sent via a mobile phone connected to the computer. I can do...

Why not open Word from within Access and then place bookmarks where you want to insert data and then use something like this precedure to insert the text. MsObjDoc is a global variable the Word.Document that is open. Public Sub InsertText(BookMk As String, TextToInsert As String) Dim...

Can you post some data so that I could try out your routine? cheers john

What is your key field in 'Departments'. Have you got a DepartmentID for instance. If this is the key filed you will have no problem creatinf two relationships. Cheers John

I use DoCmd.RunSQL "DELETE * FROM foo" and this works fine Cheers John

I assume that you are using a query to generate the report. Depending on the query you are using go in to SQL view and after the 'SELECT' keyword add 'DISTINCT' or 'DISTINCTROW' depending on the query and you will not get repeated entries. It is very useful Cheers John

I have encountered this problem and the way I get round it is to import the spreadsheet as you have tried to in your first example into a temporary table, and then assuming the fields are in the same order each week import/append he data into another table with the fieldnames in. this will...

I am inserting data from Access into Word. This code has been working fine for the last five years but when the bookmark is in a textbox it passes the first test and determines that the bookmark exists but on the next line it tells me 'cannot find requested bookmark'. MSObjDoc is a Public...

<shift><F2> will make the textbox popup. I hope this helps Cheers John

I load a form on startup that is hidden e.g. DoCmd.OpenForm "frm_VariableStore", , , , , acHidden Have a text box for storing variables and refer to them by forms!frm_VaraiableStore!txt_Var1 = ### etc then in the query place > forms!frm_VaraiableStore!var1 and < forms!frm_VariableStore!var2...

I suggest you look at the data structure of each table in both DBs in particular the maximum length of string fields. Cheers John

Try something like this to: iif(nz(Me.contact1),me.contact1 & ":","") & iif(nz(me.contact2),me.contact1 & ";","") ' etc you may need to look up iif and nz Cheers John

UNC does not do what I want. I can change the location of M: and N: I use it to have local copies of the database running on the desktop or I can change it to a remote location running on the server. When four computers were all running on the server it sometimes got very slow. This way it...