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!

Register Log in
  • Congratulations Chriss Miller 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. PlsHlpKat

    search a binary field on a SQL Server

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

    Crystal Reports search a BLOB field

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

    Migrtating users from NT4.0 to Server2003

    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?
  4. PlsHlpKat

    Migrtating users from NT4.0 to Server2003

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

    Can not open Excel 2002 spreadsheet with Excel 2003

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

    Can not open Excel 2002 spreadsheet with Excel 2003

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

    MAX Statement

    Thank you golom! This works great!! Kat
  8. PlsHlpKat

    MAX Statement

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

    MAX Statement

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

    Query records with latest effective date

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

    Query records with latest effective date

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

    Use updated info but retain history

    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?
  13. PlsHlpKat

    Use updated info but retain history

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

    Birthdate query by month only

    Thanks!! That worked!
  15. PlsHlpKat

    Birthdate query by month only

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

    Acrobat 6.0 Page Fault ESCRIPT.ap1 error

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

    Acrobat 6.0 Page Fault ESCRIPT.ap1 error

    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!!
  18. PlsHlpKat

    Updating while keeping a history

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

    Auto fill fields in a form

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

    Auto fill fields in a form

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

Part and Inventory Search

Back
Top