# Search:

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

Page 1 of 8 1

1. ## Thread: Date search problem

by buckshot
Replies
2
Views
181

### 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. ## Thread: Playing two videos at the same time

by buckshot
Replies
7
Views
1,766

### 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. ## Thread: VLookup over multiple worksheets Excel 2003

by buckshot
Replies
1
Views
313

### 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. ## Thread: Converting DOB

by buckshot
Replies
3
Views
501

### 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. ## Thread: Find a number between two numbers

by buckshot
Replies
3
Views
1,010

### 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. ## Thread: Find a number between two numbers

by buckshot
Replies
3
Views
1,010

### 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. ## Thread: Change date format Access 2003

by buckshot
Replies
1
Views
1,944

### 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. ## Thread: automatically send a email

by buckshot
Replies
3
Views
1,012

### 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. ## Thread: automatically send a email

by buckshot
Replies
3
Views
1,012

### 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. ## Thread: Trouble getting rid of text

by buckshot
Replies
1
Views
589

### 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
653

### 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. ## Thread: How do you trim the last letter in access 2003?

by buckshot
Replies
2
Views
829

### 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. ## Thread: Subtract 2 dates in access 2003

by buckshot
Replies
5
Views
3,440

### 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. ## Thread: Subtract 2 dates in access 2003

by buckshot
Replies
5
Views
3,440

### 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. ## Thread: Update records from excel into access

by buckshot
Replies
7
Views
6,607

### RetiredGeek thank you sooooo much--your the best

RetiredGeek thank you sooooo much--your the best
16. ## Thread: Update records from excel into access

by buckshot
Replies
7
Views
6,607

### 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. ## Thread: Keep the starting 0's

by buckshot
Replies
2
Views
1,231

### 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. ## Thread: Cut the last character after a space

by buckshot
Replies
2
Views
954

### 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. ## Thread: Get rid of space after a comma

by buckshot
Replies
1
Views
682

### 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
657

### 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
657

### 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. ## Thread: Eliminate blue vertical lines in forwarded email

by buckshot
Replies
5
Views
3,202

### I'm talking about forwarded messages I receive....

I'm talking about forwarded messages I receive. Microsoft outlook 2003 is what we have
23. ## Thread: Eliminate blue vertical lines in forwarded email

by buckshot
Replies
5
Views
3,202

### 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. ## Thread: Name worksheets

by buckshot
Replies
2
Views
483

### 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. ## Thread: How do you using Vlookup with multiple worksheet

by buckshot
Replies
2
Views
25,716

### 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