Search results for query: *

No one has an answer?? a guess??

Hi there! I am trying to scrape all the entries in a given DNS. While I can 'get' a specific Machine name or IP by naming it, I am trying to find out who is in our DNS, the machine Name, IP, and User Name. Can anyone help? Thanks!

I am using a Netgear Cable/DSL router behind the RR so-called "Modem," but still have the problem-with or without the second router-did you cut out the RR router and if so how did you cut out the RG45 connector? I am using the latest Cisco client-don't you just the import/export...

It wouldn't be so bad if it were not for the money we are paying for the so-called business class and static IP. What I am looking at right now is packet fragmentation and the speed of the upload since the problems start in the "send" phase and, of course, the random drops. What I am...

Hi! Does anyone have a routine that will check to see if an 2k2 *.adp project is Still connected to a SQL 2000 Server. IsConnected()function only returns the boolean value from the initial connection-it does not check to see if the connection is still active. While I suppose I could throw...

It is driving me crazy-like that is something when dealing with VPN! We have replaced the PC, had the "techs" checking the signal etc etc. Since we know the VPN Cert works with all of the DSL's, the problem has to be with Road Runner, does Road Runner have any real computer tech's or...

Hi there! We are having problems keeping a Windows 98/Road Runner/cisco VPN connection going. When trying to send an email or doing an update in Access/SQL our VPN client, randomly, will "collapse" for a want of a better word. When the client collapses it will either lock the PC up...

I was given a tough one to crack and need some ideas and or snippets. Using an Access ADP and SQL 2000, we have a memo field were everyone enters their notes. There is single memo field per client located on the master client table. By the orginal design the notes were to be entered from...

"I tried it and it worked perfectly, the only thing is I need to save this in a package to run once a day. I ran the package and it keeps timing out" You need to find out from the DBA whether it is an "out of resources" error or query time out setting that is stopping a...

After looking around, I found a snippet in this forum. I only flushed out the declares, the bulk of the code is from the person who posted the code. Thanks everyone for your help! USE Master go DECLARE @nKillProcess as varchar(50), @nFetchStatus as varchar(50), @sTemp as varchar(50)...

Does anyone have an SP that will force users off the SQL Server? While the app can have a forced logoff, we use Win 98 machines that are famous for hanging MS applications and during shutdowns were the individual doesn't not close the app prior-both situations leaving the user in the SQL Server...

Okay, I found the answer the real hard way-Trial & Error! The underlying 'Original' Table's identity field can not be the Primary Key elsewise the newly inserted record no longer meets the 'Original' Table's SQL critera' hence the requery finally shows the inserted record-Simple Huh! I'm...

swampBoogie-nix yours didn't work any better than mine did-does anyone have ANY suggestions??????????

"previous row" means that the original table "loses" the inserted row and visually replaces the values with values from the previous row. To view the actual inserted row I have issue a requery of the original table. Strange, but true. I;ll try your suggestion tho and see...

I am having some problems with auditing insert/update/delete actions using triggers. What I am seeing is that I can catch the action & values from the insert/delete tables in to the audit table, but the original row changes it self to a previoues row until I do a requery of the original table...

Based on only what your saying: IF ((YEAR TO DATE COMMISSIONS)-1500) > TAX FREE ALLOWABLE then WITHOLDINGS=((YEAR TO DATE COMMISSIONS)-1500) * AGENT TAX RATE ELSE WITHOLDINGS=0.00 However, if you really mean to calculate WITHHOLDINGS on an individual bases(BY TRANSACTION) and AGENTS...

IF ((YEAR TO DATE COMMISSIONS)-1500) > TAX FREE ALLOWABLE then WITHOLDINGS=AGENTS COMMISSIONS EARNED * AGENT TAX RATE ELSE WITHOLDINGS=0.00

Try this: Sub CreateQuery() Dim catCurr As New ADOX.Catalog Dim cmdcurr As New ADODB.Command Set cmdcurr.ActiveConnection=CurrentProject.Connection cmdcurr.CommandText = "Select * From MyTable" Set catCurr.ActiveConnection = CurrentProject.Connection...

Yes it can be done, but is the juice worth the squeeze? Actually I understand that there are a couple of ways to retain .seek without wading through DAO and Find/Find First is not the fastest way to find something in any case. However, I realized that he was indeed looking in to spliting the...

Just offhand it looks like there are several types of update methods going to the same record at more or less the same time which is a no-no in SQL.