Problems With Recording Data In Table Through Forms

Jul 5, 2006

Hi All,

This is my first post on this forum...:)

I'm having the following problems:

I have a table with "n" fields.
Each field will constitute a form.
Each form will have a button which will open the next form.
Basically I want to record new data into the table (database) through FORMS.
What I am unable to do is to record data on the same line in the table !!!
What I have so far is that I am able to move to the next record when creating a new NCR but the rest of the data (fields) are going to overwright the first record in the table (first line).

I would attach my database here but the file size is bigger that permitted.
If someone interested I could foward it on e-mail.

My second issue is that after recording data into the table I want to be able to modify that data through a form. When a certain NCR number is choosed this will pop-up the NCR form with all fields from the table.


Any suggestions are more than welcomed.

Thanks for your help...

Mumus.

View Replies


ADVERTISEMENT

Problems With Recording Data In Table Through Forms

Jul 5, 2006

Hi All,

This is my first post on this forum...:)

I'm having the following problems:

I have a table with "n" fields.
Each field will constitute a form.
Each form will have a button which will open the next form.
Basically I want to record new data into the table (database) through FORMS.
What I am unable to do is to record data on the same line in the table !!!
What I have so far is that I am able to move to the next record when creating a new NCR but the rest of the data (fields) are going to overwright the first record in the table (first line).

I would attach my database here but the file size is bigger that permitted.
If someone interested I could foward it on e-mail.

My second issue is that after recording data into the table I want to be able to modify that data through a form. When a certain NCR number is choosed this will pop-up the NCR form with all fields from the table.


Any suggestions are more than welcomed.

Thanks for your help...

Mumus.

View 2 Replies View Related

Forms :: Recording Data (Totals) Onto Form

Apr 30, 2013

I have created a form to input invoice details with a sub form to input the products with the prices etc.

This all works fine but now I want to create totals such as Total Goods, Total VAT and Invoice Total.

After many searches of the internet, I found out how to do this and put in the calculations which works fine and displays on the main form without a problem.

Now I have a problem as these need to be saved to one of my tables.

As these are unbound text boxes with only the calculation on, the data is not being recorded onto the form which is what I want.

Do I have to create a macro of some sort to do this or?

I have included a few images of what I have done but if you would like the database file I can upload that (I will take away all the information that is sensitive to me if that is okay?)

View 4 Replies View Related

Tables :: Using Default Value For Calculation And Recording To Table

Nov 19, 2013

I shouldn't normally record calculated figures into my table. I'm willing to buck proper procedure here for ease of use for referencing in reports; also, it's just one data point that will be calculated only once and not changed.Anyhow, I have an IIF statement that calculates a total price based on a table of costs. I set this as the default value and it calculated properly - but once I set my text box to have a control source, it no longer calculates my cost.

I was hoping to set it so it calculated the cost and then write that total cost to my table.should mention that my calculated control is in a subform.

View 2 Replies View Related

Forms :: Recording Date And Time A Form Was Last Updated

Jul 29, 2014

Displaying the 'Last Modified' dates and time on a form. How to go about doing what I want to do.

I would like to display on a form in one single field the date & time that any of the fields on that form were changed and. I would like to display it in such a way that it cannot be altered by anyone. If it is possible to capture and display on the form in a separate field which user account accessed and changed the record then all the better. Obviously if nothing is updated then the date and time stays the same.

I will have to create two new fields in the table that relates to the form and this I have done - one of format Date/Time and one of format Text.

View 7 Replies View Related

Modules & VBA :: Finding Duplicates In A Table And Recording Values In That Record

May 2, 2014

I've been looking everywhere to find a better way of finding duplicates in a table and then recording and adding another value in that record together.

Let me try to explain better.

example:

I have a table that has 2 columns "Name", "DOB". I would like to find all duplicate "DOB" and add all of the "Name"'s together.

Quote:

Name DOB
bob 19800201
Sam 19761211
Jim 19800201

The output I would like is to have Name = bob & Jim DOB = 19800201.

I've tried using the find duplicate wizard in access but I can't seem to group them together and just to find the duplicates it takes upwards of a minute.

View 1 Replies View Related

Forms :: Bank User Form - Recording Deposits And Withdrawals

Apr 8, 2014

I want to create a form where i can be recording the deposits and withdrawals of my bank account!

Let's say I don't have any deposit. If I want to add then i would click on the "+Deposit money" button to open a form to add let's say 10$.

