Newbie Question, Basic Table Automating Entries

Jul 20, 2006

Hi all, new member with a newbie question. I have just started working with Access, so pardon if this question is unclear or pitifully basic. We have a basic database comprised of client names, amounts paid to-date and balance due. It also has a field named date last paid, so here is the question. When you enter or change the amount in paid to-date, can you automatically have the date of the change (ie. Todays Date) entered in the "Date last paid" field.

Thanks all for the help in advance.

Chris

View Replies


ADVERTISEMENT

Newbie - Basic Questions About Design

Mar 5, 2008

hi everyone,
as a network engineer, it administrator, etc etc people expect to know absolutely everything about pc's. so here i am.....

a company whose network i look after are using excel spreadsheets on a weekly basis to take orders, wages, running costs etc from their remote sites (currently about 20 sites)
the spreadsheets are accessed via terminal services and are moved via a script at the end of the week so the remote site doesn't have access to the old records and replaced by a new sheet. so lots of spreadsheets floating about.
you can imagine how hard it is to pull past records & compare etc.

now, i'm new to databases and have order a book to gen up on the subject. the sites should only be able to edit the last 7 days of records but be able to see the last years. i can see how a query and subforms can achieve this etc.

each site shouldn't be able to see the other site's records and the head office should be able to run reports etc on each site or as a whole.

i can narrow the time down that everybody is accessing the data. the sites may grow to 50+ but the head office is unlikely to have more than 5 people access the dabase at the same time.

