|
Consolidating fields in Acces
I have imported data from an excel spreadsheet into Access. In one field
there are multiple occurances of the same entry-eg "cottonwood estates" the
field next to that contains date for this entry. I am trying to have all the
date for "cottonwood estates" to be added together and be on one line in a
report or pivot table or table. Is this possible?...
|
2 |
25.09.2006 23:08:05 |
|
|
"Enter Parameter Value" error
I am working on normalizing a database that has a switchboard that leads to
multiple forms that have individual queries behind them. Each query (and in
turn, form) uses many of the same fields; however, the designer created a
different field for each query. For instance, instead of just "Amount",
there are 8 different Amount fields (one for checks, one for wires, one for
posting docume...
|
5 |
25.09.2006 22:55:02 |
|
|
Making a TOC
When I try to create a table of contents I receive the following error message.
A table of contents does not exist.
What am I doing wrong?...
|
2 |
25.09.2006 22:24:56 |
|
|
Problem with color when printing code sheet
Hi,
I've got a problem and I'm not sure how to solve it ... so I'm hoping that
one of you might had the same problem and know the answer.
When you create and/or modify software on Access (office XP PRO) you have
different color in your code : Black = standard writing, Bleu = Built in word
(ex: Dim, as, If ...etc.), red = can be use for break point, green = comment
.... etc (Of cours...
|
1 |
25.09.2006 22:16:02 |
|
|
Using forms with tables or queries
I am in the design phase of tracking system in Access. A relational database
has been modeled (includes eight tables) enforcing referential integrity
where ever applicable. In this system there will be a form for data entry.
The data entered into this form will actually be inputing data into four
tables since I have three different instances where a one-to-many
relationship could be f...
|
3 |
25.09.2006 21:55:45 |
|
|
how do I remove "#deleted" record that keeps reappearing ?
I deleted a record from a table, closed the table and on reopening it found
that the record came up as "#deleted". I deleted all relationships with other
tables and eventaully deleted the other tables. Still #deleted displayed in
all the controls for the allegedly deleted record. Please help!...
|
10 |
25.09.2006 21:48:54 |
|
|
using a form to search database and print report
Could someone suggest a way to do the following:
Open form
Type Name
Lookup name
Print all records matching that name from
query or table.
I've created the report for the complete query(All names in table). I
would just like to limit the scope to whatever name I need fo...
|
9 |
25.09.2006 21:33:57 |
|
|
Command button with 2 possible outcomes?
I have a field (called 'origin' )on a form which can be one of 2 values
'Internal' or 'External'.
I want to to have a command button which opens another form, but different
forms depending on whether the field is 'Internal' or 'External'.
How can I incorporate this into ONE command button, such that, If
origin=Internal then open frmInternalMail, or If origin=External then open
frmEx...
|
4 |
25.09.2006 21:28:27 |
|
|
Query/Form question
Hello,
I have a table with questions, and I have a table with categories, so that
my questions can be sorted by category. A third table references the
questions via an ID field, and provides a field for a reply. This 3rd table
has the fields RespondentID, QuestionID, Answer. This setup lets me record
every respondent's answer to a multitude of questions.
My problem is in creating a for...
|
4 |
25.09.2006 21:27:01 |
|
|
screen refresh
Is there anything in Access VB world similar to screenupdate = false in Excel
where I can just have the screen not update while I'm running my macro to
speed things up and make it look prettier?
Thank you!...
|
2 |
25.09.2006 20:41:14 |
|
|
Mail as primary key
I did not manage to define a text field (representing e-mail adresses) as the
primary key. Is it possible. All the values in this field are unique (no
duplicate).
I'm working on office 2007
Thank you...
|
2 |
25.09.2006 20:16:02 |
|
|
How to Remove Applications Distributed w/Access 2003 Developer Ext
have developed an application in access for one of my clients. I used the
Access 2003 Developer Extensions to package and distribute a runtime version.
He lost his install cd and now he can not uninstall the application. When
he tries to go through the control panel it is asking him for the cd. I
tried sending him a new cd but that did not work. Is there a clean way for
him to uni...
|
3 |
25.09.2006 20:05:31 |
|
|
SPLA licenses
In a hosted envioment, do we need two licensees for each user connecting
to a remote desktop on a windows 2003 server?
I case of two licenses I wood use both a SAL and a TS SAL for each user.
Best Regards
Martin...
|
2 |
25.09.2006 20:00:49 |
|
|
Query with current form data in access 2003
How do I perform a Query of a table using data that was manually entered in
the previous field?
For Example:
The first field is a shortname code for the material. I would like the
second field to do a query of the material data in the database to bring
back the material long name.
Thanks in advance for any help.
...
|
5 |
25.09.2006 19:43:53 |
|
|
Access Switchboard problem.
I'm running Access2003 on an XP computer, with DirectX 9.0c and using an
Access 2002-2003 file format.
I've built a two form Switchboard that currently accesses two forms, and
will later access more items.
After creating the Switchboard, I try to run it by clicking on the
switchboard form in the forms list. The first time I try I get the following
error:
Run time error '429':
Act...
|
4 |
25.09.2006 18:42:01 |
|
|
Counting Months
Hello,
I am trying to create a report that will give me the total number of quotes
submitted for the month of January, February, March, so on. My table lists
the date the quote was submitted and the value. Any help is appreciated.
Thanks
Mark...
|
10 |
25.09.2006 18:40:43 |
|
|
Make-table queries for Web?
Hello All, I'm using MS Access 2003 for a web DB... Am wondering.. is it bad
to use Make-Table queries for the web..? Or should I just do all the SQL
joining and linking stuff just with more SQL code?
Just curious about the impact Make-Table queries have on the Web.. Slower?
Not a good idea?
Thanks for any input you can give
John ...
|
2 |
25.09.2006 18:15:28 |
|
|
spacebar reset
In access, how do I reset the spacebar? It now performs a tab function when I
am filling in fields in a form....
|
1 |
25.09.2006 18:10:01 |
|
|
Multiple Criteria Search
I have a form where I have a search set up by 5 different criteria using
combo boxes. The search works when I use all five criteria. Is there a way
to set it up so where I could search by using only some of the 5 differerent
criteria set up?
It's a database for a staffing agency doing searches for potentials matches
to job openings. Criteria's are: Job Title, Years Experience, Edu...
|
2 |
25.09.2006 18:00:01 |
|
|
Comma Delimited
I am a newbie:
How do I import Comma Delimited files into Access?
How do I create Comma Delimited files from Access?
Thanks
--
A MACKENZIE, CMA, MBA...
|
3 |
25.09.2006 17:24:25 |
|
|
Retrieve Email address query
Hi all,
need to run a query on a table that only shows email addresses have tried =
@ etc but no joy. Mixed data in field doesn't help.
Regards
Simon
www.thegaregroup.co.uk website: www.privatehiresolutions.co.uk The Gare
Group Ltd Saverstores UK Ltd Private Hire Solutions Ltd EPrivateHire Ltd So
Good at IT ltd This email, and any attachment, is confidential. If you have
recei...
|
5 |
25.09.2006 17:23:27 |
|
|
Auto dating a text field in Form
Hi,
I created a two columns for my tables. I want to be able to query to find
out who entered the data using the form and when it was entered so I can
query to find out how much data was entered into the system and make sure the
data are entered correctly.
1. Updated By
2. Updated Date
What I want to do in this form is basically auto date the empty text filed
of the form when u...
|
2 |
25.09.2006 17:15:01 |
|
|
Access Runtime Uninstall PLEASE HELP
I dont understand why this has been posted so many times but there are
so few answers?
I have developed an application in access for one of my clients. I
used the Access 2003 Developer Extensions from Visual Studio for Office
to package and distribute a runtime version.
He lost his install cd and now he can not uninstall the application.
When he tries to go through the control panel it ...
|
1 |
25.09.2006 16:32:23 |
|
|
Document Tracking Database Design
I had thought I posted this query last week, but I was using Google
Groups. Something tells me that it did not work as expected. If this
is a repost, I apologize in advance. I also apologize for the length of
this message, as I am going into detail as to the design of the database
I am working on.
Generally speaking, the database is a document tracking database for an
auditing and ...
|
1 |
25.09.2006 16:11:55 |
|
|
Creating email in Access
I have the following code which creates an email from Outlook.
Private Sub Command20_Click()
Dim mess_body As String
Dim appOutLook As Outlook.Application
Dim MailOutLook As Outlook.MailItem
Set appOutLook = CreateObject("Outlook.Application")
Set MailOutLook = appOutLook.CreateItem(olMailItem)
Set appOutLook = CreateObject("Outlook.Applic...
|
3 |
25.09.2006 16:10:27 |