Automatic Entry Of Transaction At End Of Month

Jun 5, 2005

I am trying to create an Access application where income recognition is automatically calculated and stored at the end of the month based on established parameters. How can this be done? Does it require VBA programming?

View Replies


ADVERTISEMENT

Automatic Date Entry On First Day Of Each Month

Feb 27, 2012

How to design a Query that will add a specific date to a Table every month?

In my case, I would like to add / append new record entries on the first day of each month - for example.

Do I have to start with a table that has ALL the future dates required, or is there any other solution?

View 3 Replies View Related

Automatic Month

May 9, 2005

auto date no problem but just an automatic month ??


any ideas???

View 4 Replies View Related

Automatic Data Entry

Jul 2, 2007

Hi there,

I have a table called Cars and a table called Rent

In Cars i have Car ID (Autonumber and primary Key) and Price Per Day

In Rent I have Rent ID, Car ID and Price Per day

The Car ID in Rent is a lookup from the Cars table, but is it possible to make it so that when i enter the Car ID in the Rent table, it automatically fills in the Price per day field for me?

Sorry if something like this has already been posted, i didnt know what this is called so didnt know what to look for.

Thanks
Chris

View 5 Replies View Related

Automatic Data Entry

May 19, 2006

Hi All,

I'm sure this must be fairly straight forward but I've been going around in circles trying to solve it in VBA without success.

I want the value of a field (Field C) on a form to be automatically entered depending on the value of two other fields (Fields A & B).

e.g.
If Field A is Null and Field B is Null then Field C is Null
If Field A is not Null and Field B is Null then Field C = "YES"
If Field A is not Null and Field B is not Null then Field C = "NO"

Please, put me out of my agony!!

John

View 1 Replies View Related

Automatic Information Entry

Feb 20, 2008

Hi

I have a small database with a list of customers names and addresses in one table and a list of orders in another table.

in the orders table I have a space for customers address. what i would like to do is to be able to type in a customers name and prefill the address details from the customer database to the orders database.

any ideas anyone please

View 1 Replies View Related

How To Get An Automatic Entry Based On Criteria

May 9, 2007

My database tracks individuals qualifications. These qualifying scores relate to Unqualified, Expert, Advanced etc. What I want to do is add a entry into my roster table which will have the qualification score.
I then want to have the score and actual qualification (Advanced, Expert, etc) in a Report.
The qualification type is a range (less then 30, 31-40, 41-50), and I think that I will need a BETWEEN statement. What I am not sure of is how to put this together to make it equate the number with the equivalent word in a report.

Thanks
the brewmeister

View 3 Replies View Related

Automatic Field Entry Contradictions

May 5, 2005

Is it possible to ensure that if a particular field has a specific value, ie, 'yes' then the reaminaing fields on the page are automatically set to 'no' by default?

If No is selected in the field in question then this would subsequently allow the other fields to be set to any value.

Thanks in anticipation :)

View 2 Replies View Related

Automatic Current Date Entry In A Record

Dec 12, 2005

Hello,

I have a quick question on how to enter the current date in a record automatically when the record is created.

Here is the situation. Say I have a Products table that lists the products that have come into the inventory. There is a field that denotes the day the product was introduced into the inventory. So ideally when the user creates a new record for the product, I would like this field to be populated automatically with the actual date that this filed was created by the user. Note that in future the user may edit the product (i.e other fields in this record), but the entry_date field should not be altered from what it was the first time is was created.

Is there a way I can do this? Any help much appreciated. thanks.

View 5 Replies View Related

Automatic Field Entry Based On Several Fields

Mar 16, 2008

Hi

I am an amature with databases and a bit rusty too. Can anyone help me with this problem?

basically I want to automatically enter a unique asset code for one table that is based on product and manuafacturer's codes from other tables

e.g. for audio visual eqipment

The first table would be a manufacturers table with the manufacturers code as the primary key e.g. JVC, HTC (hitachi), SHP (sharp) etc

The second table would be a product table with the product code as the primary key e.g. AMP, DVD, LCD (lcd tv) etc.

( i would also have a customer table and an asset repair table)