so my total would be 10$.

Next record would to add 30$

so my new total would be 40$ (10$ + 30$)

NOW if i make a withdrawal from my account i would like to click on the "- withdraw money" and so my total would change!

so if i withdraw 5$ the new total would be

35$ (total 40$ - 5$)

how can i do that?!!!

View 2 Replies View Related

Forms :: Make A Button To Search Range Of Columns In Data Table With Data Type Yes / No

Apr 15, 2013

what I want to do is make a button to search range of columns in data table with data type Yes/no and display the results if the value is yes

View 9 Replies View Related

Forms :: When Pasting Data In Table / Some Of These Data Appear In Form But Some Are Not

Mar 13, 2013

I am new to access (2007), There is a datasheet in the form where we enter our time in/time out. We enter data using the form but that is one data at a time only. So I tried to paste multiple data (records) from excel into the access table. After pasting into the table, the data appears in the query, but not in the form.When I go to the form to check if the data I pasted into the table will appear in the form's datasheet...some data appears but some does not.

View 2 Replies View Related

Forms :: Update Data From One Table To Another Table Using Form - Access 2010

Dec 16, 2013

How to update data from one table to another table using form.

I have data coming from design team in Database 1 and using form i want search data and assign the job to a person and store it in the database with his name. I have to do this because database from design team is read only.

View 1 Replies View Related

Forms :: Showing Data From Linked Table And Local Table

Nov 21, 2013

I'm having trouble with a new project I'm working on. The application is mainly going to be used to display data, which comes from a linked table. It has to be a linked table (in my opinion) because it's replaced once per week from a fresh data dump. For each of those records, though, there will be notes made in a local table named "Custom-Data". My trouble is displaying a mix of information from the linked table, "Roster", and "Custom-Data" because linked tables can't be assigned a primary key.

Essentially, when a record is pulled up, a bunch of data from "Roster" will be shown in addition to the comments from "Custom-Data".

View 2 Replies View Related

Recording Which Reports Been Ran

Oct 27, 2005

I have created a data base inwhich a user can run 6 reports. I then have a manager who has a administration form which i want the manager to see what reports have been ran and what day.

to run the reports the user hits a button in another form, which then exports a qry to excel.

All the buttons have been named and each report has its own marco name.

Is there a way i can do this simply??

View 6 Replies View Related

Recording Database Changes

Aug 17, 2006

Hi all
I have seen some functionality in another database and would like to add it to mine but I have no idea where to start. I was hoping someone would be able to point me in the right direction to a tutorial or sample database that could help me.
What I would like to do is record when changes are made to specific tables. For example, in a vehicle table, if the vehicle is changed from active to inactive for example, the date, the value that was changed and who did the change would be recorded somewhere. I'm guessing another table.
Can anyone point me in the right direction.
Thanks
Craig

View 2 Replies View Related

Recording Payments

May 17, 2007

I have a database with 10 properties which I want to record details of weekly or monthy payments. I have a table for properties, one for tenants details and one called payments. I then have them on a form. I want to open the tenants form and insert a command button to open the payments form and record payments as the occur but i can only enter one - it is giving me an error message as I am duplicating a record. The tables are linked with a property reference which I have set as the primary key. I have obviously done it wrong. Can anyone advise me of a way to do this please.
Thanks Tracey

View 1 Replies View Related

First Recording Not Importing

Apr 1, 2008

I am using access 2003. I've setup an import specification for a text file to import into a table. It's importing but leaving off the first record. When I setup the import specification, I did so as fixed width because the fields were not defining correct when I used delimited. Could it be that it's thinking that the first record include the field names? If so, how do I rectify this?
thanks

View 3 Replies View Related

Recording Changes To Queries

Aug 4, 2007

Hi All,

Some annoying sod at work has been changing queries and i've been getting into a hell of a lot of trouble due to it!

Is there any way to record changes made to queries?

I have an audit trail to record changes to the data displayed in the forms but I really need to catch this SOB before they cost me my job?

Any ideas?

Ta

Dante

View 5 Replies View Related

Recording User Useage

May 19, 2005

Any help most appreciated!

I have a Access 2003 database I am developing which has a table called "tbl_users" in which I have the fields:
user name(text), network id(text), status(yes/no), long on time (date/time), log on date(date/time), log off time(date/time), log off date(date/time).

