|
Export: use SendObject or Transfer?
I am trying to automate exporting data and emailing it to another branch to
import it.
I can use TransferText to Export to a file outside the database but can't
use SendObject to email it.
So I have been trying to use SendObject in XLS format. It sends the data in
spreadsheet format which is fine, but when I import it at the other branch
through Transferspreadsheet, it includes the head...
|
3 |
12/25/2008 6:05:00 PM |
|
|
This discussion forum problems
Sorry to post this problem here, but I have been unable to reach the
responses to the two messages I posted before. One is about using a form
field for e-mail addresses to activate Outlook with a new message ready to go.
The other message was again this problem of the links I'm being sent by
e-mail not working. I've tried lifting them out of the source code and
posting, but that doesn't...
|
2 |
12/25/2008 5:50:35 PM |
|
|
im new
Hello, i am call Hollie Lewis, i am new here so i wold like a friend,
would anyone like to be my friend. if you would please write back
so that i know who you are. i also need some help so if you have
any idear please help
...
|
2 |
12/25/2008 4:30:15 PM |
|
|
date manipulation
i DONT SEE THE ANSWER
--
golani...
|
1 |
12/25/2008 7:40:00 AM |
|
|
Having a problem updating Access forms
I am newbie running Office 2007. My problem is with an Access DB in 2003
format that includes some linked SharePoint tables. I can update a form in
design view and apparently save it. However, when I try to close the
database I get the message “Do you want to save changes to the design of form
‘frmName’?†If I respond “Yesâ€, I am returned to the form but the database
does...
|
2 |
12/25/2008 4:39:49 AM |
|
|
Splitting the database
When I split the database, I'm specifying a back-end location of
\\server-name\sharename\MyDatabase_be.accdb. Does that UNC get stored in the
front-end copy so that when it gets deployed the users will be able to
connect to the back end? Thanks for any help on this....
|
6 |
12/25/2008 2:20:01 AM |
|
|
Question about tabs...
I know that Me!TabCtl01.Value provides the page number (index) of the tab
that was clicked.
I can use a Select Case construct to process activities based on the tab
that is active.
I have a dialog that (for now) will only work in a "forward" direction. I
need to find someway of preventing the user from going "backwards".
Is there any coding technique that will let me know which tab...
|
3 |
12/25/2008 1:57:45 AM |
|
|
List Box Filter Question
On my form I have a un bound text box [InvoiceID] and in my List box I have
all Invoices with the same [InvoiceID] how do I filter InvoiceID as it will
show the same as my Form Opened
--
Thanks in advance for any help with this......Bob
MS Access 2007 accdb
Windows XP Home Edition Ver 5.1 Service Pack 3
...
|
4 |
12/25/2008 1:44:29 AM |
|
|
Report Preview locks up
Sometimes when I open a report in preview the hour-glass starts to jiggle
then rapidly alternates with the cursor. Nothing else happens. If I click
on anything the whole program locks up and I need to Ctrl Alt Del to get out.
This can happen all of a sudden on a report that has been working fine for a
long time. If two users run the same program, the report can be fine for one
but not ...
|
2 |
12/25/2008 12:51:46 AM |
|
|
Report Data
i'm reposting this question from "fields" b/c I can only see the original two
posts the other replies are not showing up...they were there and now there
gone???
trying to create a report from:
tblStudent (list of students)
tblSubject (list of subjects)
tblStudentSubject (list of which student is recommended for which class)
tblStudentSubject contains studentID and subjectID. when i r...
|
2 |
12/24/2008 11:45:08 PM |
|
|
Merry Christmas to all who have helped me throughout 2008!!
...
|
1 |
12/24/2008 9:39:01 PM |
|
|
Help with this forum
I posted a message dealing with and Email field in a form -- to click on it
and have it open a new Outlook Message.
I got a notice that there was a response, but the link doesn't work. I've
been searching for hours tring to find my message in every category with no
luck. The link mentions "table design", but there seems to be no such
category here.
Please help me before I become lost...
|
2 |
12/24/2008 9:27:59 PM |
|
|
Report Help
Hi,
I created a report (pasted some of the titles below) and everything listed
below except "Total Initiatives only Prioritized Projects" comes from the
same select query. How can in Access Reports modify in the properties (or
wherever) so that I can have the fields look at different queries?
Mike
Some of the titles:
Project Name - Project ID - Requesting Business Unit - Requesto...
|
2 |
12/24/2008 8:07:50 PM |
|
|
Access Select Query Count
Hi,
I have a select query and I dragged in "Project Phase" as a field and
"Project Phase" has 4 major catergories for each project: Project in
Progress, Project in Review, Project Complete and *IT* (with various other
stages such as; design, development, migration and et cetera).
What I want to do is - I want to create 1 select query that shows the count
of projects in each phase....
|
4 |
12/24/2008 6:53:00 PM |
|
|
Self joined table in a delete query
I am attempting to delete duplicate records of the same table, where they are
only different on one field, by making a duplicate of the table, and doing a
self join in a delete query. The query is unable to determine which copy of
the table to delete from. How do you specify which table to delete from
either in design view or in SQL?...
|
3 |
12/24/2008 6:47:57 PM |
|
|
hyperlink doesn't work in a report
I have a hyperlink to an image in my database. In the report, the page where
the hyperlinked image should be is blank. I read on microsoft's web site
that hyperlinks don't work in reports. Any help would be appriciated. thanks
--
jmb...
|
3 |
12/24/2008 6:36:01 PM |
|
|
Self Join Table in a Delete Query
I am attempting to delete duplicate records from the same table, where there
is a difference in only one field. I have a self-joined table in a delete
query. How do you designate, either in design view or in SQL, the table from
which to delete the records, as in this instance there is two copies of the
same table....
|
2 |
12/24/2008 5:31:49 PM |
|
|
fields
i have three tables:
tblStudent (list of student names)
tblSubject (list of classes)
tblStudentSubject(list of selected student and subject)
form:
cbo for list of students. when i select a student, the student id #
(primary key) is added to a field in tblStudentSubject, however, I want to
write the actual name to the table. i specified the control source for the
name field in tblStu...
|
7 |
12/24/2008 4:52:01 PM |
|
|
Using access VB to add columns in Excel
I am building a spreadsheet that is an order form for my client's customers..
Access 2007 stopped outputting columns with formulas so I need to be able to
add some formulas to an spreadsheet using an Access Module..
Can someone direct me to a tutorial on how to (using Access VB) open an
existing Excel worksheet to ..
1. create a column in excel that extends 2 columns (Quantity & Price...
|
1 |
12/24/2008 4:13:02 PM |
|
|
mouse scroll keeps scrolling through records want to stop
I am trying to disable the ability of accidently using the scroll on the
mouse in the ID field. Can anyone help me?...
|
2 |
12/24/2008 4:05:56 PM |
|
|
Primary key lost
Hi,
It happens that some problems occur in my database then when i open the
be i receieve the famous error message "This databasee is in an
inconsistent...", then i compact and repair the be i get another message that
says that i should check the tables...
When i check the tables i find out that all primary keys are lost, so i
should do them again.
Do we have any solution for...
|
11 |
12/24/2008 5:22:30 PM |
|
|
Excel "IF" formula
I'm trying to make a formula which will recognize if the cell above is empty
to use the cell above that one, then the cell above the second one, etc., and
finally if all cells have values in them to take the first one above the one
your working in. I've come up with the following formula and it works fine if
the G35 is emtpy, it finds G34. But if both G35 & G34 are empty it doesn't
find ...
|
5 |
12/24/2008 8:14:44 PM |
|
|
If yes enter zero if no enter result
I have a field "tax Exempt" which is a yes/no expression. What is the code
to have the [amount subject to tax] if the tax exempt field is a "yes" I want
the [amount subject to tax]to be Zero, if the tax exempt field is a "no"I
want the field to run its expression
enter a zero. Isn't it something like ; If taxexempt is yes enter zero
otherwise enter amount subject to tax.
Below is the...
|
10 |
12/24/2008 8:34:57 PM |
|
|
Main Form / ListCount Problem
On my Main Form that stays open I have a list box [lbTaxChange] that is
based on a query it is not Visible but I have another text box that is
visible showing how many are tax Changed.
=[lbTaxChange].[ListCount]
When I go to another form and change the Tax, because my main form is still
open it will not refresh/requery the List box until I close my db and re
open it
--
Thanks in adv...
|
15 |
12/24/2008 11:19:18 PM |
|
|
Date reformatting
I have a file that has a date in YMMDD format. I wish to change it around
and then query on just the data in a MM/DD/YYYY format. I have been working
with Format and DateSerial but I cannot seem to get all my ducks in a row.
Any assistance would be greatly appreciated!!!!
...
|
6 |
12/25/2008 12:21:31 PM |