In my asset table I would like to enter an asset code as the primary key of the type JVC-DVD-001, JVC-DVD-002, HTC-LCD-001 etc by looking up codes from the other tables and then adding the last number.
(Ideally once the manufacturer's code has been selected only the product codes for products made by that manufacturer would be displayed).
(Also it would be ideal if referential integrity could be set up so that the asset code components can only contain valid manufacturer and product keys.)

The asset code cannot be a compound key as I want to have a repair records table in which the asset code is entered as a single field with referential integrity to the asset field in the asset table.

When entering repairs I would like the lookup field to display only the assets belonging to a particular customer.

View 4 Replies View Related

Automatic Date Entry Memo Field

Jan 31, 2006

I have a memo field on a form. I am trying to autopopulate it when entered into. For example: I enter in clients info and then tab to the memo field and it automatically enters date and time. Then later when I go back to that same record to append to the memo field it adds the current date. This way I can go back and see all the dates and times when that person called. Any idea how to do this? Thank you

View 5 Replies View Related

General :: Automatic Date Entry For Field Changes

Mar 2, 2015

I have a database that contains 13,772 records and each record contains 34 fields. The database is used for historical research purposes. As I am constantly changing the content in one or more fields I would like to be able to have a field that would show the date of any changes that are made to any of the fields in any given record. Additionally I would like to be able to run a query, lets say every six months and extract all the updated records.

View 6 Replies View Related

Automatic Recurring Entry Based On Start Date And Nominal Interval Period

Feb 15, 2012

How to create a table that has a recurring entry, based on a start date and a nominal interval period of e.g. one calendar month?

Is it possible to have these entries applied automatically each time so that they appear, as required, when the table is opened?

For example, for the entry of regular payments due per month.

View 3 Replies View Related

Only Allow Date Entry For Current Month

Jan 8, 2006

Hello,

I am a little familiar with Access but having a problem figuring out how to alert a user that the date entered on a form is not the current month. I was hoping to have a warning msgbox pop up alerting the user. I am trying to prevent incorrect date entry.

Thank you very much

View 4 Replies View Related

Query For A Month Range Based On Combobox Entry

Aug 2, 2005

Hi,

I currently have a form that creates a report based on a query that takes in a start date and an end date.
What I would like to do is to create comboboxes that will let the user choose a month and year for the report.
Is there a simple way to choose an entire month in access? I've tried using the Month() function to no avail.

The SQL statement for where I select the start and end date is below:

WHERE ((([tblData].[EntryDate])
Between [Forms]![frmByRange]![BeginningDate] And [Forms]![frmByRange]![EndingDate])

Any help would be much appreciated!

View 2 Replies View Related

Tables :: Create A Table With Entry For Month /day - No Year?

Jul 8, 2013

I'm trying to create a table with an entry for month/day, no year. I want to create a report that can will sort the birthdays based on month in ascending order.

I'm currently using the text field to put in, "10/30" or "1/3" but when I try to order the dates, instead of "1,2,3,4,5,6..." I get "1, 10, 11, 12, 2, 3.." etc.

View 11 Replies View Related

Automatically Add Entry For Associate If No Entries For That Month Exist?

Sep 28, 2015

I have a database that is tracking attendance for several 100 employees. The Db is mainly used to log any policy occurrences (no call, no show). If an associate doesn't have any occurrences for a month, then they get a point credit. Right now, I set it up so the credit can be manually added. the problem is a supervisor (the user) may not know if their associate should receive this credit unless they review their attendance report. Opening the form to add a policy occurrence, then running a report to only re-open the same attendance form is inefficient. What I'd like to have is a way to have a credit automatically added if they did not receive any points for a particular month.

ps. My office does not allow uploading any data/files so I am not able to upload a copy/sample.

View 4 Replies View Related

Dynamic "Month" Field Controlled By Date Entry...

Nov 7, 2005

Hello.
I've been reading these forums for a few months now while developing a database for logging bugs during website QA, but never posted.

I need a way to change the "Month" combo dynamically based on what a user enters into the "StartDate" and "EndDate" Fields. (I'm using Access '97)

e.g.
I have Validation set up on both start and end date fields so they are required before a record can be saved. I would like the "Month" combo box to update with the proper month after a user has entered the StartDate and EndDate.
(Basically a timesaver for users who are entering 20-25 criteria into a single form.)

There's one hangup:
the date ranges aren't typical, as in, "November 1-30 = November"... It's more like "10/23 through 11/30 = November"
here's what that chunk of the form looks like:
http://www.ewiessner.com/misc/images/sded_month.gif
So if I were to enter 9/27 start, and 10/27 end, "October" would populate in the "Month" combo box, and I could continue to other fields.

Any input would be appreciated, and I apologize if this is a repeat post, I couldn't find any similar topics.

Thanks,
-E

p.s. - If it helps, I have a 'Month' table with 1-12 = Jan - Dec, the 'StartDate' and 'EndDate' fields are text entry boxes bound to the master 'Details' table where all the data is stored.

View 3 Replies View Related

Transaction

Oct 9, 2005

I want to run 10 big queries (append/update/delete) one after another.
If error happens before they all finish (if user press escape button) - I want
to discard all record changes made by any of those queryes. I suppose
begin/end transaction method is the right way to do that. Can you give
me an example of code?

View 1 Replies View Related

Amt Due On Old Transaction

Oct 7, 2005

I'm not sure what to search for to figure this one out. My searches, so far, haven't helped me much.

I'm tracking transactions in a clinic. The amount due for the visit is calculated fine, but sometimes people don't pay right away. (And sometimes pay ahead, which will just be a negative amount due.) I need my transaction to not only show what's due from today's visit, but also to look at previous transactions of the same client and calculate what may still be due from before. Additionally, if I pull up an OLD record, I need it to show what WAS due on that date, not what's due today.

So, I know I need to refer to dates prior to the date on the form, regardless whether it's today's date (for a new visit) or a previous date (for a previous visit). That's what I'm confused about.

How do I refer to [txtDate] on THIS form and not confuse Access with [txtDate] on earlier forms?
Code like this:
SUM[blahblahblah] WHERE [txtDate] < [txtDate] surely won't work.
Does:
SUM[blahblahblah] WHERE [txtDate] < [Me].[txtDate] work?

Should this kind of calculation be in a query or in the Control Source itself, or somewhere else?

And do I need the square brackets or not?
Do I use '.' or '!'?

View 2 Replies View Related

Transaction Table

Jul 14, 2005

Hi,
I don't want to abuse anybody's patience but I have yet a couple of other quick question about transaction table.
I am using a summation query for the stock on hand where by keeping it simple: stock = sum of movement in the table. What hapens if a simple function is used to calculate the stock. ie: Stock=[Qty Declared-(Qty Declared-Qty Received)-Rejects]-Qty Allocated

All those Qty belong to the same field then I can't just run a sum.

My other concern is that:
Qty Declared
Qty Received
Qty Rejected

are three values entered at the same time but in the same (transaction type) field so data like the date would need to be entered 3 times for each item received?

Thank you very much for your time and patience again,

View 3 Replies View Related

Transaction Table Probs.

Feb 2, 2005

Hi,

I'm developing a database to handle various aspects of quality control reporting. I've got a working structure however, i think, i have gone off the track slightly... First I'll show you part of the structure:

(please see attached .jpg)

(hope that makes sence)... so effictively I have a many to many relationship.

I have forms for each of these entities (frm_parts, frm_Suppliers). The problem i have noticed is you can assign the part a supplier in frm_Parts but it does not appear in the transaction table as a record. Is this because i have based the field "Part Supplier" (a combo box) in frm_Parts on a query? If this is not the right way to go about it. how do i go about it?!
I have an idea... on this.. If i create a new combo box on the form I can use the wizard to select the supplier ID from the Supplier table (i believe) and "store" it in the transaction table... i think! But I want the user to select the Supplier by drop down list showing Supplier Number and Supplier Name.. not the ID.
Any help is much appriciated!

Next job...

I have a form where I would like the user to be able to enter, for example, a Supplier number and see if a record of the Supplier exists yet. Next I want the user to be able, assuming the Supplier record exists, to search for a record of a Part number from that supplier. Next I want them to be able to "select" that part and be able to open a form with a new record using that part number (this form holds details of a report rasied against that part).
See what I'm getting at?
I've had a go at this but it's been a couple of years since i did any detailed work on an Access database so somethings are a bit hazy!
I'm not asking you to do this for me, but I would much appriciate some pointers on how to create this sort of thing!

Many Thanks

Rob

View 6 Replies View Related

Sales Transaction Query

Mar 17, 2006

hi there...

I have been looking around the forums for a little while now... and cannot seem to find anything which will help me.... heres my query..

I have a stock control database.. which allows for sales transactions via a barcode reader...

my first query is.... when the user scans a product.. how can this be 'looked up' in the (UPC data table)... returning the correct information.. ie.. description.. but then taking the price from the product table.. the query doesnt seem to let me be able to join the two tables.. no idea why!?

secondly.. I want to create a form.. for the 'sales transaction'.. when the user clicks 'pay' i want the form to clear and store all these items in the sales table.. (deducting the units in stock at the same time..)

I hope anyone has any suggestions.. or pointers! Many Thanks
:)

View 7 Replies View Related

Selecting Most Recent Transaction

Jan 22, 2008

I have these fields
ID,InvoiceID,DateEntered,Description

What I need now is to show the most recent transaction per invoice and what was the description for it.

Doing this

SELECT InvoiceID, Max(DateEntered) AS MaxOfDate
FROM TableName
GROUP BY InvoiceID;

Works Perfect. The problem I have is when I display the Description field. As soon as I do that, I see all invoices and not just the most recent. Anyone know how to write this sql statement that will return the invoiceID, dateentered, and Description only for the most recent invoice in the system?

View 1 Replies View Related

How To Generate Reports For Day To Day Transaction

Apr 12, 2015

I want to create a simple data base, in which I have to record Payments received from each customer on daily basis. and on daily basis i want to generate a report for the transaction I have made. example of data table is as follow. payment mode is cash or bank transfer.how to generate reports for day to day transaction.

View 5 Replies View Related

Queries :: Rolling 12 Month Query - Keeping Track Of Orders Placed For Given Part Number By Month

May 5, 2014

I am trying to create a database that will keep track of the orders placed for a given part number by month. Currently, my table houses the part number, and the ordered amount for the past three years by month (there are thirty-five columns for every part). My column headings are ORDER_MAY_2013, etc. I would like to set a query up that will look at the column headings and pull the amounts ordered for each part for the past twelve months. In other words, I have three years of data in my table. In my query, I just want one year. However, I don't want to have to rewrite the query every month so that it will pick up the new data. Is there a way to accomplish this?

Is there a better way to build this database? I thought about just have four columns in my table - PART_NUMBER, ORDER_MONTH, ORDER_YEAR, ORDER_AMOUNT. The only problem there, is that every part (there are about 450 parts) would have to be listed 35+ times. That seemed too redundant to me, so I built the table this way. However, now I am having trouble querying against it.

View 2 Replies View Related







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