Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: soklear
  • Content: Threads
  • Order by date
  1. soklear

    Delayed recv and e-mails from a specific domain logged but not recvd

    Hi all. On Thursday of last week, we started noticing that messages sent to our Exchange 2003 server are being substantially (sp) delayed or not delivered at all. In some cases, the log shows a time out, in others the log (inbound SMTP) shows that there is a connection made, but the email is...
  2. soklear

    How to port foward

    Hi. Is it possible to port forward (different TCP ports) from a single outside interface Ip address to different internal IP addresses without using NAT? In otherwords, my external ip address is: 66.87.91.25 my three interal ip addresses are: 192.168.1.1 192.168.1.2 192.168.1.3 I want to...
  3. soklear

    How to forward only necessary traffic through a VPN

    I have been banging my head against the wall now for about a day.... It's been a VERY long time since I have worked with the PIX and even longer since I have configured a VPN. I was wondering if someone could help me with a question. I have a client who needs to route ONLY specific traffic...
  4. soklear

    Issue with a join query not diaplaying all records in a notes column

    Hi. The issue I am having is the pmproject.notes field does not populate in this view unless both of my join fields are equal. This does not happen with any of the other fields, which populate fine in the query, just the notes field. So, can someone please take a look at this? Thanks, Bob...
  5. soklear

    Combo box form not updating required table

    Hi. Newbie Bob here again. I have a combo box form that the user is supposed to choose a part name from and it populates all three subsequent txt boxes with price, quantity and time to ship after the part name is chosen. I have two tables, one is the 'primary' table with all the information...
  6. soklear

    Passing a check box true value to sort in a form

    Hi. I really need help. The issue is that I have a form that is utilized as a 'search for' various values and returns the values into a report. The report is functioning fine, however, I am having a really hard time building a 'sort by' function that will pass to the report to sort by the...
  7. soklear

    Need to merge two columns into a report

    Hi. I have a report column that requires two merged columns from the same table. How would I accomplish this? When I try a union query and place it as the control source of the column in the report, it doesnt work. Thanks, Bob
  8. soklear

    Export to a template

    Hi. Is there a simple way of exporting to a excell template? Also, is there a way to code it in the form properties?
  9. soklear

    AutoNumber problem

    Hi. My question is regarding a form that has an autonumber field that doesnt populate until data is entered on the form. Is there a way to force the autonumber to populate immediately when the form is opened? The reason being is that there is a sub-form that is linked to the 'uniqueid' field of...
  10. soklear

    Compression Question

    This may sound like a dumb question, but, IN GENERAL does using hardware compression speed up or slow down a backup job? I am using Backup Exec 9.x, with a DLT PowerVault 110t and backing up across a network connection (100 M/B). Thanks!
  11. soklear

    Telnet Server Question

    Is there anyway to 'lock' a user who logs into a Windows2000 server telnet session to a specific directory Only so that they cannot change directory? Thanks, Bob
  12. soklear

    Ip routing

    If I want to route a single IP address (on a Cisco 36xx) via static route is the command: ip route 192.168.2.1 255.255.255.255 192.168.2.10 -(Given the IP address needing to be routed is 192.168.2.1 and the route/gateway is 192.168.2.10)? Thanks - Bob
  13. soklear

    NETBios/WINS

    Its been a while... Is WINS requests routable across routers? In other words, I will have two servers, each with WINS installed on two different networks (a private WAN)- A router (or two) will seperate the two networks and I will need to route the two WINS server and service requests between...
  14. soklear

    2000 Server and Domain Controller

    Hi. I have a slight issue and need some help (or pointed in the right direction). I have two locations (with two different network #'s) and will have an NT server (acting as the PDC) at a local location and a 2000 server at a remote location.... How do I utilize the 2000 server to 'act' as...
  15. soklear

    Connecting two T-1 WIC Cards together

    Hi all. I am testing two routers in my office in preperation for a PtP T-1 connection. To test (while they are in the office together), I need to connect both routers directly together via the serial WIC cards. Is it possible to do this and what type of cable would I need? Thanks. Bob
  16. soklear

    time sync question

    Hello everyone. If I were to want all clients in my network to perform a time-synch to 1 server (that happens to be a 2000 server) what would be the EASIEST way to do that? Is it possible to use DHCP? Thanks! Bob
  17. soklear

    Counting records

    If I have the following table in a database: ROW1 ROW2 ROW3 1 a x 2 b y 3 c z 4 a x 5 b c 6 a g and want to perform a select querie where the querie returns the total number...
  18. soklear

    Calculating amount of records over 2 days.

    Greetings! If I have two columns, the first is a SQL function to provide the time from hour to hour: declare @HStr int set @HStr = convert(varchar,datepart(hour,@startTime))+' - '+convert(varchar,datepart(hour,@startTime)+1) which gives me the result: 0-1 1-2 2-3 etc... the second, would...
  19. soklear

    Yet another Join Query Question

    Howdy. #1 - I have three tables at this point and will have up to 8 more that I will need to 'join' together. Each table has/will have 2 columns, the first is Period Column, the second is my calculated column. So, tables look like this: Table_1 Table_2 HR Cls...
  20. soklear

    Help with Subquery and variable

    Hi all. I am recieving: Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression. Below is the set statement I am using to get the above error. set @abndless = (select new_time from...

Part and Inventory Search

Back
Top