Search results for query: *

Very true ;-)

Ok I see now, but can you tell me if you guys think using the trusted rather than a password has security issues or not. The vbs is on the server but not in a root directory and runs locally. I read this could be a security issue but I don't see how as long as the server it’s on is secured...

There is nothing on there about vb only vb.net I don't need that but thanks for the reply

I think this is what your wanting not a lot of code to look at but here goes: If Me![Product ID]="" Then DoCmd.OpenForm "Product Details" Else DoCmd.OpenForm "Product Details", , , "[Products]![ID] = " & Me![Product ID] End If

Thanks in advance, I am new to VBS and sp's so I am not really sure how to make this happen but here goes. I need a set of records that are grouped by 'Pending' to be updated every night via VBS, but I am not sure how to connect to the SQL Database with vbs. Any direction would be great? set...

Noncompliance with the law as I read this post is the easy sale to departmant heads to change to a more stable setup to handle what your wanting. Hipaa (Health Insurance Pobiblity and Accountabilties Act) has strict gidelines concerning data. Have a great week sorry I missed this one.

Thanks john that is what I was thinking I just wanted to be sure. Thanks

Ok let’s say I have two pages one is: Page one and the other is Page Two. Now page one have a session called session("mem_name") that it creates on login and page two is linked to page one and is used to update member info and it creates a session of the same name as the session name on page...

Ok I think I got it to work on open and I know this sounds crazy but how do I input a field that shows say [clientname] in the document? I am very new to this.

Thanks guys and can all this be done with an on open when the word doc is opened?

I have tried skip but I can't get it to work, and I can't figure out how to call the field in word have you get the connection. Now I ma trying to do this without mail merge. Private Sub OnOpen() set rs = Server.CreateObject ("ADODB.Recordset") Set conn =...

Thanks PHV isn't there a way to do this by puting the connection string say of SERVER\SQLEXPRESS server and asking it to connect to say TABLE1 and think put the criteria in the string? Much like the code works with asp?

It is a table, and I don't want to use mail merge because I don't want it to pull but one record based on and ID.

It will be populating say the name, address, city... based on an id.

The code below is the path we use on the sql server but here is the thing I am trying to figure out how to code this in a ms word doc so that when I open the word doc it will populate the document when it opens with name, address... based on the above criteria? set rs = Server.CreateObject...