When a user logs on my autoexec macro calls a prodcedure which sets that users status to "yes" or ticked and stamps the log on time and date. Is it possible to call this procedure even if they bypass the autoexec by holding down the shift key?

In reverse to this when they click the "Exit System" on the Main Menu form there is a call to a procedure which unticks there status field and stamps the log off time and date. Again, can I trigger this procedure even if they exit the database without using my "Exit System" button (ie click the "x" to close the database)?

Regards,

Dalien51

View 6 Replies View Related

Recording Weight Loss

Mar 3, 2007

My wife is slimming, I would like to record weekly results.

How do I make a new entry compare with her ideal weight and flag up her progress.

e.g. ideal weight =10 entry 1 13 entry 2 12.9 etc

Can I get the cell holding the new entry to refer to the ideal weight and flag up the difference each time I update the weight for the new week?

View 3 Replies View Related

Recording Visits To A Form

May 31, 2005

Is there a popular way to show when records are updated, with something like a text box with Now(), please, Gurus?

It needs to be automatically enacted. (A box that they complete themselves gets quickly forgotten.)

Then if the Client refers to records changed on such and such a date, I can find them instantly.

View 10 Replies View Related

Recording Time Values

Aug 3, 2006

I Have a problem in which when I create a record I wish the record to automatically record the time it was created. I have achieved this by having a timerecorded field within the table and setting its default value to time().

later on I wish another time to be recorded. This time when the user selected an option box to -1 I wish the time to be stamped into another field. I have used this event procedure to write the time to another field.

Private Sub AOGCleared_AfterUpdate()

'Update Time

If Me.AOGCleared = -1 Then
Me.TimeAOGCleared = Time()
Else
Me.TimeAOGCleared = ""

End If



End Sub

however It records the original time of creation when the obtion box is selected. Can anyone please point me in the direction of how I get access to record this later time please ?

View 5 Replies View Related

Recording User Login

Nov 20, 2006

Hello,

I am developing a cylinder tracking system, when i user logs in its necessary to record this action, as when they try to fill a cylinder i need to be able to record that this particular employee has updated the table and by recorindg the user login in i will able to do this.

IS the anyway of being able to record whos logged in?

View 1 Replies View Related

Front End Not Recording Information In Back End

Jan 16, 2008

I have a database that I built as one large database, then used a method I found on here to creat 2 brand new databases and copy the tables from the original to one and use it for a back end and then copy everything else to another file to use as the front end. I did this and it worked great, except that now the information being input into the forms on the front end is not being recorded into the back end. I tried relinking the tables and it still was not working. Is there a secret step I missed or something I need to fix in order to make this work properly? The way I made the front end dependent on the back end was by linking the table from the back end to the front end. I checked the object dependencies and it shows those as being correct. Any suggestions or comments would be greatly appreciated!!! I am truly only a novice when it comes to Access and just in the past 6 months or so have been using it regularly.

Thanks in advance.

View 4 Replies View Related

Recording A Formula In Control Source

Jul 20, 2005

I am pretty new to access, and I am wondering how you record the output of a formula in control source. Here is what I have.
I am trying to find how many days are between two dates. The formula that I put in the control source in the form is =IIf([txtQSFNonQSF]<>"qsf",CalcWorkdays([earlydater],[earlydatec]),"")
but it does not record to the field datecompleted.
How do I get this to do it.

Thanks
Greg

View 4 Replies View Related

Tables :: Recording Multiple Dates?

Apr 24, 2013

I'm creating a database and wanted to set up my table.

It is for a service with clients where we need to carry out a review every 6 months, so I need to create a way of entering a date every time a review is completed, then ideally a field that automatically totals the number of reviews that have taken place, and another field that automatically generates the date of the next review due - based on 6 months after the last review date.

Is that possible? It seems silly to keep adding fields for potential reviews as most will only have between 1-3 but in theory it could be as many as 20, which would be a lot of wasted space and fields for most people!

View 1 Replies View Related

Tables :: Recording Log In And Out Times By User

Mar 24, 2015

how I record user log in/out times in a table with Access 2013.

View 2 Replies View Related

Help With Customer Referral Information, Recording And Showing

Feb 5, 2007

Hi,

I want to record and show some referral info.
I would like help on where to record and how to show the info.

I want the infor to be shown per contact, in the contact details screen.
See below for details.
http://img506.imageshack.us/img506/5707/accesscontactdetails2ej4.jpg
I am really struggling doing this.

View 7 Replies View Related







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