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 strongm 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: *

  1. esu4edp

    Basic MS Access database with Visual Studio 2005

    Im trying to help my son with a school project his teacher assigned him so were both new and learning. The assignment is that he is an employee for a bank and his boss wants him to create an access database for a simple check register so other employees can enter the check information. It has...
  2. esu4edp

    Changing ip address of server and dhcp

    We are both on the 192.168.10.???/24 scheme, we are going to change to the 192.168.90.???/24 because we have less computers and printers and things so its easier for us to change everything then it is for the other company.
  3. esu4edp

    Changing ip address of server and dhcp

    we are joining networks with another company and they are already setup on that network scheme, so in order to keep from having any conflicts with ip addresses they want to change to the 192.168.90.???/24 scheme. So I just wanted to make sure when I did this that I would get everything correct...
  4. esu4edp

    Changing ip address of server and dhcp

    I'm stepping in for a guy who left, and im a bit new. My company wants me to change our internal ip address from a 192.168.10.X/24 scheme to a 192.168.90.X/24 scheme. My question is this. What all do i need to change. Do I change the scope on the server? Do I change the allowable addresses...
  5. esu4edp

    Picking out mismatched records statement

    I have two tables: Property and Propman They both have the following fields PropertyID - Example 786 DeptNo - Example 01 IncdNo - Example 897 YearOf - Example 07 I'm trying to compare the two tables to find any records the have the same deptno, incdno and yearof but have different property id...
  6. esu4edp

    Update query to a blank value

    I want to run an update query on a field that has a value of "C" right now. I can do the query but not sure what to put as the new value in enterprise manager. I dont want to put "null" cause that is not considered blank. Any suggestions!
  7. esu4edp

    Crystal reports activex viewer flashes then quits

    The pop-up blocker theory didnt pan out it still does flashes off the screen even when disabled in the browser settings(internet options)
  8. esu4edp

    Crystal reports activex viewer flashes then quits

    I will look into the pop up issue. My question would be since this is not a browser or internet issue would the internet settings still play a factor as far as popups being blocked in the browser settings. I disabled all the activex settings in my internet options to see if it would cause my...
  9. esu4edp

    Rollback questions and skipped number sequence

    Sure, but will that table be the only one thats effected. For example if I'm missing records from that table, will other tables in my database (483 tables in my database) be missing records.
  10. esu4edp

    Rollback questions and skipped number sequence

    Can someone please explain if an SQL database would have to rollback for some reason, does it roll back all the data or just some of the data in certain tables? Can it do both? I have a database and a certain table is missing entries. There is a field in the table called RECID that basically...
  11. esu4edp

    Crystal reports activex viewer flashes then quits

    Yes I have uninstalled and reinstalled. Have even manually unregistered some dll's and the ocx and then manually re-registered them.
  12. esu4edp

    Crystal reports activex viewer flashes then quits

    A caption box does not appear. And I dont believe that this file is in version 11. I dont have it on mine and I looked at a few others the run the viewer just fine and they dont have that file either.
  13. esu4edp

    Crystal reports activex viewer flashes then quits

    I have a couple of computers that have the activex viewer installed to view reports. When started up thru an application written in clarion it starts up then flahes right off the screen and quits. I have uninstalled/reinstalled. Double checked the permissions in the registry but this happens...
  14. esu4edp

    Date help!

    Hey this worked out perfectly. Can I change the order by in the statement to order it by month for that particular year. So basically the user enters the year and it gives all those records for that year, then can I order by month for that year?
  15. esu4edp

    Null value for date/time field as "Off"

    hh:nn:ss;;;"Off" This worked perfect! Thanks
  16. esu4edp

    Null value for date/time field as "Off"

    hh:nn:ss;;"Off";"Off" This worked out great exept for times that started at midnight or 00:00 the other example =IIF([Arrive] Is Null,"OFF",[Arrive]) keeps giving me an error
  17. esu4edp

    Null value for date/time field as "Off"

    I have a report that has a time field. If that value is not filled in or left blank, I want that value to be displayed at "Off" on the report. I have tried several statements but they dont work: Nz([Arrive],"Off") SELECT IIF(IsNull([Arrive]), 'OFF, [Arrive]) =IIF([Arrive] Is...
  18. esu4edp

    Date help!

    Ok, just so I understand where to put this. This statement would go on a form by itself, the user enters the 4 digit date and then it would take that date and open another form "frmFindDates" and display it: Private Sub Combo27_AfterUpdate() Dim intYear As Integer Dim strWhere As String...
  19. esu4edp

    Date help!

    I have a database that is basically a log book for recording flight hours. We enter the date like 01-jul-05 for example in the tables. I have a form that asks the user to enter the year to print out an annual report of flight times for that whole year, but I only want the user to enter for...
  20. esu4edp

    Self-paced newbie needs help with network!

    no i could not ping the other computer by ip, if thats what you mean. I'm not sure if I did something right on initial setup, but when I was installing 2003 server on the server it asked about DHCP being static and I said no I wanted it to be dynamic. I thought this was right because I use a...

Part and Inventory Search

Back
Top