Adding Information To A Read-only Table?

Jan 31, 2008

Hello,

I wasn't sure which area to post this question in...since it involves queries, tables, and forms :)

There is a read-only table in my company's data warehouse that stores a lot of records. I wish to set up a form that will allow users to add or relate data (fields) to each of those records.

Updating the data warehouse table structure is not an option.

How can I best do this...

1. set up my own table somewhere, that will automatically append any new data warehouse records every night, so basically I'll always have a copy of the DW table, but with additional fields that can be updated?

2. set up another table/query that are linked to the DW table via unique identifier...but if I do this, how do I display the DW records alongside the new fields in a way that makes sense? another query? will I be able to write in data in this fashion?

3. ...some other way?

Any assistance will be very much appreciated!

View Replies


ADVERTISEMENT

Adding New Information To Two Tables At Once

Aug 9, 2007

Hello -

I am new with Access and fear that this might be a very elementary question - apologies. Basically, I would like to create a few different tables that all have the same base information (like the primary key and name of the data), but different additional information. The only thing that I can't seem to figure out is how to be able to add a new entry to one table and have it show it up in the other tables. Is this possible? Thank you!

View 3 Replies View Related

Adding Information On A Form Based On ID

Feb 4, 2006

I've got a form that has certain information and I would like to be capable of clicking on a button entitled "add a client". When that button is pressed I would like another form to open and provide a search query asking for the client's name. When I hit okay I want a list of clients to be viewed based on a partial search. Once I have found the one I want I want to be able to click/do something to get me back to the original form. At this time, all the client information all will be put on the form and introduced to that particular table row.

If you have any questions regarding what I just said please ask.

Thanks in advance,

-- Mike

View 14 Replies View Related

General :: Adding Two Numbers While Inputting The Information?

Apr 1, 2014

I have a database where on the form we are just put in total deductions. We want to make sure that the total deductions is correct so while we are entering this number we want to do an excel thing by hitting = 1 + 1. Anytime we do that we are getting an error message. I really didn't want to have to set up a table to store these different amounts because we really only need the total. Is there a way to do that? I changed the format from currency to general but I'm still getting the error.

View 2 Replies View Related

Reports :: Adding A Chart That Represents Information On Report

Apr 2, 2013

I have a popup form that prompts for a value and has a button defined with an OnClick,OpenReport with a WHERE clause. The value the user enters is placed in the WHERE clause.

The report is generated using a Query and the WHERE clause.
I was very surprised -- it works!

Now I'd like to add a chart to the report that represents the information on the report. How can I do this without calling the query again? Can I somehow reference the information that's in the report?

View 1 Replies View Related

Read Only Table Link

Jun 27, 2005

Is it possible to create a table link that is read only. I realize that there a a number of work-arounds, but I'm curious about this functionality specifically.

View 3 Replies View Related

Linked Table's - Read Only

Apr 2, 2007

Is there a way to link MS Access tables as "read only" in Access2000?

Thanks,
SKK

View 2 Replies View Related

Any Way To Read CD Table Of Contents?

Oct 23, 2011

Any way in MS Access to read the TOC data from an Audio CD? It is I believe in the lead-in part. I have a music database, and would like to be able to read the track data directly from the CD (Title, artist, timing), without having to type it all in again.

I know this can be done, because my CD labelling software extract the data automatically - but can Access do it?

View 3 Replies View Related

Tables :: Open Table As Read Only

Jun 27, 2013

I want to be able to open a Table as Read Only, so that a user can browse etc., but neither alter nor enter data - I want them to use the Forms for that. How then, using VBA code, do you open a Table as Read Only?

View 14 Replies View Related

Query Criteria Read From Table

Dec 6, 2011

if there's a way to apply a list of items as criteria in the order listed? Say I've got a list of sales reps and I want a macro to run a query repeatedly, populating one rep from the list at a time in a field called Sales Rep.

View 8 Replies View Related

DLookup Function To Load Information From Table To Another Table Using Subform

Mar 22, 2013

I have 3 table table; Invoice table, Product table and Sale_product table. Sale product table records all sale from the product table

Invoice table has these fields
ID
TOTAL
CASH_TENDERED
CHANGE

Product table has

ID
CODE
QUANTITY
NAME
PRICE

