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. rubberhead10

    query if any value = x

    So I am having brain fade or something and need some help. I have a access database and one of the tables has many fields that are equal to either pass or fail. I need a query that will look at the table and if any field equals "Fail" it will populate the entire record.....I tried putting...
  2. rubberhead10

    Increas dhcp pool size

    I would like to increase the dhcp pool size of the following pool and was wondering how I can accomplish this. I basically want to change the network to read network 172.16.110.0 255.255.254.0 this would double my pool size and resolve my running out of addresses ip dhcp excluded-address...
  3. rubberhead10

    Date field type Issue

    I have two windows xp sp 3 machines both running crystal reports 11. When I open the same exact report on both of the machines and browse to one of the date fields. One of the machines will prompt you to fix the report up then show the date as an actual date and the other will not ask to fix up...
  4. rubberhead10

    create multiple calendar appointments

    hi everyone, we are instuting a new hire policy where certain thing mus happen at different day intervals like at day 1 lunch whith new hire at day 5 meet with new hire at day 30 do an evaluation. what i was wondering is there a way to create one appointment that will populate the rest of the...
  5. rubberhead10

    require date to be two weeks in advance

    I need to create a form that when the user selects the date required field it will only allow them to choose a date at least two weeks in the future....thanks
  6. rubberhead10

    Data access error

    hello, I am tring to create a parameter field in CR11. I am connecting to access 2007 database. the report works fine until I add the parameter fiels to select a date/time range. I recieve the following error failed to retrieve data from the database. details: ADO error code: 0x80040e14 Source...
  7. rubberhead10

    report to lookup value not in database

    hello all, I need to design a report that would look for an employee that has missed a certain training class. I am using access 2007 and have the following tables tblemployeeInfo that has fields empID, empname, empgender and the table tblClassAttendance that has fields empid, className...
  8. rubberhead10

    mark record inactive

    I would like to be able to set a record as inactive and not have it dispayed in the form. I have an employee database and if an employee is terminated I want to keep the record in the table but not have it dispalyed in the form. I am using access 2007........thanks for your help
  9. rubberhead10

    dynamic distribution list for office location

    I was wondering how I can create a dynamic distribution list based on a persons office location that is set in there user account in the AD......thanks
  10. rubberhead10

    OWA Logon issues get prompted twice to log on

    Hello all my network lay out is exchange 2007 server published thru an isa server. it all works fine. if I access owa from the local domain it logs in perfect but if I try to access owa over the internet the office outlook web access page comes up I enter the domain\username and the password...
  11. rubberhead10

    formula field help needed

    hello all please forgive me this is probably an easy question to answer but my formula skills suck... I am using crystal reports 10 I have written the following code but it does not seam to give me what I want if {PR_Empl_Deductions.Deduction Code} = "401k", "401k% then {PR_Empl_Deductions.YTD...
  12. rubberhead10

    multiply running total

    Hello all I am using crystal reports 10 and have a small issue. I am tring to multiply a running total by 26. I have a couple fields that I am adding together to get a running total by each employee and would like to get a total for the year by multipling the running total by 26 (number of...
  13. rubberhead10

    help needed with formula

    Hello I am using crystal reports 11 and have situation that I cant figure out. when we do our payrol check run we take a deduction for our 401k and all of our tax stuff but what has happened is when we run a manual check the deduction for people having a 401k % ammount was missed. the goverment...
  14. rubberhead10

    cisco 1130 image file

    Hello All I am pertty new to the cisco 1130 but I was wondering if anyone knew how to download the image file from the web interface? if it cant be done any one have instructions to pull it from a telnet connection.......Thanks
  15. rubberhead10

    adding fields based on criteria

    Hello all, I am using crystal reports 11 and need to create a formula that will give me the total hours of employees that are in a certain job class (could be multiple job classes) as long as the employee has greater than 35 hours in that pay period. at the end of the report I wan to show the...
  16. rubberhead10

    dual network cards

    Hello all I have recently purchased a dell 2950 server that has two network cards installed in it. currently I am using just the one network card with a static ip address. I would like to bring the other card online but I am unsure of how to configure this card to work properly on the network...
  17. rubberhead10

    Group policy's over wireless connection

    Hello all I am having some trouble with some windows xp machines picking up computer based group policies over a wireless connection. when I make changes to the computer policies they do not update while on the wireless connection but once I plug them in to the cat5 they update fine. the user...
  18. rubberhead10

    selection expert

    I am tring to do a report that has three fields. the first two fields are first name, last name the last field is a health insurance field that has numerous codes. I have used the selection expert to pull out the codes that I want and that works fine. but what I need it to do is to list the...
  19. rubberhead10

    adding the same field twice in report

    I need to place the same field twice in to a report but need it to pull different codes from the fields in each column. I would think I need to create a formula to do this...any help is appreciated..
  20. rubberhead10

    grouping by birthmonth

    I am looking for a way to group by someones birth month. I must admit that I am rather new at crystal and would appreciate any help........

Part and Inventory Search

Back
Top