Search results for query: *

We recently found some files on my companies network that need to be accessed, but they are password protected. They are windows 2000, but the employee no longer works here to give us the password. Without buying software does anyone know how to use a hex-editor to find the password? I...

I have a query pSELECT TOP 100 PERCENT dbo.Section.sectionID, dbo.SubSection.SubSectionID, dbo.Qustn.QustnOrder, dbo.Qustn.QustnText, dbo.Qustn.QustnType, dbo.Section.sectionDesc, dbo.SubSection.SubSectionText, dbo.TargetSection.targetId FROM dbo.SubSection INNER JOIN...

Ok, I want to run a query that pulls the 'userpwrd' from the 'users' and the 'users_bak' table where em_id is the same in both. So I see what the PW is in both tables, then update the 'users' table with the value of the 'userpwrd' in the 'users_bak'. I have tried a few queries for the select...

A user of mine is getting that error on files, some that are 13mb, others that are 33mb. She has 2gb of RAM with virtual memory set at 4096 so AutoCAD 2005 works. Any ideas? "Adults are just obsolete children and the hell with them." - Dr. Seuss

In a table 'Qustn' field 'qustntext' some of the values have a quotation mark at the end. THe last character is " How Do I remove only this. SELECT QustnText FROM dbo.Qustn WHERE LTrim(RIGHT(qustntext, Len(qustntext)) - CharIndex('"', qustntext)) produces "Adults are just...

I have a field in a the 'Qustn' table that has a long string of data. I seemed of made a mistake is most of them but not all. The field is called 'QustnText'. At the end of the field I forgot to add some text (the string goes as follows) At the the spot where input is, I sometimes forgot to...

I have a table with 3 fields, em_id (vharchar 100), name_first (VarChar 50), name_last (varchar 50). em_id has name info like "doe, john". I need to split the data and make name_first and name_last hold that info. use wbtest Update afm.em Set name_last = Left(em_id, CharIndex(', '...

I am working on an update statement, and here is some background. I am writing a DTS package and the first step is to import a txt file into a table called 'A_Imp' (well the first step is to make sure that 'A_Imp' is empty.). Below is the table structure. CREATE TABLE A_Imp ( full_name...

I have a table with a full_name field, name_last and name_first fields. I need to take the full_name field (LName, FName MI) and split the LName into name_last and the FName MI into name_first. Thoughts? "Adults are just obsolete children and the hell with them." - Dr. Seuss

I have the following code =if(not isnull(lblCalc), Sum([SquareFeet] / CInt([lblCalc])),"") I need that to be a Sum as well, but the sum is not working... Ideas? "Adults are just obsolete children and the hell with them." - Dr. Seuss

I created a trigger for whenever data is inserted into a table CREATE TRIGGER trgEmIDIns ON [afm].[em] FOR INSERT AS update afm.em set em_id = name_last + ', ' + name_first + ' ' + em_id name_last = varchar(50) name_first = varchar(50) em_id = varchar(150) I ran an insert statement (very...

I have 2 DTS packages for a client, and 1 of them concatenates 3 fields into 1 (and works fine), and the other I need to take the concatenated field and split it up to only grab 1 part of it. My code concatenates as follows "lastname, "firstname MI" "em_id" (middle initial is part of the first...

I have some VBA code that does some checks for me and fill in a text box. If Not IsNull(Me.Text71a) Then Dim v1, v2 As Integer v1 = Me.Text71 v2 = Me.Text71a If v1 < v2 Then Me.lblCalc.Value = CInt(Round(v1, 0)) Else Me.lblCalc.Value = CInt(Round(v2, 0)) End If Else...

Ok, I have a report in Access. When it runs, I want some actions to take place. Essentially, on the report the 2 labels are text71 and text 72. Dim strValue1 Dim strValue2 strValue1 = Me.Text71 strValue2 = Me.Text71a If strValue1 < strValue2 Me.Text71 = strValue2 Else Me.Text71 = strValue1...

Can someone please just post a simple if statement example in access. 2 text boxes and a label. I want the labels value to change based on what is in text box 1, or that is empty, what is in textbox 2. Thanks "Adults are just obsolete children and the hell with them." - Dr. Seuss

In table "users_Merge" I have an "empNum" (which contains their employee number), "fname", "lname", "mgrNum" (which currently contains the managers name in the "lname, fname" format). I need a query that will split the current "mgrNum" field, find the user and replace the current data in that...

Hi, I have 2 tables called "users" and "Table1". "users" contains all of the employee data and "table1" holds just the active employee ids ("empID"). I need code to join the tables to show me ONLY the data listed in "users" and not in "table1". Then I need the exact opposite, what is listed...

I have a field in a DB called "em_id" in the table "em". In this field the data is "lname, fname ID#". I want to pull from this field only the "ID#". Suggestions? "Adults are just obsolete children and the hell with them." - Dr. Seuss

OK, I have a radio button called "reqNo" and if it is set to true, I want a field called "Required" to add "user@domain.com" to the required user field. If "reqNo" is set to false (which it is by default) I want it to not add the e-mail address. IIf( expr , truepart , falsepart ) That is how...

OK, I have a few questions on a form I am designing in Outlook 2003. 1) I have 2 text boxes called reqNo and reqYes (these are for whether the service is required). reqNo is checked by default, and when someone checks reqYes I want it to uncheck reqNo and vice versa. 2) I have a required...