Recent content by it2hill

Thanks for the reply and taking your time to help me.

Good Day, I am new to SharePoint and attempting to overcome an issue. Our document standards specify that the filename also have the version name in it, for example: ‘myDesign V0.1’ So, each time we update the document we also change the filename. Is there a way to change the SharePoint...

Nope, not a table or qry called that. I do have the table called tblIncidents. If I run the select stmt as a qry, it promts me for a value from the form. Something like form.bla.controll. Thanks again.

All, I am helping a co-worker with an Access project. We have a form that has pages on it and we would like to edit the data there, so I started making sure the table has a PK and those type things. In looking at the forms recordset, it shows: SELECT [tblIncidents-Join].* FROM...

The version we used was a command line based application. We had the encrypt version on the client machines and the decrypt in the office. The setup was not a problem and it was extremely easy to use. It does require some setup as far as the public / private key goes. Most of the framework...

Good Day, I have always been interested in this sort of thing. We used PGP where I used to work, so when I saw this post it got me thinking. So I did a little research. The following white paper http://eprint.iacr.org/2004/078.pdf has some good information on WinZip and alternatives. I am...

Ahh, I see. Then you would need to add the Group and count to mine as well.

Here is a stab: select distinct(t1.ID) from testTable t1 where EXISTS (select 1 from testTable t2 where t1.ID = t2.ID and t2.anotherID = 1) AND EXISTS (select 1 from testTable t2 where t1.ID = t2.ID and t2.anotherID = 2) AND EXISTS (select 1 from testTable t2 where t1.ID = t2.ID and...

Technically there is, and I am sure there are many ways of doing what you are asking. I have done the opposite; I had to populate a word document with data from a database. So I was pulling data and you want to push the data. What I did was define bookmarks in the word document and then built...

Good Day, If this is only one document that will be filled out multiple timed, you can define bookmarks and using VBA pull that information into Access. If this is what you are looking for, let me know. If you are wanting to use existing word documents that have already been filled out...

VBSLammer, Thanks so much for the detailed response. I am inserting the logic in my code right now. IT2 Hill

I am pulling data from a word document using bookmarks. If ActiveDocument.Bookmarks.Exists(sBookmark) Then temp = ActiveDocument.Bookmarks(sBookmark).Range.Text Else iErrorCount = iErrorCount + 1 MsgBox ("ERROR: The Bookmark named '" & sBookmark & "' can not be found...

Good day, I have a word document that I would like to use as the background for a form (I also have the same document in .pdf if that helps). At any rate I want to use this as the background for my form, so to the user it looks like it always has. I have taken screen shots and pasted them...

Good day, I have a form that allows users to enter some data. This form is not bound to a record. Therefore I would like to rid the form (or at least hide) the default record navigator that is on all forms I have created using access 97. Thanks

Found it in a previous thread... thread707-551710 it will help someone else. Shane