|
Date Order
Is there a way to take a row of information in a qurey and put it in date
order.
For example I use Travel Authorization numbers for each trip a traveler goes
on. I log in there trip information based on Date the Credit Card was run
and what the purchase was and the amount. So each piece of information is in
a new field but same record (you could say, I made a form) Now After I enter
...
|
17 |
28.09.2006 18:54:44 |
|
|
How do I delete an attachment gif that automatically is sent with
Each time I send and E-mail an attachment gif. (oo1.) is sent along as well.
It appears beneath the subject line to my recepients. I do not see it at
all. How do I clear it?...
|
3 |
28.09.2006 18:50:01 |
|
|
Append table from Complex SQL in Access 2000
I am not having any troubles appending data to a table using the
following SQL in Access 2003. However, when I try to run it in Access
2000 I get the 'Run time error 5": Invalid procedure call or argument'
I don't understand what is going on.
1st query
INSERT INTO TempHoldforEOM ( Field8, Field11, Field4, Field5, Field6,
Vendor )
SELECT [StringExtract-Concatenation].Field8,
[StringEx...
|
6 |
28.09.2006 18:47:29 |
|
|
jpeg as long binary data
In a database I have there is a table that stores images as long binary data
type. How can I view the images in a form? Do I have to do some kind of
conversion before I can view them? I am stumped by this problem. Any help
(anything at all) is gratefully recieved...
|
7 |
28.09.2006 18:16:51 |
|
|
1)VB code or Wizard? 2) Subform or filter? 3)combo box problem
I am a new user, I wish i can get some answer over here, I think it is easy
but i really new and know nothing.
1) Using wizard to create database or VB code ? Which 1 better? and Y?
2) I using wizard to create a form c/w subform as per below
Main Form
[YearMonth] : 200609 =>[YearMonth] is a field from table period
Subform
[Transaction]
(detail or all fields from tabl...
|
6 |
28.09.2006 18:04:24 |
|
|
too many selections
I have a fields in Access 2003 labeled hsize, which holds the number of
people in a household. I have another field named hincome, which holds
the total annual income for that household. I am trying to develop a
calculated field in a query that will match up to a chart I have, which
shows for each size household ( 1 though 8) the median income for that
size of household, and then depending ...
|
4 |
28.09.2006 17:38:15 |
|
|
Creating an "email" Merge
I have created an Access Database. In the database I have a field titled
"email address". I wish to use MS Word send an email using it's mail merge
feature to all the addresses listed in this field.
If I have one email address in the field: IMATEST@Gmail.net
The program works fine.
But, I wish to have MS Word send it to multiple address at the same time.
The database field l...
|
1 |
28.09.2006 17:08:02 |
|
|
pdfs in a librry
is it possible to create a database that holds information that is in pdf form
the idea is to search the library(data base) for a particular pdf and then
go to it...
|
2 |
28.09.2006 17:04:10 |
|
|
Form Data Entry Through Coding
Hi All,
I am trying to make this code work, but every time I get to the
TORDERNUMBER.SetFocus line it gives an error. I believe it is throwing the
error because the code is still trying to work in the original for and not
the form that I opened to edit a second table. Any ideas on how to get this
code to work with the opened form and not the original form?
Thanks,
Dave
ORDE...
|
1 |
28.09.2006 17:00:47 |
|
|
convert field to hyperlink
Hi I would like to convert my email & web address fields to hyperlinks. How
do i do this without losing data? Do I need to go through my current data and
add http:// or mailto: to each record?
Thank you!
--
kathyg...
|
2 |
28.09.2006 16:51:08 |
|
|
How to: Customize a Toolbar to launch an Addin
Does anyone have any suggestions?
TIA
Rob
...
|
6 |
28.09.2006 16:16:15 |
|
|
export XML data from reports with subreports
Hi all!!!
how can i do to export data from reports with subreports or multiple query
in xml format???
Thanks
Fred....
|
1 |
28.09.2006 16:12:02 |
|
|
changing units of measurements in Access
Help!! I've been trough the program several times and cannot find the feature
to change the program from metric to Inches. I can do it for word and so on
but have had no luck in Access
Cheers DCW...
|
2 |
28.09.2006 16:03:25 |
|
|
periodically renumbering records after appending new records
I have a large database (>100,000 records) of individual webpage views
for on 100 different PCs on a network. The records include pageID, PC
ID and a time/date stamp. The records are sorted first by PC ID then
time/date. I need each record to be numbered sequentially. Though I
managed to do this on the first set of records, when I append the
database with a new month of records then re-s...
|
4 |
28.09.2006 15:46:10 |
|
|
periodically renumbering records after appending new records
I have a large database (>100,000 records) of individual webpage views
for on 100 different PCs on a network. The records include pageID, PC
ID and a time/date stamp. The records are sorted first by PC ID then
time/date. I need each record to be numbered sequentially. Though I
managed to do this on the first set of records, when I append the
database with a new month of records then re-s...
|
3 |
28.09.2006 15:31:32 |
|
|
Evil hyperlinks ....
I have split my database into front and back-ends, with the intention
of sharing on the company network. Now - originally, I had both
'parts/bits' on my P:\ but now need to install a front-end on each
users own pc (C:\), to prevent the database being corrupted (so I'm
told).
However, now that I have installed a front-end on my C:\ (to test
before installing on others machines) all my hyper...
|
10 |
28.09.2006 15:29:32 |
|
|
keyboard characters keep changing
Periodically my keyboard characters change so that what I type is not what is
being printed on my Outllook email. Please help!
I have a Microsoft keyboard. I know I must be hitting some key
inadvertently; but I can't figure out which one(s).
Thank you in advance....
|
6 |
28.09.2006 15:27:38 |
|
|
problems importing data from excel spreadsheet
Hi,
I'm using Office 2003.
I'm trying to import a data table from an Excel workbook into an Access db.
When I navigate to the XL doc and click through the dialogue box I get an
error message:
"The wizard is unable to access information in the file [filepath]. Please
check that the file exists and is in the correct format."
The file does exist, as I can open it in Excel. And the...
|
1 |
28.09.2006 15:22:01 |
|
|
How to create a login system
Hi. I wnat to create a login system. I want to have a table with usernames
and passwords. I want to determinate that user A can access to form 1 and 2
and can print report 1 and 2. I wanto to determinate that user B can access
to form 1; 2; 3 and 4 and also can print or preview report 1; 2; 3; 4; 5. And
off corse the admin user.
This works with levels right? I can I do it?
Regards,
...
|
2 |
28.09.2006 15:20:01 |
|
|
How do I link a specific Excel worksheet in Access in a macro?
...
|
1 |
28.09.2006 15:10:02 |
|
|
Send email to group of contacts
I am using the following code (from Ron Hughes code to send email to
all database at
http://www.rogersaccesslibrary.com/Otherdownload.asp?SampleName='CodeSendEMailToAll.mdb'.
When clicking the command button, I click on Yes when prompted to
create a new table but at the end the error message "Invalid use of
Null" is displayed. Can anyone help?
Private Sub SendEmail_Click()
Dim str...
|
1 |
28.09.2006 14:50:14 |
|
|
Back end and front end
I splited the database with the access options. Now I have two access
databases, one with the data and other with linked tables, queries, forms,
reports and macros.
I put the back end part in a server and the front office is acceced in each
desktop. the front end has 1.7mb and the back end 700kb. In my opinion this
is too small, but it seems that the database it's very slower, what I m...
|
2 |
28.09.2006 14:46:06 |
|
|
could someone please help i have lost my password for access 2000
when trying to access my files and being prompted to logon , in the name
field admin appears by default but i cannot enter any password in this field
as i have lost it....
|
2 |
28.09.2006 14:27:02 |
|
|
Group Policy preventing object design?
I have a problem that when I am authenticated on my network (where I am
in charge of Group policy and can edit the administrative templates),
right clicking on a form or report object and selecting design or
selecting view 'design view' from an open form or report has no effect.
If I am logged into the local machine and not on the domain, Access
behaves normally. I can't see any setting in th...
|
2 |
28.09.2006 13:58:08 |
|
|
IIF QUERY SYNTAX QUESTION IN ACCESS
I have a query like
sum(If location = 'USA' or Location = Canada and date > date() or date
is null
then 1, 0)
how do I write this statement correctly in access
sum (IIF ( (location = 'USA' or location = 'CANADA' ) and (date
>date() or IS NULL (date)) , 1 , 0 ))
does not works in access. Is there a way of doing this correctly in
ACCESS.
...
|
6 |
28.09.2006 13:53:15 |