Search:

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

Page 1 of 8 1 2 3 4

Search: Search took 0.04 seconds.

  1. Replies
    1
    Views
    50

    default date format

    In my form you have to enter the appointment date. Is there a way that the / is put in by default so all you have to type is the day-month-and year. 10/20/2016
  2. Delete info in rows 1 and 2 but not 3 and 4

    What would be a fast way to delete all the information under "customers" and "contains" but keep all the "location" spots. I did a append query based on criteria to move the information to the "no...
  3. Replies
    8
    Views
    687

    Thanks Paul-that's what I did. Now I will have a...

    Thanks Paul-that's what I did. Now I will have a master table of locations also. Thanks again
  4. Replies
    8
    Views
    687

    The warehouse locations are A1-01 to A1-55 up to...

    The warehouse locations are A1-01 to A1-55 up to A8-01 to A8-55; then "B" shelf starts and so on taking you up to Z1-01 to Z8-55. Every warehouse location spot is designed to hold a box. As boxes get...
  5. Replies
    8
    Views
    687

    No the "location is not the primary key....

    No the "location is not the primary key. Category,Contents, Location, and Storage date. I'm looking for any locations that might have got deleted in a append and delete query. There are over 14000...
  6. Replies
    8
    Views
    687

    Finding missing numbers

    I'm working in Access 2007. I'm trying to find missing locations. If the location number goes from A1-01 to A1-04 I would like the report/query to give me A1-02 and A1-03
  7. Replies
    1
    Views
    369

    Change Year format on imported database

    I have Access 2007 that I suck in a report that has the date 07/08/15, how can you change that to 07/08/1915. I need that 4 digit year format.
  8. Replies
    5
    Views
    1,494

    Thanks Zeddy, I do have excel 2007

    Thanks Zeddy, I do have excel 2007
  9. Replies
    5
    Views
    1,494

    Cover Sheet results

    I have a cover sheet (listing the Months from which I get results like name, apartment number, payments)
    Months
    A2 Jan-April 2015 typed in
    A3 May-Aug 2015 typed in
    A4 Sept-Dec 2015 typed in

    My...
  10. Replies
    7
    Views
    1,925

    Joining two unrelated tables

    I have 2 tables one is a active and one is a inactive. The information is moved from the active table to the inactive table once the patient becomes inactive. If I'm searching for John Johnson I have...
  11. Replies
    2
    Views
    353

    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...
  12. Replies
    7
    Views
    3,840

    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...
  13. 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...
  14. Replies
    3
    Views
    823

    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...
  15. Replies
    3
    Views
    1,321

    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...
  16. Replies
    3
    Views
    1,321

    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...
  17. Replies
    1
    Views
    2,644

    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?
  18. Replies
    3
    Views
    1,281

    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?
  19. Replies
    3
    Views
    1,281

    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...
  20. Replies
    1
    Views
    771

    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...
  21. Thread: Date format

    by buckshot
    Replies
    3
    Views
    822

    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...
  22. 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...
  23. Replies
    5
    Views
    4,895

    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...
  24. Replies
    5
    Views
    4,895

    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?
  25. Replies
    7
    Views
    16,053

    RetiredGeek thank you sooooo much--your the best

    RetiredGeek thank you sooooo much--your the best
Results 1 to 25 of 192
Page 1 of 8 1 2 3 4