Re: how do I search for a specific name in Excel spreadsheet?
Use CNRL F
Read Entire Conversation

Reminders
Hi I need to set up part of my db to be able to give the user the facility 
 
to enter notes and then be reminded that action is required on a certain 
 
date related to the notes (The notes would have to be linked to the 
 
CustomerID).  Each user would get there own reminders but I would like it 
 
set up so that the notes can be seen by anyone who wanted to check them as 
 
and when needed.  Has anyone got any ideas on how I would go about setting 
 
this up? 
 
At the moment we use a tick bo ...
Read Entire Conversation

rastreadores GPS Ratreador gps localizadores bloqueadores 2520434
CENTRAL ÚNICA DE VENDAS 
 
10 Marcas de ratreadores, Compare e Compre. 
 
Rastreador de Veículo 
 
Rastreadores de Veículos 
 
Rastreador GPS 
 
Rastreadores GPS 
 
Rastreador Ituran 
 
Rastreadores Ituran 
 
Rastreador Portátil 
 
Rastreadores Portáteis. 
 
Assistência 24 Horas 
 
Visite agora mesmo nosso site. 
 
http://tel011-50523122.vila.bol.com.br/ 
 
Graber - Teletrim - Tele Trim - Ituran - 
 
Rastreadores gps , Localizadores, Bloqueadores 
 
Graber - Teletrim - Tele Trim - Ituran - 
 
Ra ...
Read Entire Conversation

how do I search for a specific name in Excel spreadsheet?
I want to search for a name in a simple spreadsheet.  I don't understand the 
 
Lookup function and don't think the "Go to" function works either.  Any 
 
suggestions?
Read Entire Conversation

Grouping & Counting on a Field
Hello, 
 
I've created a query that list all Access Reports that were written for 
 
various departments. The query works fine but is displaying duplicate 
 
department names (one display for each Access Report written for that 
 
department). 
 
I'd like to display the results (w/o duplicate department names) in an 
 
Access Report as follows: 
 
DEPARTMENT  NUMBER OF REPORTS WRITTEN 
 
HR                  10 
 
Payroll             21 
 
Accounting       35 
 
Please advise and thank you in advance, 
 
Bob
Read Entire Conversation

Lady Only
Lady only 24-Hrs +91 9810577227 
 
OR email to info@lenstar.org
Read Entire Conversation

create booklet printed on both sides 8.5 X14
I need to prepare a numbered 10 page booklet on a 8.5X14 sheet printed on 
 
both sides
Read Entire Conversation

need help with opening excel automatically
i have a command button that transfer an access form to a specific excel 
 
file, and i'd like to have it so that once that button's clicked, the data is 
 
transferred, and that excel file where it was saved, would pop up.... 
 
I've done a search here, and i've seen answers relating to hyperlinks, shell 
 
codes....and most of these answers are like Greek to me (can you tell i'm a 
 
beginner??!!) 
 
Can someone please help me using plain and simple english how to accomplish 
 
my task? thanks in advance!
Read Entire Conversation

Disappearing Act
Hi, 
 
When I start Access the Assistant paper clip is present, but after a while 
 
it just disappears and I get a pop-up that I need to install a character.
Read Entire Conversation

Always Losing Things
Hi, 
 
I am always losing things so why should it be any different with the 
 
computer?  I have lost the majority of the headings on my menu. Normally 
 
there is "File", "Edit", "View", "Insert", "Tools", "Window" and "Help." 
 
Now all I have is File, Window and Help. 
 
I have tried to restore, but all of the advice says "Click View". Since I 
 
have no view to click I am stuck.  How can I restore the menu?
Read Entire Conversation

find not finding records
Hello, 
 
I was asked to look into a problem with the access find box not finding 
 
some records, when searching thru records via a form.  The "missing" 
 
record could be found if the partial name and wildcard * was used.  I 
 
checked the actual record and could find no leading or trailing 
 
characters.  It's only "sometimes" this happens, and the records which 
 
are not found appears to be totally random.  I wanted to check here, 
 
first, before spending a lot of time looking into this in ...
Read Entire Conversation

Love Hotline
Lady only 24-Hrs +91 9810577227
Read Entire Conversation

help with syntax
I have this expression: 
 
DateDiff("d",[InvoiceDate],Now()) 
 
I want to modify it to pull  InvoiceDate from a specific 
 
table ECNCMaster. I can't seem to figure out the bracketing. 
 
Could someone give me a hand with syntax? 
 
