|
| Re: how do I search for a specific name in Excel spreadsheet? |
|
|
| 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 |
|