|
windows live mail
Why
when I use window live Mail I keep getting a message server won't let me
send it becaue it
has not been in use for a while and thats because
my PC has had a virus and it crashed
any suggestion of Help would be appreciated
khania straw united kingdom
...
|
4 |
12/19/2008 4:40:19 AM |
|
|
"Does not contain" on a Text Field
How do I filter a text field in a table so that my list "does not contain" a
key word? I am not sure how the expression should look and my attempts at
researching a solution have failed. Can I filter on a keyword or does it have
to be an exect match? i.e. I want to eliminate all records that contain the
word "Administrative"
[dbo_MSP_EpmTask]![TaskName] «Expr» Not "Administrative" ?
...
|
4 |
12/18/2008 10:48:51 PM |
|
|
Command buttons to switch between forms
I'm trying to use a command button on each of 2 forms to enable the user to
switch back and forth and the click of a button. The code I'm using is:
Private Sub GoToCMDM_Click()
DoCmd.OpenForm "frmCMDMSearch", acNormal
DoCmd.Close acForm, "frmCMLabelsDataEntry", acSaveNo
End Sub
Private Sub GoToCMLabels_Click()
DoCmd.OpenForm "frmCMLabelsDataEntry", acNormal
DoCmd.Cl...
|
4 |
12/18/2008 8:08:14 PM |
|
|
select into overwrite table
how can i automatically overwrite an exisitng table when i execute a select
into make table sql statement?
tia,
mcnewsxp
...
|
4 |
12/18/2008 7:49:02 PM |
|
|
Import data to drop down list in another excel file
I've been reading on how to create a drop down list, and name it, but I can
only get it to work in the same document that I typed the data for the drop
down list. It says I can import that list into another document if I name it
and put "=name" in the function box, but it's not working. Any suggestions?...
|
3 |
12/18/2008 5:41:01 PM |
|
|
Field value as default on subform
How can I make a value on a form the default value on a subform?...
|
8 |
12/18/2008 4:46:48 PM |
|
|
printing labels
Malcolm P. entered the following steps to make it possible to print labels.
"In Word, go to: >Tools>Letters and envelopes>mail merge.
Select >labels..................."
I get as far as "> Tools", and then have a problem. The next step is
"Letters and envelopes". I get "Letters and Mailings". I've played around
with it but no luck.
Would you please go through the pr...
|
2 |
12/18/2008 2:46:01 PM |
|
|
Need to create a search based on a specific field
Okay so I am really new at all of this and I will try to explain as best as I
can as I would appreciate the return of information in the same matter (dummy
terms). On my form I need to create a text box that allows someone to do a
search based on one of my fields in my table. I actually need 2
searches...one for each. I have a memo column and a account number column in
my table. I wo...
|
4 |
12/18/2008 11:02:35 AM |
|
|
Form/Subform
I have a form that displays a subject and a subform that is supposed to
display all incidents related to that subject. I have tried several ways
including creating from the wizard and drag and drop but the info displayed
never seems to be right.
What is being displayed if I relate the subform to the subjID (autonum) is
only one incident instaed of every incident.
If I relate the Subf...
|
23 |
12/18/2008 5:51:01 AM |
|
|
how do i remove a "replica"?
I have a database that I'm trying to fix, when i open it up, there are
duplicate tables in it with a "1" after them. I copied the datbase to a
different directory so I wouldn't work on the production one, but it comes up
with 'replica' at the top, I can't seem to link the front end to the back
end, it seems to link it back to the original database.
how can i remove the duplicate tabl...
|
5 |
12/18/2008 4:08:01 AM |
|
|
Re-setting numbering
I posted the following question to the wrong Access group. My apologies!
We have 35 controlled documents that are issued throughout the year,
generally in packages of 10 to 25. Each controlled document has its own
control number, which is set by the database based on date of issue. So, for
document "Walking" the first package of 10 issued in 2008 had numbers 08-0001
through 08-0010...
|
6 |
12/17/2008 9:51:02 PM |
|
|
Use a current record to enter new data but keep the old data
I have a database that holds all of our clients information and I have a few
that have duplicate information except for the file numbers for example. I
need to know if there is a way to pull up that information & use as a
template to start a new file. I have thought about having a separate table
holding the name & address information and then an other one that has the
file numbers. I ...
|
7 |
12/17/2008 12:21:43 PM |
|
|
Report/Invoice numbering convention
I've created a invoice numbering system based on a combination of the current
year and week number plus a 3-digit consecutive number. The format is
YYWW###. Starting today, the report number will look like this; 0849000,
0849001, etc. On the following Monday the week would change to 50 and the
report number would be as such; 0850002, 0850003, etc. Come January 1st,
the first report...
|
11 |
12/17/2008 9:19:20 AM |
|
|
List box in subform
I wonder if there's anyone else out there working on a database on a Sunday
afternoon (again).
I have a main form Event and a subform EventJobTitleStatus. At present I
have a combobox on the subform for the JobTitle and another for the Status
and this works fine. But really as I have to put the event Status against
every job title (and there are lots of them) it would be better if I had...
|
12 |
12/17/2008 6:20:41 AM |
|
|
Using different versions with several users
Im in a small office where the users are on several different versions of
Access. Some are using 97, some use 2000, and some use 2003. I need to build
a database, and I want to be sure before I start that everyone will be able
to use it. Do I need to build it in the earliest version that we use (97)? If
I were to build it in 2000 would everyone be able to use it? I plan to set it
up as split ...
|
7 |
12/17/2008 3:32:18 AM |
|
|
Runtime Error 2465
I am trying to use a query (q_OpSupSecurity) with a 'IsNull' to limit input
to a textbox. The query is based on a table where Operators =1 and
Supervisors = 2. The query is acting as a filter to remove values that
shouldn't be allowed into this textbox.
I get a "Microsoft Office Access can't find the field '|' referred to in
your expression" error when I try to run the code. How el...
|
12 |
12/17/2008 1:07:48 AM |
|
|
Two databases open at once.
I have two databases in Access2003 with WindowsXPpro.
Is there anyway to have them both running at once side by
side on the screen?
Please help, Frank
...
|
3 |
12/16/2008 10:55:54 PM |
|
|
How do i unhide a table in MS Access?
i hid a table in Access and i cant unhide it. how do i find it to click
'Unhide'?
...
|
3 |
12/16/2008 6:26:04 PM |
|
|
Form involving multiple parents and one child
Hi, I would be grateful if someone could help:
I have 4 tables. 3 of these tables (tables A, B, C) have a one to many
relationship with the fourth table (table X).
In each case, table A, B, C form the one side of the relationship and table X
forms the many side of the relationship.
I am confident about setting up a single table (A,B or C) as the main form
and using table X as the subfo...
|
2 |
12/16/2008 5:31:02 PM |
|
|
Formatting number columns in a report
I have a report that is based on a rather complicated query. Some of the
columns in the query are calculated values with a lot of Case conditions.
When I put these columns on a report I don't have any formatting options.
Some of them display correctly with commas and two decimal places while
others only display the number and rounded decimal amounts. I have tried
typing in my own for...
|
6 |
12/16/2008 4:24:01 PM |
|
|
Can I do this in Access? Please help
The basic idea is that I have to send letters 5 times a year at 1, 3, 6, 9,12
months from Date of death of the person.
I need to set it up as follows:
Deceased Name Date of Death Caregiver's Name Address(City-State-Zip).
The letters are slightly different from each other(based on length of time
since death, ie, 1 month, 3 months, etc(I would need to store 5 letters).
This data ba...
|
29 |
12/16/2008 12:31:18 PM |
|
|
List Box in Contact Details
I am using Access 2007 and created a list box for my contacts under Contact
Details. When I use the list box to select a different contact, I would like
the screen to switch over that person's information. So far, all I have is
the list box, but I am not being directed to a new details screen for the
next person. Please HELP....
|
2 |
12/15/2008 10:10:26 PM |
|
|
POP3
I just got my computer and am trying to connect my yahoo.com mail to windows
mail. I've tried to go to tools, account and follow the process but am doing
something wrong because it isn't working. Can anyone help me?
Linda
...
|
2 |
12/15/2008 9:23:31 PM |
|
|
duplicate record in forms
I have created a database for a web order company. I have a very simple form
with 2 pages (tabs). Each page contains 1 "sub-form" (which is actually a
table). The first page contains Customer Information with a "Notes" sub-form
for notes on that particular customer. The second page contains that
particular customer's Order History.
I am having 2 problems. When I enter the customer's...
|
3 |
12/15/2008 7:11:01 PM |
|
|
How to count total Students in database
Happy Holidays Everyone! I know this is written somewhere and I've several
inquiries that were answered, but not sure which answer to select for my
problem.
I have a Student Database. I created a form using a query from the Student
Table. I created fields within my form that say "Total Requests", "Pending
Requests", and "Completed Requests". How do I write code, or do I even write
...
|
2 |
12/15/2008 3:10:39 PM |