gls858
Read Entire Conversation

group by date to create daily invoice totals
I have created a query that includes dates and daily invoice amounts.  Each 
 
date has more than one invoice entry.  I need to create in my query a column 
 
that will combine invoice totals for each day.
Read Entire Conversation

Access 2002
I would like to track 10 vehicles expense. 
 
gas, repairs, and by whom. 
 
Any help out there?
Read Entire Conversation

Archive Data
I have a table containing details of customer orders which has a dropdown 
 
status field.  When the status is changed to 'completed' I want the order 
 
details to transfer to a separate table so that the first table only contains 
 
details of incomplete orders.  Would I do this with an append query? 
 
Many thanks.
Read Entire Conversation

Extract Date out of General Date
I have a series of rows that resemble 6/1/2006 5:34:34 PM type of 
 
format. 
 
However, I would really only like the extract out the 6/1/2006 portion 
 
of this date.  I have used left(fieldName,9) but this wouldn't work too 
 
well if the month was a double digit, or if I left it as 10, it would 
 
grab a portion of the hour in time. 
 
Is there a work around for this?  I have searched and attemped but am 
 
at a loss now. 
 
Thank you.
Read Entire Conversation

multi-users, split databases
I have reviewed most of the post regarding :split databases and multi-users, 
 
but have not found if the answer I was looking to find. 
 
If the database has auto-numbering on the files; will the split databases 
 
allow one user to enter a record, while the other user enters a record at the 
 
same time, will the database save the second record? I have not used a split 
 
database before now and need to know if the records will be saved. And how 
 
will the autonumbering be assigned to each fi ...
Read Entire Conversation

Changing Design view
I'm trying to modify a database that was made by someone else.  The database 
 
will not fit on one page when you view it.  How do I change it so it fits on 
 
just one page.  I went into the design view but couldn't change it.  I'm sure 
 
it is something simple to do but I don't know how.  So if someone could help 
 
me I would appreciate it.  Thanks in advance.
Read Entire Conversation

Need Direction - Map one access mdb to another
Hello All, 
 
I am really all turned around. New enough to not know better!!!! 
 
Problem Setup: 
 
I have made some changes to my VB application so it captures more data and 
 
writes it th a database. In the writing of my Version 2 of my app,  I took 
 
my existing db and just added the necessary additional  tables, and added a 
 
few fields to some of the pre-existing tables, and created new relations for 
 
those the new tables back to the old tables. (may have changes some of the 
 
relatio ...
Read Entire Conversation

Reading files from a drive
I've got a strange one for you access Guru's. 
 
Everyday we download txt files and my access program extracts the data from 
 
the files and puts them into a table. 
 
When the user I have created the program for tries to run the program, no 
 
files are found.  when I run the program the files are found. 
 
* The user has full access rights to the folder and parent folders 
 
* The user can access the directory through command prompt and GUI 
 
* the user 
 
* When I log into his computer I ca ...
Read Entire Conversation

newbie question about E-mail
I'm trying to convert an old booking system to Access for Children's Theatre 
 
of Charlotte's school performances (professional productions for youth). 
 
Tables will (should?) include Schools (i.e. customers), ShowTitles (i.e. 
 
catagories), PerformanceDateTimes (i.e. products), Contacts (multiple people 
 
book from the same school), Bookings (i.e. orders) ... if we have e-mail 
 
addresses as a field within a Table (or two), can Access create an "e-mail 
 
reminder" that would go to the con ...
Read Entire Conversation

Password in back-end database
Both my front end and back end database have passwords. 
 
However, I now cannot run the application since every time the application 
 
tries to access a linked table, it gets a password failure. How do I get 
 
around this?
Read Entire Conversation

Switchboard as Default
Hi this is probably pretty apparent, but I can find anything on it. 
 
I would like the switchboard to be the first thing the user sees as opposed 
 
to the switchboard in a pop-up with the menu showing behind it. 
 
And I would like it to open in full page view, and fit on anyone's screen 
 
regardless of settings. Is this possible?
Read Entire Conversation

Silly Question - Icon Madness!
I created 6 reports. Four of these are shown with a dark green book icon and 
 
two have a light green icon. I can see all of the reports in the menu, but my 
 
boss can only see the dark green icons.  For a minute I thought they had been 
 
erased!!  What did I do and how can I correct this so that they are all 
 
visible?? What does the light green icon mean as opposed to the dark green 
 
icon
Read Entire Conversation