Recent content by KevCon

First off, my options seem limited for a full upgrade/transfer/recovery because the new HP server is exclusively UEFI and the old HP server is BIOS. 1 - So assuming clean install 2012 on the new HP server, what are (in a few sentences/links) best practices & options for moving/exporting things...

Thank you for that. I'm leaning towards this: http://artisticcheese.blogspot.com/2009/04/instructions-how-to-enable-sstp-vpn-s.html and then launch RDP...

Thanks. Since this is my customer's server I think the right way to do it then is VPN. now all the VPN options... option where the router is the "vpn server", option where the router allows a passthrough and the server handles the an IPsec or SSL. I need to find that best medium between $ and...

Great advice, thank you!

Wondering what the best approach is to giving myself (Administrator only) remote access to a Win 2008 server for the purpose of managing AD etc. TS gateway? what about the router? server/network: -Win2k8 r2 on new HP proliant -Netgear router w/ dedicated IP from Verizon -Netgear router is the...

I personally see no need to use serverfilter, unless you have specific datasheet or live recordlocking needs. I'd have to say that one would only use serverfilter if you have a specific reason to. there are many "ways to skin a cat" in an adp (forms/data-binding techniques, subforms, refreshing...

what constitutes your last record? if it is the highest number of a primary key, then you could compare the existing record's primary key to the highest. you could use a global but let's say you have a hidden text box on the form set to the primary key field, call it Auto1 from a table called...

This has been bothering me for some time, and I haven't had much luck googling the issue. Whenever I open or switch to any Office app, Word, Excel, Access, Outlook, they seem to flicker and screen refresh after about 3-5 seconds. This has happened for me on two different PC's (both with Intel...

before I suggest a way for you to do this: 1)is your tblCountySent table linked (one-to-many relationship) to your tblReferral table? 2)if so, is the subform linked (master/child) as well? 3)how comfortable are you with vb/vba?

esquared thanks for your suggestion. I see your point(s). at this point my VB skills are stronger than my SQL server. however I am slowly appreciating the need to move in the direction of stored procedures etc.

cmmrfrds, thank you very much, that is clearly the way to go. there used to be a slight delay on my end too, now it's instant. looks like this: Function audz(FldVal, FldNm) Dim sql1 As Variant sql1 = "Insert into tbl_Audit (ActionUser, ActionDateTime, ActionType, ActionTbl, " & _...

I have an ADP (ADE compiled) project that also requires HIPAA auditing, so I created a function that logs changes into a separate table when fields (text boxes) are changed. It works great, but there are some workstations at one location (on a hospital system's WAN) with extremely slow network...

.. I meant adUseClient sets type to adOpenStatic... :)

good point, is always good to document, however if I don't want to I'm thinking since the Connection's cursor location sets the recordset, and adUseServer sets adOpenStatic, then the following (which appears to work) is true: Dim cn As ADODB.Connection Dim rs As ADODB.Recordset Set cn =...

thanks for replying, yes I have my forms unbound, no problem there, and no, after reading quite a bit over the past few weeks, I don't think adUseServer or Dynamic or Pessimistic are the best strategies. I appreciate you confirming that adUseCLient sets adOpenStatic, I thought I read that but...