and Sale_Product table has these
ID
PRODUCT_CODE
QUANTITY
PRODUCT_NAME
PRICE
SUBTOTAL
INVOICE

I did main form from Invoice table and sub form from Sale_product table. I want to use DLOOKUP function to load the name and price, quantity and calculate subtotal automatically from the product table based on the product code entered. i have being trying hard and i keep on getting "Name? error"

View 1 Replies View Related

How Do I Read Input Values From Fields In Another Table?

Dec 10, 2007

Hi,

I have a query which uses manual input on two fields. I would like to automate this query by pulling the input values from another table.

How do I read the input values from the other table instead of having the users type them in ?

Al

View 1 Replies View Related

Modules & VBA :: Read Currently Selected (highlighted) Row In Table?

Jun 22, 2013

I am interested, is it possible to read currently selected (highlighted) row in table?

I know that this is possible to move cursor on concrete field in table via VBA but is it possible to read record number when we move cursor manually (via arrows)?

View 13 Replies View Related

Audit Trail To Read The Caption Of The Field From The Table

Dec 20, 2006

Hi every one

i have an application with an audit trail module, i do read the table name , field name,old value, new value. but the lables of the fields at my forms are changed to arabic language

for example

lets say i do have a table
the name of one field is Name
on the form the label of this field is Lawyer Name

now the client is asking me to show the ( Lawyer Name ) not the field name ( Name ) in the audit trail to know the changes were made.

I thought to go to the tables and on each field 's caption i shall add in arabic the same as in my form

I am trying to read the caption of the field from the tables

i hope you understood what i mean

if you show me the code to do that , it would be highly appreciated

thanks in advance

View 5 Replies View Related

Tables :: Read A File And Import Its Data Into A Table?

Oct 17, 2014

Was wondering how i can import data from a file to a table in different fields. The data inside the file is described with the number of characters and space's between. The attached file has the data.

For example in the file attached, the first four characters represent a data like 'ticket number' and maybe the third line 6 to 10 charcaters represent 'name of a passenger'.

Now how do i import these data to a table into respective fields in a table.

View 14 Replies View Related

Forms :: Table Doesn't Read Combo Box Info Correctly

Nov 24, 2014

I have a form "FrmMaintenance" based on the query "QryMaintenance" that is taken information from the table "TblMaintenance".

In the form, I have to pull the serial number of a machine from a drop down list which works perfectly fine in the form and it also updates other associated records.

When I go to the table, it puts associated number instead of the serial number that I've pulled.

Same thing happening for the pull down list "Engineer".

I've tried to look at the format of the "SerialNo" and changed to text, then to Combo Box but it didn't work, and the same for "Engineer"

View 8 Replies View Related

Tables :: Password Protect A Linked Table Or Make It Read Only

Nov 14, 2012

I have a table that I imported from another database. I used import Access - Link to the table source by creating a linked table. - then downloaded in my database.

I want to use the linked table to create relationships and forms but do not want to even accidently edit it. The table gets updated in the database on a weekly bases and I am hoping it gets updated automatically in my database as well. does it automatically get updated or do i have to set up something?

Also, I want to protect the data in that particular table and either password protect it or make it read only. Can I do that? If so, how?

View 4 Replies View Related

Modules & VBA :: Access Read Email Messages And Populate Table

Feb 11, 2014

Currently have an Access db filled with different departmental information. Trying to build a workflow mechanism that will validate the status of a certain "Event".

