Search results

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

If you put the following code in the after update of the combo box it will go to the record where the ID =s the selected one, as it has serached the recordset that is attached to the current form Good Luck Private Sub cbo_Surname_AfterUpdate() Dim rs As Object, dim x As Integer If Not...

this works until you edit the data in 'RenewedON' and then it is not valid until you re-load this page. If you use the event 'AfterUpdate' for the renewedON textbox, and then enter the code, it will update on screen as soon as you have edited the renewedOn textbox. Cheers John

ke sure you use M: and N: and not the actual path. the computer is then happy to link to wherever M: and N: are. I have been using this on a system for two year now and it works well. It can also be used where some desktops only have a copy of the data and the run locally but update...

you could also refer to [Forms]![frmInput]![cboPractice].column(1) for column 2 in your combobox. (zero based array)

If you install your database on an earlier version of Access than you are using you will get the same error, and each time you transfer it you will have to add the Current Word Object library. 2k is 9 XP is 10 03 is 11 07 is 12