my question is..... (access 2007.... can't see any user security).....
am i better to do an individual database (all exactly the same apart from name, titles etc) for each site that sits in their individual folders via terminal services? then let the head office access each seperate database via linked tables?
my thinking for the above way was security (they can't see each other) and resilience (1 database gets corrupted, the others are still workable) and speed (only a few users accessing each database)
the downsides are obviously the amount of files although this is nothing compared to the excel files at the moment.
any ideas or help would be appreciated.
thanks
louis

View 3 Replies View Related

Automating Table Deletions

Aug 30, 2006

Hello,
I have a general table question. I have a VB programmed user interface logging information to a MS Access Database Table. I want to automate it so when you open up the table to view what was logged -- any table entry older than 2 weeks is removed from the table. Will this be difficult? Any suggestions on how to start? Are there any access functions that will do something similar to this? Thanks in advance.

Zak

View 2 Replies View Related

Edit Destination Table In Visual Basic

Aug 22, 2006

I want an append query to add records to one of several tables, depending upon the value of a variable entered into a form. This variable is also used to select the appropriate records. The query is invoked from the visual basic code behind the form.

Can anyone tell me how to edit the destination table from within the visual basic?

In hope...
Nell

View 2 Replies View Related

Basic Fields Must Automatically Show Up In The 2nd Database Table. Plz Help. Thanks.

May 29, 2007

Hi Everyone.

I am new to MS Access. I got two databases. The 1st database consists of the basic fields like the department,adress,salary etc of the employers(Primary key is the ID). Now in the 2nd database I have the same basic fields and some extra fields. Now my requirement is to when I enter the ID in 2nd database, all the basic fields have to be filled up based on the 1st database( May be I should link the 2 databases).

I really appreciate your help.

Thanks in advance,
Anil.

View 2 Replies View Related

Tables :: How To Rename Access Table In Visual Basic

Jul 20, 2013

i need to auto rename a table and for each new time to create date in table name and after that to use query into i am asking if that is possible.

my 1 table name is kalktbl and second table name is kalkulacija.

query is select * into kalkulacija from kalktbl and i am renaming kalkulacija.

i am using visual basic.

View 11 Replies View Related

Forms :: Assigning Multiple Entries In One Table To A Single Entry In Another Table

Jul 24, 2013

I've got a table tblPatienten, a table tblRechnung and a form frmRechnung.

The primary key in tblPatienten is KundenNummer, the primary key in tblRechnung is RechnungsNummer. The relationship between tblPatienten and tblRechnung is one to many.

Now, every patient (stored in tblPatienten) is allowed to make multiple orders (stored in tblRechnung).

How can I assign each new order entry in frmRechnung to an existing patient in tblPatienten?

View 10 Replies View Related

Grabbing Time Values From Table In Visual Basic And Performing Calculations With Them

Nov 8, 2004

Hi,

My boss wants me to program in visual basic, instead of using queries, a calculation between times, which values are gotten from a table. How do I perform a calculation between two fields from a table in code and what functions are there to calculate the amount of difference in minutes between times in visual basic? THANK YOU SO MUCH IN ADVANCE!

G

View 3 Replies View Related

How To Make Two Table Entries Correspond To Single Entry Of Different Table

Nov 18, 2013

I have one main table with a list of equipment. I have a second table where there will be a form for damage reports.

What is the easiest way to make multiple entries from the second table correspond with a single entry on the main table?

Some equipment pieces might have dozens of damage reports, while some might not have any.

View 1 Replies View Related

Table Relationship Newbie

Sep 14, 2005

I am working on this database where each category contains certain thickness ranges that can be stored in a pack of x amount and finally paneltypes.
ie KS1000 only comes in 40mm 50mm 75mm and paneltype MR is the one associated with it.

there are 3 tables
tbl_Customer
tbl_catergory
tbl_product
--------------------
tbl_Customer:
-CustomerID (autonumber) Primary key
-CompName
-CompAddr
-ContactFName
-ContactSName
---------------------
tbl_category:
-CategoryID (autonumber) Primary key
-Category (combo box) this has set values entered i.e.

KS600
KS900
KS1000
KS1000LP
KS1000RW
------------------
tbl_Product:
-ProductID Primary key (autonumber)
-fkeyCategoryID (foreign primary key)
-Thickness (combo) this has set values of thickness ie. 40, 50, 55, 60, 70, 80, 100, 150, 180
-NoInPack (set number directly related to the Category and thickness chosen)
i.e. Category KS1000 with thicknesses of 55 can be stored in a pack of 17. KS1000 with thickness of 60 can be stored in a pack of 22.

-PanelType: (combo box) set values as follows:
MR (this selected item relates to products KS600 KS900 KS1000 )
EB (this selected item relates to product KS1000RW )
CX (this selected item relates to product KS1000 )
MM (this selected item relates to product KS1000 )
WV (this selected item relates to product KS1000 )
---------------
I would like to be able to setup a form that a user uses to provide a quote:
It would start with using the Category combo box which lets you select one of the choices (i.e. KS1000) but the combo box would also have multiple column headings ie. Category/Thickness/NoInPack. Once selected then the next several individual field boxes (ie. thickness, NoInPack) are automaticallly populated with the selection just made in the Category combo box.

NOTE: Many categories can be chosen just for one record.
I therefore do not want to start setting up fields like Product1 product 2 etc and their associated fields like thickness1, thickness2 etc.
I'm failing in the relationships section. Please see attached database.
I have tbl_category: CategoryID (1) --------> (many)fkeyCategoryID from tbl_Product
I have tbl_Product: ProductID (1) -------->(many) CustomerID from tbl_customer
I know that i need a junction table somewhere.... but i'm a newbie when it comes to this stuff.
Any help would be appreciated.

View 8 Replies View Related

Newbie Table Question..

May 21, 2006

Hello, (pls scuse my english, it's not good) I'm a newbie to Access and I'm learning access I'm trying out one scenario to see if I can do it but I'm stuck..
main scenario is that a local company has decided to computerise their wage systems, but the wage system is very confusing.. data modeling has already been done in this example but as I understand the boxes(entities) in ERD becomes tables right? so I have like five tables.. Pay method, Employ type, Employ, Department, Division..

I know what to do with Employ, Department and Division but Pay method and Employ type is confusing for me I don't know how to work out attributes (fields) for these.. I have four different paying methods depending on 7 different types of categories of employees.. how would it work?

Also if you guys have any links that explains sort of similar scenario I would appreciate it very much.. thank you..

Oh and since I'm a newbie I'd appreciate it if you give me a simple answer not complex solutions,

View 3 Replies View Related

Newbie Help!!! Moving Record To Another Table....

Jan 10, 2005

Quick Scenrio:

I have a current employee's table and Retired/Resigned table, when an employee either retires, resigns or gets fired, i want to be able by the click of a switch or check box of some sort to move that record to the retired table. Your input is greatly apprectiated....

Eddie..

View 4 Replies View Related

Newbie- How To Attach Formula To Field In A Table.

Mar 9, 2008

I'm sure this is a simple issue, but so simple I can't find the answer.

I have a recipe DB and have calories and fat and fiber fields, I want to have another field which will display a point count for a formula (calories/50+Fat/2+fiber/5) but the catch is if the fiber number entered is over 4 I only want the calculation to use 4 max.

Not sure how or where to create this formula to populate a field in the DB.

As you can tell I'm new to all this and any help would be appreciated.

Thanks in advance
Mike

View 14 Replies View Related

Newbie Question Link Row To Entire Table

Jul 21, 2006

I'm a relative newbie and I'm trying to figure out if I can link individual rows in one table to entire whole tables.

Example:

I have a table with the following fields:

Ticker Quote Volume
MSFT $25.00 3000000
IBM $30.00 1093837
SNDK $20.00 5959483


Now each of these Tickers has a whole table of options associated with each particular ticker and the EASIEST way for me to proceed would be to simply link row MSFT with an ENTIRE table of MSFT_OPTIONS then link IBM with the table IBM_OPTIONS.

Keep in mind that I don't have a field called TICKER in the options table and MSFT does not appear anywhere in the options table.

I know I can go and add the TICKER field to the OPTIONS_TABLE and then assign a primary key and then link them both but this would involve a great deal more work since I have hundreds of stocks with options tables to link. The data I get is in a specific format and I don't want to have to massage the data too much.

I appreciate your help,

Mr. Opine.

View 1 Replies View Related

Moving Entries From One Table To Another

Jun 12, 2006

So I have 2 tables, the first is for "open" orders (where entries get edited changed and deleted), and the Second is for "finished" orders (where once an order is completed it should move from the open orders table to the finshed one where it will no change and will remain for futre reference)

I need help with the transfering part of this problem. I would ideally like to make a form that allows you to pull up the info for the open order then edit it to finally add the finished order to the other table. Im not sure where to start on this one.

View 3 Replies View Related

Duplicating Table Entries

Jan 13, 2007

I have a table named tblProduct,
I have a table names tblProductSpec,

tblProduct contains basic info, tblProductSpec contains infomation linked with outer tables. What I need to is have the product ID's duplicated in tblProductSpec. Is it possible to do this via relationships etc?

Any help greatly appreciated. :)

-Adzi

View 3 Replies View Related

Automated Entries In Table

Jan 26, 2006

Hello,
I have a table which identifies my database users with the following fields:

INITIALS
USER
TITLE

I than have another table named MASTER with two fields named USER and TITLE. The field user, get it's data from the first table INITIALS. I would like that the field TITLE would be updated with the users TITLE once it is entered.


I know how to do this with a form (I place in a txt box =[USER].[Column](2) but have noticed that it only displays the info but not actually stores it into the field.

Is there a way I can do this directly from the table so that I can remove the TITLE control from my form? Thanks.

View 1 Replies View Related

Limit Of Entries In A Table!

Oct 23, 2006

I have a table 'project'. I want that the number of records in this table should not exceed 20. How can I code this is my code? And how do I set it in the 'table design'?

View 2 Replies View Related

Creating Two Tables - Old Entries And Weekly New Entries?

Mar 13, 2014

I have a table in access which is updated weekly; I need to create two tables from this updated table.

1st table will consist of all the new entries for the current week

2nd table will consist of all the entries from the previous week - an amalgamation of all the entries which are not from the "current week" (table) For example; the table below shows the two entries from last week.

ID
Name

1
Adam

2
Ben

This week I have three new entries New entries

ID
Name

3
Charles

4
Richard

So when I run the same query next week I will get something like this.

Old Entries
ID
Name

1
Adam

2
Ben

3
Charles

4
Richard

[code]....

How do I get a query /queries which divides up the weeks new entries and also all the old entries.

View 11 Replies View Related

Newbie Question! Getting A Cmd Button To Create Data In Table?

Nov 29, 2004

Hey all,

I've never used Access much...i was able to use it OK at one point but ive forgotten all about it now.
I need to create something very simple for the reception at my work...

When a customer phones we want to be able to keep track of how they heard of us - so we want a very simple access/VB program.

The best way would be to have buttons of each of the magazines our company is listed in..then when someone phones and says "ahhh magazine 3" the receptionist can press a button and the button will add 1 to a field in a table?/report? next to that magazine.

Hope that makes sense :s

Any help would be very appreciated! - It seems very simple to do ?

Thanks
Acle

View 5 Replies View Related

Total Newbie Question - Form Updating Not Table

Dec 1, 2004

Okay I've looked around but haven't found an answer to this, if there is one in the forum please forgive me. I've created a database to help track employee passwords for differnt system I placed and Audit Trail on the form (the example from Microsoft) however it updates only the form and not the table and I need it to do both. Please Help!

Thanks

Rand

View 14 Replies View Related

Restrict Number Of Table Entries?

May 13, 2005

Hey all,

I'm having a horrible time trying to get this to work. Basically, I have a database which has multiple tables. All of my tables are being generated with a CREATE TABLE statement. What I would like to do is add a validation rule or something else upon creation so that only X number of entries can be entered into the table.

Initially, I just added a rule that said id<5 or whatever manually to the table in order to restrict the number of entries, but I can't figure out how to do this automatically in my SQL statement or Visual basic. I want to be able to have this check added upon table creation. Surely what I'm doing must be possible.

Am I going about it the wrong way? Any Help would be appreciated. Thanks!

View 3 Replies View Related

Table Entries From A Drop Down Of All Possible Queries

Feb 15, 2006

Hi All,

I am wanting to build a table which consists of all the queries and tables in the database.

I am expecting column 1 to have all the queries and column 2 to contain all the tables that make up the query. So the table will look like this:

Queries - Linked Tables
Query1 - Table1
Query2 - Table1
Query2 - Table2
Query3 - Table1
Query3 - Table4

As you can see a table can be linked to any number of tables.

Now for my actual question. I don't want to have to type in all the queries and tables. I would like to choose any query and table from a drop down of all possible queries and tables that are currently in the database - like a list, where the list contains all the possible values.

I would then select the relevant entry.

Any pointers would be great.

Thanks,

Evan

View 2 Replies View Related

Updating Form Entries To Another Table

Jun 11, 2006

Hi all

I'd be very thankful if someone can please help me with this problem.

I have 1 Table. This Table is imported and contains data from Excel. It also contains fields I added manually. There is about 20 imported fields (full of data) and about 100 manually added fields.

Then I made a Query of this table. I made some calculations in this Query.

I then created a Form based on the Query. I then made a Combo Box. This Combo Box selects a customer, and then updates the other fields (the ones I imported from Excel) depending on the customer I selected.

So now what I want to do is this: I want the fields (updated from the query) and newly entered data to save to another newly-created table. Can someone please help me with this? Any ideas?

Thanks a lot. All input greatly appreciated.

kruger101

View 2 Replies View Related

How Do I Remove Duplicate Entries From A Table ?

May 19, 2007

Hi all,

I have imported a table from Excel. The table contains a long list of names and there are quite a lot of duplicates.
How do I remove the duplicates so I can import the clean list into a value list in Access ?

Thanks in advance !

View 2 Replies View Related

Tables :: Create One To Many Table Entries?

May 8, 2013

I'm new to MS Access, indeed database design as a whole.

I have been tasked with creating an issues logging database and am having some issues...

I have a table/form that has all the fields I want, including a unique ID, called "Issues". I want to be able to log multiple entries in another table called "emails". The trouble is I am not having much luck. I can create an entry in the issues Form which then shows in the emails but I can't then add another email under the same ID in the "Issues" table.

View 2 Replies View Related







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