473,241 Members | 1,465 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,241 software developers and data experts.

Commiting changes in past records

Got a complicated challenge (better define my last challenge) but don’t have a clue where to start: I’ll try to be accurate as possible. Apologies I might be asking for a lot of coding but this has been bothering my for a lot of weeks trying to do it myself the ‘simple’ way but failed all over every time. This is all about automatic changes in particular field of a past payment.

Got form “Report” and subform “Bank”. The purpose of this form is to input payments made that day. In report form, the user set 1 daily record to save day details and the subform is filled with tens of records about customers and payment amounts.

In”Report” I got 2 particular fields:

Date: is set daily by the user
Dailyid: (as autonumber related to the subform)

In “Data” I got 2 important fields:

OrderID (order id inputted by the user which is the identity of the client)
Status: (combo box with option1, option2 and option3)

Example: on 18-Feb-2012 customer came to process a payment. A record in “Report” is open with the daily date and another record in the subform is set to mark OrderID ‘4512452’ and ‘Status’ field, which is set by the user as default to‘option1’. On 23-Mar-2012, the same customer is about to process another payment. Apart the same procedure is performed, when the user is about to save the new payment details, the field ‘status’ of the payment before (which in this case made on 18-Feb-2012), from opion1 is set automatically set to option3

Thanks everyone for help
Apr 17 '12 #1
6 1616
2,322 Expert Mod 2GB
Sounds like either you have some code or macros running or you have your form setup wrong. However I dont really have enough details to go on to form a more specific hypothesis.

Could you provide a screenshot of your form, that might help?
Apr 17 '12 #2
Hi thanks for your reply smiley coder :)

To make myself a little more clear, my real scenario, in "Status" i got 3 options as a combo box (instead of option1, option 2, option3):

- waiting
- paid
- archive

Going to my previous example, when the user inputed data in 28-Feb-2012, he set the "status" as PAID (or can even set it as waiting). When the customer returns On 23-Mar-2012, as the user is going to make a new record, the previous's record "status" (in this case the record made on 28-feb), from PAID or WAITING goes automatically to ARCHIVE...


Here is the "Report" form with "Bank" Subform:


This is log of the payment of the client order no 82948. When new payment entered on 23-Mar- . 2012, the record's STATUS of the previous record (blue field) went from Paid to Archive.

Thanks and let me know if you require any more details
Clara :)
Apr 17 '12 #3
12,516 Expert Mod 8TB
Use the before insert event to run an update query.

Why do you have a table that is essentially a bunch of dates? Not that a table of dates has no use but your date table doesn't seem to be used for anything.
Apr 17 '12 #4
Hi Rabbit, thanks for your input. Actually there might be a little misunderstanding but the 'log' form (http://imageshack.us/photo/my-images/198/23473788.jpg/) is a simple select query, just to show record details of the payment.

Form "Report" and subform "bank" are related to each other with RECORDID as autonumber in Report form.

Never used an update query so far - will be very happy if you can help me.
Apr 17 '12 #5
12,516 Expert Mod 8TB
If you're going to be working in databases, you should learn SQL. There are a lot of tutorials out there. I like the one from W3Schools.
Apr 17 '12 #6
759 512MB
Use an update query in order to update the Status field (for all records, for a certain user and for all dates before to actual date) to value "Archive".
Apr 18 '12 #7

Sign in to post your reply or Sign up for a free account.

Similar topics

by: Nicole | last post by:
Hello: I have a shared database running on a network drive. I would like to track when record changes occur and who did it. Problem 1: I'm not able to tack changes, when they occur in...
by: Lee Rouse | last post by:
Hello all, This is going to be a rather lengthy "question". I have an Access 2k database, separated front end/back end. Front end copies are on about 30 workstations and used frequently during...
by: ken | last post by:
Hi, I have a database that spits out reports. It takes a while for the report to be ready and many people contribute. I need to keep track of what changes are made. It would be nice to keep track...
by: Ken Mylar | last post by:
I have a problem that just showed up and I'm not sure why. I have a query that is supposed to show all records that have an Inspection Due Date any time in the past up until the end of the...
by: Rotor | last post by:
Hello again, Problem: I created a query to pull a set of records by workorder number. It works like a champ. However, I need the user to update/edit the records if need be. I am displaying the...
by: nfldbunker | last post by:
hi I am new to this forums but it looks like some knoweable people and some good discussions!!! I have 2 excel files that contain certain HR information that i import into 2 tables in access...
by: Luis Freitas | last post by:
I know how to track changes when they are done using a form. Can they also be tracked if I run an update query?
by: mfetterhoff | last post by:
Hello Experts.. Im checking out the other side of the tracks here.. always been a Systems Analyst kind of guy. Developers are a touchy and unpredictible lot. I try to give them their space and never...
by: Toby Gallier | last post by:
I am trying to figure out a way to update multiple records when a report is exported. Each record has a "Status" field. I have a query that selects all records with a status of "To Send" and that...
by: Bizmark | last post by:
Access2003, Windows XP Pro OEM user OS, Windows Sever 2000 server OS. Not-so-recently I inherited 3 Access DB's from another company merging with our own. Our own system works off of SQL...
by: abbasky | last post by:
### Vandf component communication method one: data sharing ​ Vandf components can achieve data exchange through data sharing, state sharing, events, and other methods. Vandf's data exchange method...
by: fareedcanada | last post by:
Hello I am trying to split number on their count. suppose i have 121314151617 (12cnt) then number should be split like 12,13,14,15,16,17 and if 11314151617 (11cnt) then should be split like...
by: stefan129 | last post by:
Hey forum members, I'm exploring options for SSL certificates for multiple domains. Has anyone had experience with multi-domain SSL certificates? Any recommendations on reliable providers or specific...
by: egorbl4 | last post by:
Скачал я git, хотел начать настройку, а там вылезло вот это Что это? Что мне с этим делать? ...
by: DolphinDB | last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation. Take...
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
by: Aftab Ahmad | last post by:
Hello Experts! I have written a code in MS Access for a cmd called "WhatsApp Message" to open WhatsApp using that very code but the problem is that it gives a popup message everytime I clicked on...
by: Aftab Ahmad | last post by:
So, I have written a code for a cmd called "Send WhatsApp Message" to open and send WhatsApp messaage. The code is given below. Dim IE As Object Set IE =...
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.