Recent content by loo

I need to be able to date stamp fields based on when another field value changes. I only want the value to be entered once upon the change. I have mutliple status that need to be tracked. I need to know what date it became active I need to know when that status field changes to approved ect...

this won't work because putting it together in one queries adds values to each line that should have zero values in them. Nesting Queries...doesn't work. Thank you though.

I need to put the information generated from 3 queries onto one report... first query contains.. part_id First_name Last_name Gross_Hours Gross_pay Home_Dept Dept_Worked 2nd query contains Part_ID Dept_Worked total of all rev earned by department 3rd Query contains part_id Dept of damage...

I need to put the information generated from 3 queries onto one report... first query contains.. part_id First_name Last_name Gross_Hours Gross_pay Home_Dept Dept_Worked 2nd query contains Part_ID Dept_Worked total of all rev earned by department 3rd Query contains part_id Dept of damage...

oops Auto_open

I found it... name the macro Macro_open and it runs on open... too simple

I need to put the information generated from 3 queries onto one report... first query contains.. part_id First_name Last_name Gross_Hours Gross_pay Home_Dept Dept_Worked 2nd query contains Part_ID Dept_Worked total of all rev earned by department 3rd Query contains part_id Dept of damage...

How do I have a macro run automatically when a workbook is opened?

I need to use two queries to tie into one report... they come from different tables with subtotals and I need to combine the two but there doesn't seem to be a way via relationships. I have a payroll table that has department worked by ID # with gross wages & hours worked. I have a production...

Dim x Sub deletion() ' ' Macro recorded 11/24/2001 by Leslie Opsahl For x = 2 To 65000 If Cells(x, 2) = "" Then End If Cells(x, 2) = Cells((x - 1), 2) Then Call remove Next x End Sub Sub remove() Rows(x - 1).Select Selection.Delete Shift:=xlUp x = x - 1 End Sub

Excel 2000 currently I am trying to figure out how to keep a long number to remain as a text field in excel. When it imports from crystal reports it comes in as a text field. Excel picks it up as a number stored as text. If you go into that cell and out it coverts it to 2.00201E+12 I need...

Okay I do understand the attach information that you provided. But the question I still have remaining is do I need to have the table structures defined in the database I am attaching the mdf file to?

I need to know if after creating a database that I want to attach mdf files to from another database do I need to have the table structure the same in the new db. Also do I need to attach both the mdf file and the log file.