70-80 different projects in one table. This table has Due Date for the project in itlAll of the days between milestones are static. There are 18 different Milestones covered by 6 departments.Table built to hold status of project. which includes notes for every milestone and date completed. 37 fields (date and memo field each with id number to relate back to project table

A generated email that emails the parties who are late or their milestone is upcoming. (can do this already, but see the other requirement)When users receive email they need to reply in the email that was sent to them the date and what the result of what they did in the email. Users will be using mobile devices, laptops and desktops to respond.Could use Collect Data feature, but it is not easily manipulated with vb. Also, it will not all information to be edited in a query.

View 3 Replies View Related

Access 2010 Table Suddenly Read Only - How To Remove That Restriction

Nov 8, 2014

This application has worked fine in the past, but now I find it stops cold saying a particular linked table is read-only. I've looked around and all I can find in the various forums is how to MAKE a table read-only. Reversing that process seems very difficult.

The application is a copy of another that now exhibits the same problem. Each uses a different data mdb - part of the development I'm doing involves changing a different table. I'm developing changes to the application in this separate copy.

I can't tell if other tables would have this problem - the table in question is the very first used (initialization routine) and I can't get past it without deactivating a bunch of code.

View 8 Replies View Related

Information Within A Table

Apr 14, 2005

i am trying to create a form with a sub-form in it. i have got my client details in it - address, phone, etc then within that table i would like to keep a track of treatments for each time they visit in decending order. can anyone help me out with this? hope someone understands what i mean

View 3 Replies View Related

Tables :: Lock Single Record In A Table To Be Read Only On Permanent Basis

Dec 29, 2014

I want to "lock" a record in a table so that it is read only and cannot be accessed/edited/deleted. Is it possible to lock a single record in this way on a permanent basis? It's actually the first record in the table.

View 5 Replies View Related

Looking Up Specific Information From One Table To Another

Aug 3, 2005

Hey everyone,

Ive got a bit of a problem with my database at the moment. Here are the two tables im specificly having problems with:

Item Stock

Item size
Serial Number
Delivery Date
Date out
Stock level

Item Fitted

Item Size
Date fitted
Reg number
Date Removed
Serial Number
Position

Here I have Item stock as my base table. Item Size and Serial Number info is collected from the base table and put into a combo box.

What im trying to do is when a specific item has been fitted, for access to note the size, serial number and date fitted, and place it into the correct record in the base table. serial number and size to be put in its respective table, and date fitted to be put in the "date out" field.

This is rather annoying i know and a bit difficult to explain, if anyone could help over msn that would be great - david_4321@hotmail.com

Thanks

David

View 1 Replies View Related

Query Table Information With T-SQL

Sep 12, 2005

I have been looking all over for the answer to this and can't find the slightest thing about it.

I need to know how I can query information about what tables are in a MS Access database. Lets say for example I can't access the database with the MS Access application and I want to write a web query in asp to list the tables in the database. For example, I may not know what tables are in there and need to find out.

I know there is a way with mySQL using the "show tables" command but it doen't appear to work with Access

I also came accross some code with OpenSchema(adSchemaTables) that is suppose to do the trick, but it either doesn't work or my shared-hosting provider doen't have it set up to work.

If anyone could PLEASE help me out with the T-SQL query code to get table info I would be greatly thankful!

Thanks in advance,
Dan
dan@innovativead.com

View 1 Replies View Related

Need Default Information From Another Table

Feb 7, 2007

Hello, I have been looking around trying to gather as much access info as I can. I could really use some help with what seems like it should be pretty basic to me. I am making database for excavation estimation and have a table with my equipment and a field for default costs. I then have a table where I assign costs to a specific job. So I would choose a piece of equipment from the equipment table and then would like the default values entered in from the equipment table into the job table for the default costs. So a default value is put there that can be edited for the specific job. I am guessing I need to enter something into the default data area on either the table or on a field on a form? Can anyone give me the format for putting this in. The primary key in the equipment table (auto-number) is linked to a foreign key in the job table. Thanks in advance.

View 1 Replies View Related

Problem With Getting Information From A Table

Feb 14, 2007

Im using Access 2003.


I have a form with a combo box that has a list of all the names that are contained in a table.

I am trying allow the user to select a name but then when the user selects that name it pops up the email in another text box. The name that is being selected is in the same record that the email is in.

whats the easiest way to do this? vba?

View 1 Replies View Related

Sub Cell Information In A Table

Aug 9, 2005

I am not sure if this has been done in a table before. I have seen it in forms but not in tables.

Here is my problem.
I have created a database for a planespotters club. This database has the tables.
ac_logged
ac_maker
ac_model
country
airport

I am trying to display selected information in the ac_logged tbl that is related to other cells. For example: If someone selects boeing in the maker field they will only boeing models in the model field. Also, if someone enters Ireland in the country field only the airports for that country would be listed.

I don’t want to do this in a form but I could settle for a query if I have to.

I was just wondering if this could be done in a table as opposed to any other way.

Hope I have made myself clear on this one. :confused:

View 6 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved