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

Yes, I understand that but my questions is how can I migrate the user accounts and all of the data to the new machine. Can I have both servers on line at the same time and just move the info across the network? If so how?

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 had to install Office 2002 on the ne PC to replace Office 2003 now the files open with no problems. If anyone has any information on this Occie 2003 problem please let me know.

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.

Thank you golom! This works great!! Kat

I copied your code word for work and I am still getting all records??? Kat

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

My code is not working I am getting Syntax error am I doing something wrong? SELECT[CLOCK #], [Last Name], [First Name], [Hire Date], Status, [EFF Date], [Review Date], Action, [Rating Code], [Increase Amt], [Inc Perct], [Pay Rate], [Next Review], [Department/Team], [Cost Center], [Job...

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

Yes I am inserting a new record for each change but I am not clear on what you mean by a time stamp, could you please explain?

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

Thanks!! That worked!

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.

I ended up deleting the update script which must have been corrupted. After that it worked just fine. The file name to delete is: udstore.js Thanks! Kathleen

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

Thank you for your help I've gotten it to work in a round about way now that you have explained how lname --combo.column(0),fname -->combo.column(1),etc. works I have a better understanding. So I just set the Control source for fname = combo88.column(1)etc. Thanks so much for your help this is...

Sorry to just be getting back to you I had to move on to other things and I now found the time to work on this again. I set the lname combo box up to select lname, fname, phone, department from the USER table. I am still getting an error on: Private Sub Combo78_AfterUpdate()...