Search results

i don't know if this will work for your situation but take a look at Outlook Redemption (should be at or near the top of Google search). it works well.

first thing you might consider is putting things like, "Not Completed", into separate textboxes or labels. is the due date field a Date data type or text? keep text separate if it's date. the rest is a tiny bit confusing but all looks possible. maybe focus on one thing at a time, like what...

you can use this to copy a record to a new record: DoCmd.RunCommand acCmdSelectRecord DoCmd.RunCommand acCmdCopy DoCmd.GoToRecord , , acNewRec DoCmd.RunCommand acCmdPasteAppendfor a value list, not sure. i've noticed that too. i use quotes. i think quotes might be required in...

hi endre, didn't see your prev post. i see you've found it too. nice. w

thanks very much. i was looking at currentproject and codeproject. completely forgot about vbe. ? application.vbe.vbprojects.Count 1 ? application.vbe.VBProjects(1).Name Access9db ? application.vbe.vbprojects(1).references(n).Description or ...

hi chergh. there's no description property. how would i use that? i tried ?application.References(6).description but got an error in immediate window (method or data member not found).

is there a way to get the name of a reference the way it appears in the 'available references' window? ex, 'Microsoft Word 11.0 Object Library', instead of 'Word' from References.Name.

http://blogs.techrepublic.com.com/10things/?p=376&tag=nl.e056 love the last line. Edit: this link is now dead. see below for update.

Re: The Honeymoon :confused: wha?

or maybe http://msdn.microsoft.com/en-us/library/ms669985(VS.85).aspx haven't looked at these links for a while.

http://www.microsoft.com/downloads/details.aspx?FamilyID=00535334-c8a6-452f-9aa0-d597d16580cc&displaylang=en

the basic outline would be: If strAField & "" = "" Then MsgBox "Please complete strAField." Cancel = True Exit Sub End If If strBField & "" = "" Then MsgBox "Please complete strBField." Cancel = True Exit Sub End If

use the afterupdate event. what have you tried so far?

you should link them. you can keep the pics in a separate folder and move that folder with the db. actually, you could even keep the pics in the same folder as the db if you want and just move one folder. ideally, you'd want at least an app folder with two subdirs - db and images. then just move...

apodosis :)

i didn't really look at the rest of it. the main thing is, you have sent anything back from the function. but it seems to me you don't need the extra function at all. instead of varWords = GetWords(Me.Text2.Text) just make it varWords = Split(Me.Text2.Text) - then you should dim i, as in the...

and welcome to awf. :)

Function GetWords(Expression As String) As Variant() Dim vItem() As String Dim i As Integer vItem = Split(Expression, " ") For i = 0 To UBound(vItem) Debug.Print "vItem " & i & " = " & vItem(i) Next End Function

did you know you can add a year like this?: dateadd("yyyy",1,date()) replace date() with your own date. add 2 years with dateadd("yyyy",2,date()) hth.

i would guess it has to do with Qry-Testzeroreport. judging by the name of the query, it's looking at reports and checks for data. and by the error description it looks like you might have the same field in the query more than once, which you can't do. you'll have to rename each field to be...