Search results for query: *

Thanks sxschech that worked perfectly.......

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

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

This might Help resolve this issue, on the one machine that show the birthdate as an actual date the following screen shots come up wanting you to fix up the database you have to deselect the match type to be able to map it again....if I am not mistaken pervasive get its database field type...

I just went and looked at the obdc drivers and all the versions are the exact same on both machines

I do not believe so, the database is a pervasive database and it uses ddf files to get the field definitions. this is why I am so confused because it is looking at the same ddf file you would think it would be the same.......

that is my issue......the report displays the birth date field as a date when ran on one system but displays as a number on another system. if the problem was localized to a single machine I would just blow it off but its about 50-50 on how it displays and its not just this one report it is any...

Thanks, I checked on both systems and the options fields settings are both the same, set to system defaults. I actually changed them just to see if it made any difference, but it did not. oddly I believe it to be something system related, I installed a program called datalink viewer and had the...

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

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

ok I am sure you can do it with a script but I would not be you man.....I am really bad at scripting. I can take a script and be able to follow it and make some adjustments but from scratch I SUCK........I would probably start a new post at this site. there are some really good people here and...

thanks for you responce I was able to figure it out. I created a date field and and put the following script in the custom calculation script box var d1 = new Date(); var num = d1.valueOf(); num += 1000 * 60 * 60 * 24 * 14; var d2 = new Date(num); event.value =util.printd("mm/dd/yyyy", d2)...

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

Thanks it works perfectly......I uses the query builder and had no error.......thanks so much for your help

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

THANKS......IT looks great. I put it into the query but it gives me an error "Check the subquery's syntax and enclose the subquery in parentheses"...I just copied and pasted the query from what you typed........Thanks so much for your help

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

thanks.....sounds simple enough.....I guess I could not see the forest for the trees..........Happens sometines

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

By the way, this is the BEST forum on the net for anything