Search results for query: *

I am trying to search a binary field on a SQL Server database. I thought I could enable full-text searching for the database, create a full-text catalog, enable full-text search for the specific table (create index, add columns to it, populate it). I think at this point I could use special...

I am using Crystal Reports v11 connecting via ODBC to a SQL Server database. The SQL database has a binary notes field that is showing up in Crystal as a BLOB. I need to be able to search this field. When I try selection expert the field does not even show up to search. I also can not view...

I will be replacing an existing WinNT4.0 server with a brand new Windows Server 2003 machine. I have done NT - 2003 upgrades but have never done a server migration. There is only three users at this location. I know on WinNT I can create a PDC and a BDC but not sure how this works for...

I just got a new dell machine running WindowsXP Office 2003 When I try to access a machine on my network running windows98 and Office2002 I get a blank excel screen the document never opens. I copy and paste it the XP machine I can open the document fine.

I have a table with EmpID, Name, Status, Payrate, Effective date, etc. showing employee status changes there is a new record for each change. I need to do two things with the table. 1. A report: I need to do a query to pull the record for each employee that has the latest <Eff date>. 2. A...

I have a table with EmpID, Name, Status, Payrate, Effective date, etc. showing employee status changes there is a new record for each change. I need to do two things with the table. 1. A report: I need to do a query to pull the record for each employee that has the latest <Eff date>. 2. A...

I have an HR system in Microsoft Access, one table lists pay rates, merit increases, status changes etc. but I need only the current pay rate and information to show up on the reports and main form. As it stands right now the reports lists every pay rate and status change. I do need to keep a...

How can I do a query by Birth month only using the birth date field? i.e. I need a report for all birthdays in January regardless of year.

Whenever I open Adobe Acrobat I get the following error illegal operation error. Acrobat caused an invalid page fault in module ESCRIPT.API Then it crashes! I have no idea how to fix this or what happened to cause it. Please help!!

In our HR Access Database I created a Work History SubForm which lists all status changes ie. rate, position, etc. I need a way to keep a history of changes. Right now it is just a list so when I run any reports I get all status changes listed. I need a way to reflect only the most current...

I converted our HR database from Access97 to Access2000 and now the New button (for a new table, form, query etc.) is grayed out. If I open the database in Access97 I can add tables etc. but not in 2000? Anyone else had this problem? PLEASE let me know if there is a fix. I have checked...

The President of my company is getting an illegal operation error every time he opens Outlook 2000 running on Win98. The error details say OUTLOOK CAUSED AN INVALID PAGE FAULT IN MODULE MSVCRT.DLL. Has anyone ever experienced this error I have tried removing and reinstalling Outlook and still...

I am using CR 8.0 SQLBASE v6.2.1 database Data connection method: ODBC Each time I write a Crystal report and cross database tables I get a blank repot, even though I know that there is data that should appear. I used to do this with no problem. Below is a sample of one report that is coming...

We have a WAN made up of 4 LAN's located in 4 different States. Connected through VPN All locations running WINNT 4.0 Server, and various Client software (Win 2000, WIN98 mostly). There is a strange problem at one of our locations, 5 out of about 25 client machines cannot ping outside of their...

ODBC error:[MERANT][ODBC SQLBase driver]The keywords LEFT OUTER JOIN were not found in an outer join escape sequence. We have several Crystal Reports that we run yearly, monthly. Recently every time we need to run a report we get the above message. No changes have been mad to these reports or...

I have a Help Desk log form that I created in Access using two separate tables. The first table includes user names and info. The second part of the form comes from a separate table that shows problems/ solutions etc. I would like to have a drop down menu for the users Last name which when...

I created a database in MS Access to replace our old! HR System. I need a way to keep a history of changes in employee status, rate change, etc. What is the best way of doing this? I do not want to replace the existing information when updating the record. Thanks so much! Kat

I have a monthly report that I run in Crystal Reports that has always worked until this month when I get and ODBC error. I have tried rewriting the report and running it from other databases and locations but I still get the same error. Does anyone know what this means? ODBC...

I am tring customize a report, using Quest editor. I have added a column to my report with a numberIFF function. I now need to total this column. I have tried to use an Input total and just a SUM command. But I never get to correct total. Has anyone had this problem? I would appriciate any...

I am tring customize a VMFG report, using Quest editor. I have added a column to my report with a numberIFF function. I now need to total this column. I have tried to use an Input total and just a SUM command. But I never get to correct total. Has anyone had this problem? I would...