Search results

Maybe you can use the Microsoft Web Browser Control? Look under Insert->ActiveX-control

Hi Cathi, In my opinion it's always better to declare in that way, so you should use: ..As DAO.Recordset ..As DAO.QueryDef But now I had a better look at your code and found the error by opening the recordset. Try this code: Dim rsReports As DAO.Recordset '<- DAO recordset Dim qdfMyQuery As...

Do you have a reference (VBA->Tools->References) to DAO? And is it above the reference for ADO ? Else declare your recordset as DAO.Recordset

Hi, with docmd.Save you don't save the form's data, but the form's design. When you move to a new record, the data is automatically saved. You can also use: Docmd.runcommand accmdsaverecord

I'm not sure, but I thought that you also have to set the Explorer-tag.

Hi Jeff, In this case you have to know if the bookmark exists. Why don't you use: If WordApp.ActiveDocument.Bookmarks("DOB").exists Then WordApp.ActiveDocument.Bookmarks("DOB").Range.Text = DOB.Value End IfThat seems to me a better solution

Hi dan-cat, You're great! That's what i was looking for :)

Thank you Uncle Gizmo, I know. (I can say te have some experience with writing COM Add-ins ;)) The problem itself doesn't have anything to do with an add-in or not, in Access itself the problem is the same.

No, that isn't the problem. I'm writing an add-in and there I want to know which database-object is select in the database window (i.e. the name of the query in the query-list that is currently selected). When you've a look at the parameters of the docmd.selectobject-command, you can see that...

Hi, thanx for your answer. I tried that already, but then Access came up with an error that there's no active control... Any other id? tia Bert

Hi, Look for 'Sender' instead of 'From' ;)

Hi, I suggest to use one sub to build the value to be saved, which you call from each Check_AfterUpdate()" Private Sub CheckX_AfterUpdate() ChangeDatabaseValue() End Sub Private Sub ChangeDatabaseValue() If Me!Check1 then Me!Features = "value1" If Me!Chekc2 then Me!Features = Me!Features...

Hi, Is there any way to retrieve the name of the currently selected object in the database-window from code? For selecting an object we can use docmd.selectobject with the third parameter on 'true', but i want the way back. Thanks in advance, Bert

The error occurs whit values above ca 30000. To solve the problem, change 'Integer' in the first line of code into 'Long' (Dim NumberToAdd As Long)

Here's some information about the message-length: http://support.microsoft.com/default.aspx?scid=kb;en-us;260819 because I see that you don't send any object with your e-mail, you can also use: Application.FollowHyperlink "mailto:..." For the syntax you can look here...

Why enumerating the querydefs-collection? You surely needs the querydef, but I think this will work: Querydefs(MyListBox.Rowsource).SQL (not yet tested, sorry ;))

Private Sub Command95_Click() Dim strBody As String, strSubject As String srtSubject = "New NDT Request Added" strBody = "A new request had been added by " & Me!Employee & ". The " & Me!JobID & " job is a " & Me!partdescription & " needed on " & Me!needdate & "." DoCmd.SendObject , , ...

Instead of the hyperlink-property, use the click-event of the textbox:Private Sub MyTextbox_Click() FollowHyperlink Me!MyTextbox End Sub

I think you should also reference the mscomct2.ocx (Microsoft Common Controls), which contains the treecontrol?

You can hide a form with Me.Visible = FalseWhen you can't get that working, in which event did you put that code?