|
Populate field in one table with data from field in another table
Access 2003, Windows XP sp2
Problem:
tblJob has a "Cost Center" field. tblInvoice has a "Charge To" field.
I want the tblInvoice field "Charge To" to automatically populate with the
information in the "Cost Center" field in the tblJob.
These tables are related by a mutual primary key but neither of these fields
are related and neither field is a primary field.
Is there an easy way...
|
7 |
22.09.2006 19:25:02 |
|
|
Query - Listbox
On one form, I would like to have an option group to select one of
three queries to run, then have that query's results displayed in a
subform in datasheet format. I can get the queries to run, but I can't
get them to display in the listbox (they appear in popup windows). Any
ideas?
...
|
3 |
22.09.2006 19:20:01 |
|
|
Access & RAM
I'm experiencing problems at work with my PC constantly 'Not Responding'
when in Access, working with & querying large data sets. The PC is new, a
3.00 Ghz Pentium 4 HT, but with only 512MB of RAM.
I'm experiencing similar problems in Excel, when working with large data
sets. I'm making every effort to ensure the databases, queries & Excel
files are designed as efficiently as possible...
|
8 |
22.09.2006 19:04:02 |
|
|
Carry Data From one form to another
Hi there,
My question is regarding the transfer of data from one form to the
next. On form 1, there is a button that allow you to open form 2 to
view some addtional information about the selected Item.
When form 2 opened. I want some of the information from form 1 to
transfer to the respective fields in form 2. So I used the following
procedures
(1) When click the open form 2 butto...
|
5 |
22.09.2006 18:45:01 |
|
|
Repost-Hyperlinking the database to photo files on a network drive
I posted this earlier but received no response. Hopefully someone will have
some ideas about this problem.
I am creating an Access database to categorize digital photographs. I only
want the
file names in the database and not the actual images (which are located on a
network drive). I would like the file name to be hyperlinked to the image
so when clicked upon the image is displayed. ...
|
6 |
22.09.2006 18:28:12 |
|
|
Why do files in database disappear?
Our database stores personnel information for approximately 23,000
individuals. On occasion, complete files disappear. We are pretty sure that
none of us are deleting these...why would we when so much of what we do is
dependant on this information?...it makes more work for us. Has anyone had
this problem before?...
|
8 |
22.09.2006 18:25:25 |
|
|
Repair Database
I sure hope someone can help me with this - I have designed a database that
over the last couple weeks has been working fine. All of a sudden today it
seems like nothing is working right. The users that are in the database are
getting kicked out of it for some reason, which I can't figure out and then
it is telling them that the database needs to be repaired. This all happens
while ot...
|
3 |
22.09.2006 18:13:18 |
|
|
Setting rowsource for Combo Box
I'm using the following rowsource query to filter a combobox
SELECT Products.ProductID, Products.ProductName, Products.PartNumber,
Products.UnitPrice, Products.ModelNum
FROM Products
WHERE (((Products.ModelName)=[Model]));
Model is textbox on the form
This works fine to filter the list to a specific Model but if the
Model is Null the combo box shows no records. How can I alter the
...
|
3 |
22.09.2006 18:05:24 |
|
|
Seen this post on another forum, Curious how you would do solution
I seen this post on another forum on Access.
Sounds like an appointment database for a DR. or other professional.
Lets say your open for business Mon-Fri from 9AM to 5PM for example
excluding holidays.
You take appointments starting at 9AM and break for lunch say from 12-1. in
30 min increments.
1st Question: could you auto populate your database in a table with your
time schedul...
|
3 |
22.09.2006 17:55:02 |
|
|
access vs works
are there any essential differences between access 2003 and works 7 database?
i am doing a college course that includes database/access and on a students
income i don't want to purchase access 2003. i have windows xp and office
2003 student/ teacher, therefore i don't have access but i do have works 7.0.
kind regards...
|
5 |
22.09.2006 17:46:08 |
|
|
Win Amp Etc. John Vincent
John,
I have the MP3 Database Up and running perfectly, Even the kids have been
using it. I also added a feature that I talked to you about establishing
different playlists for users.
Also, I expanded on the database you helped me with. I downloaded the
latest version of winamp. Changed the database around so that it plays Music
Videos, movies, etc. Ran into some minor glitches b...
|
3 |
22.09.2006 17:19:02 |
|
|
TransferSpreadsheet Question
When using TransferSpreadsheet, is it possible to use wildcards in
identifying the import file name?
I'm assuming no, but figure it wouldn't hurt to ask.
Thanks.
Sharkbyte...
|
2 |
22.09.2006 17:07:38 |
|
|
Access2003 exclusive access warning with Adobe Toolbar
I have a few users with the Adobe Toolbar getting the
"You do not have exclusive access to the database at this time" warning
message when they open my Access2003 application. This did not happen until
the toolbar was installed.
The error persists when they click OK but after a few times the Access2003
application opens and runs fine and the warning does not reappear until the
Access2...
|
7 |
22.09.2006 16:16:03 |
|
|
Conditional Formatting
I'm sure this has been said before, but how about more than 3 conditions in
conditional formatting?
----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web...
|
3 |
22.09.2006 15:43:02 |
|
|
Hyperlinks to files
Does anyone know how to import regular file names into a hyperlink table
automatically? I am trying to creat a table with hyperlinks to items that
reside on a different drive. I can do this manually but I'd rather have it
so that I can select an update button on a form to update the hyperlink table
with the files added to the drive (the file name not the address, so that
users can quer...
|
3 |
22.09.2006 15:41:01 |
|
|
Compact on close
I wish to regularly compact a linked mdb file and I have found a few sample
solutions for this.
However in Tool/Options/General there is the option to compact on close.
Is there any reason to not use this? My linked file would be about 15mb
after compacting.
Thanks in advance....
|
3 |
22.09.2006 15:33:29 |
|
|
Event from Calculated Control
Can someone explain why this isn't working and what I need to do to make it
work. I have a form with three fields that need users to input a number value
and a fourth field on the same form which calculates the average of the three
values the user inputs. This works fine but I want a message box to appear
when the calculated average in the fourth field exceeds a certain value and I
can't...
|
7 |
22.09.2006 15:16:02 |
|
|
How to diable main Access window
Hi,
I have a modal login form wich is a startup form.
How to disable main Access window until login form is closed??
When I set popup property to true I get desired result but then my empty
textbox used for Username entry can't get focus when form shows.
So I must aviod using that property, please advise me on alternative method.
But, above mentioned problem is consequence of me "playing"...
|
2 |
22.09.2006 14:59:27 |
|
|
Help with filter issues?
I am new to the filtering the report from a form concept. In my
current
code the report must be open to apply the filter. I would like to
change it so that it runs the filter while the report is closed and
then opens the report. I used a filter and not parameters because I
wanted the user to be able to choose to enter all the criteria or just
some of it. Am I approaching this the wrong wa...
|
3 |
22.09.2006 14:48:20 |
|
|
Reading Fox Pro Files
I am new at access but is it possible to read a file created in Visual Fox
Pro. An is there a version of access I should be at to do this? Thanks in
advance for any help....
|
5 |
22.09.2006 14:41:22 |
|
|
from upper case to proper
How can I convert a name from upper case to proper. i.e. ALLIANCE to Alliance...
|
2 |
22.09.2006 14:24:34 |
|
|
CREATING WAY OF SHOWING CLIENTS BIRHTDAYS
using Access and i have created tables with clients details on. How can i get
the tables to show me clients birthdays a couple of days before they occur.
The object is to send clients cards for their birthdays?
please help...
|
2 |
22.09.2006 13:45:02 |
|
|
Last record, new record, coding
How would I code the following logic, to be put in a field's on_enter event?
The field is in a subform, in datasheet view.
If I'm in a new record
and it's not the only record
and the first field in this record is not null
then
this field I just entered now equals the value I entered for it in the
previous record.
Basically I just want to automate the Ctrl + ' function.
I do not w...
|
3 |
22.09.2006 13:43:02 |
|
|
Error 3734 - Passive Shutdown - locking out users
I have a multiuser database that has been working fine for many months. In
the last 2 weeks the users are getting the error 3734 if someone is in the
database and then the new users are not able to access the database. I can't
find anything about this except that it is a "feature". There seems to be
some parameter that is being set by the first user that sets the database in
a "State"...
|
7 |
22.09.2006 13:29:52 |
|
|
File sharing lock count exceeded
I encountered this error when we synchronized a large database. Please give
me advice on how to solve the problem.
File sharing lock count exceeded. Increase MaxLocksPerFile registry entry.
(Error 3052)
You have exceeded the maximum number of locks allowed on a recordset. This
limit is specified by the MaxLocksPerFile setting in your system registry.
The default value is 9500, and ca...
|
3 |
22.09.2006 13:14:01 |