Search:

Type: Posts; User: buckshot; Keyword(s):

Page 1 of 8 1 2 3 4

Search: Search took 0.04 seconds.

  1. Replies
    2
    Views
    131

    Date search problem

    I had excel 2003 and now have 2010, when I search for a date 04/05/1982 excel 2010 will not find it that way. Now I have to type 4/5/1982-I have changed the date to custom mm/dd/yyyy and that does...
  2. Replies
    7
    Views
    1,342

    Playing two videos at the same time

    I’m trying to play two videos at the same time on the same slide in powerpoint 2007. It plays one video then it plays the 2nd on after the first one is done. This is ok but I would like the videos to...
  3. VLookup over multiple worksheets Excel 2003

    My coversheet is set up to look at 2 different worksheets--Excel 2003 not 2007 or 2010
    I'm using this formula =VLOOKUP($B$4,'Warehouse 1 to 199999'!$A$2:$G$54224,2,FALSE)
    It works great but it will...
  4. Replies
    3
    Views
    400

    Converting DOB

    I have a date of birth that came in to my Access 2003 like this
    19680622
    So I used this formula to convert it to 06/22/1969
    Mid([DOB],5,2) & "/" & Right([DOB],2) & "/" & Left([DOB],4)

    which is...
  5. Replies
    3
    Views
    718

    The table structure is the contents in box and...

    The table structure is the contents in box and the locations of the box is all in one table. The table fields are- Date sent to warehouse, Contents of what is in your box, Location of the shelf the...
  6. Replies
    3
    Views
    718

    Find a number between two numbers

    Hi all
    I have a warehouse access Database it has the Contents in this box and the locations of the box. My Contents will contain charts between 500-88400 this box will be located on B3-28A, my next...
  7. Replies
    1
    Views
    1,708

    Change date format Access 2003

    I have a date of 08/12/11. I would like it to have 08/12/2011-how can this be done in Access 2003?
  8. Replies
    3
    Views
    871

    I would like it to run a report on it's own. I'm...

    I would like it to run a report on it's own. I'm using access 2003. How can this be done?
  9. Replies
    3
    Views
    871

    automatically send a email

    Can you automatically send a email from microsoft access to outlook on the 1st of every month? We keep our birthday list in access and would like the list of everyone having a birthday that month to...
  10. Replies
    1
    Views
    528

    Trouble getting rid of text

    I imported a access file -the word NO is listed under Exp if the person did not die. I can not get rid of the word NO. There is no default value listed. I get a popup saying "You can't replace the...
  11. Thread: Date format

    by buckshot
    Replies
    3
    Views
    601

    Date format

    A database was sent to me with the dates 01/02/48 -with two spaces before the 01 for some reason.
    I would like it to be 01/02/1948. Right click format does not work. Here is a copy of the database...
  12. How do you trim the last letter in access 2003?

    If more then 1 letter is at the end of a persons name after the last space do nothing but if only 1 letter is after the name then take that letter off in access 2003?
    Smith,John A--I would want to...
  13. Replies
    5
    Views
    2,972

    I'm not sure how to write that Result =...

    I'm not sure how to write that
    Result = DateOfDeath - DOB
    would it be in the query or on the form that I'm using?
    How do you even write that? Result:([DateOfDeath-[DOB]) this did not work for me I...
  14. Replies
    5
    Views
    2,972

    Subtract 2 dates in access 2003

    Hi I have a form that I'm working in--how does access subtract the DOB from the date of death? would it have to be in the query or in the form?
  15. Replies
    7
    Views
    4,759

    RetiredGeek thank you sooooo much--your the best

    RetiredGeek thank you sooooo much--your the best
  16. Replies
    7
    Views
    4,759

    Update records from excel into access

    I would like to update records to the deceased section in access from a excel spreadsheet.
    I have a access dbase with patient #, name, and a deceased date. The Excel spreadsheet is setup the same...
  17. Replies
    2
    Views
    1,167

    Keep the starting 0's

    Hi I have a database A1=00 A2=66 A3=08-- what I need it to look like is 00-66-08 or 006608 with the 0 before the 0 in A1 and the 0 before the 8 in A3. How, How, How can this be done????
  18. Replies
    2
    Views
    897

    Cut the last character after a space

    I need to get rid of the middle initial if they have one. It's always at the end after a space. example John Smith A.
    in Excel 2000
    Thanks so much
  19. Replies
    1
    Views
    584

    Get rid of space after a comma

    I need to get rid of space after a comma. Example John, Smith K. I need it to look like John,Smith K
    I have Excel 2000
  20. Thread: Missing data

    by buckshot
    Replies
    3
    Views
    595

    Column A contains Names--B contains addresses...

    Column A contains Names--B contains addresses --and C contains Zip
  21. Thread: Missing data

    by buckshot
    Replies
    3
    Views
    595

    Missing data

    I would like to get the Zip Codes into database 1 from database 2. Database 1 has names, addresses, but No Zip Codes and contains only 2000 people. Database 2 has Names, Addresses, and Zip codes. It...
  22. I'm talking about forwarded messages I receive....

    I'm talking about forwarded messages I receive. Microsoft outlook 2003 is what we have
  23. How do you eliminate blue vertical lines in...

    How do you eliminate blue vertical lines in forwarded emails with pictures or attachments? I'm using Yahoo and Hotmail at work we use Microsoft Outlook.
  24. Replies
    2
    Views
    415

    How do you name a range of worksheets? Example...

    How do you name a range of worksheets? Example Sheets 1,2, and 3 would be called "TheSheets"
  25. How do you using Vlookup with multiple...

    How do you using Vlookup with multiple worksheets?

    January to December are on different worksheets—my company does not want to combine all the names to just one worksheet for a reason I don’t...
Results 1 to 25 of 182
Page 1 of 8 1 2 3 4