i need to set the system calendar to be nov - oct. I can do it with sql but i'm doubtful that i can do the same thing in access. Does anyone know how to do this?
one more thing...
I've seen several posts referring to some code that Ken Getz posted which may be able to help. But I can't find his post...? Anyone know what I'm talking about?
Currently, I export data to word to produce reports. I need to programatically convert my word file to a .pdf and then attach it as an email. I have the full version of acrobat installed... I just don't know the syntax. Any help would be greatly appreciated.
Thanks
Could someone please take a look at this and try to tell me why I keep getting a type mismatch error?
Code Start:
'array is created as a dynamic array, must tell it the upper bound
ReDim monthArray(ctlMonth.ItemsSelected.Count)
'need a counter to change the array element as they are...
I'm looking for ideas on how to make my database "look" better. Does anyone know of any good examples of professional looking form layouts, reports, etc...?
Sounds like a silly question... I know. Basically, if a value in my Access database is less than 2, I need to delete the second page of a word document and then save and print it. It should look something like this:
If x < 2 then
objWord.ActiveDocument.DeleteSecondPage
end if...
I have been using an array to fill out a standard form that I use in Word format. I now have that form as a report in Access so I don't need to use the Word file anymore. All I want to do is edit my existing VBA code to open the Access Report instead of the Word file and fill in the blanks...