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 Wanet Telecoms Ltd on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by esu4edp

  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

Part and Inventory Search

Back
Top