Forms :: Add Two Fields And Store In Another Field

Apr 11, 2015

I have a form (frmFeeIncome) based on a table (tblFeeIncome)

On the form I have three fields which are FeesMonth, FeesYear, FeesUK (currency), FeesElsewhere (currency) and FeesTotal (currency). Each new record is entered like this

January 2015 25000 25000

What I need is for the total in the FeesUK field and FeesElsewhere field to be added up and stored in FeesTotal when FeesTotal has GotFocus

The FeesTotal has to be stored (I know it shouldn't be but it has to!)

I have tried the following in the GotFocus Event procedure but it does not work.

=[FeesUK] + [FeesElsewhere]

View Replies


ADVERTISEMENT

Forms :: How To Store Calculated Fields Into A Table

Oct 16, 2014

How to store a calculated field into a table

I am preparing an invoice and I have a field called deposit .Now this field calculates %40 of the total of the order .but if the user wishes they can enter what they like .Now this field must be stored in a table for ever and a day and must not change or the invoice will be useless .I can see no other way of doing this and my research tells me (allen Brown) that this is sometimes necessary .

View 4 Replies View Related

Forms :: Store User Name In Table And Show Up In Field

Aug 27, 2014

I managed to count the performance of users. The only thing I need to do is to put the names of the users on the form (under different tab) so I can select them and they show their performance. The best would that they are showing up there in the form till I change the names. I use now a text field to write the name, but when I close the database and open, I need to add the name again.

If I could use somehow the names from the users stored in a table, that would be great.

View 4 Replies View Related

Checkbox- Store Data In One Of 2 Fields

Jul 28, 2005

I would like to know if I can control what field the check box enters the -1 value in my record depending on a value from another field in that record.
In my table called workbook I have fields called, phone type which is a text field, wall and wm entry which are both yes/no fields. I want to put one check box on my form to check when a wall mount is needed for the device. The thing is there are two different wall mount sizes. So I need to check the phone type field on my form, if the value is ENTRY then I need to have it enter -1 in the WM Entry field. If the field anything other than ENTRY then the -1 value should go in the WALL field.
Can this be doen and how do I code it?

Thanks in advance

View 4 Replies View Related

How To Store Equations On Fields Display And Edit Them In A Form

Apr 23, 2014

I would like to store equations on certain fields and display and edit them in a form.

I can't find a Microsoft Equation Editor control in the list of ActiveX controls. Is it stored as a .ocx file? How is it named?

In case Equation Editor can't be used within Access, is there another third party addin that provides a control with that functionality? It would be great if there were an application that accepted markup code like LaTeX as input so it were easier to implement a code to manipulate equations.

View 1 Replies View Related

Get Value From Unbound Text Field From FORM And Store Value In Bound Field

Nov 5, 2012

I've created a data entry form w/ 7 fields.... [f1], [f2], [f3], [f4], [f5], [f6] are bound to a table. While [f7] is unbound and has Nz function.

Now, the value of [f7] is the summation of [f1] to [f5], i want that what ever value is generated by [f7] will be stored on [f6] in both forms and table...

View 1 Replies View Related

Modules & VBA :: Store All Records In One Field?

Feb 20, 2014

I have a table like this :

Fields 1 --- field 2

A --- tuesday
A --- wednesday
A --- thursday
B --- tuesday
B --- wednesday

I want to end like this :

Fields 1 --- field 2

A --- tuesday,wednesday,thursday
B --- tuesday, wednesday

I was thinking of doing a loop in vba with recordset and a filter on field1 and concatenate the days of field2 in the first reccord of each letter.But my table is big so my code needs to be fast.

how to do this ?

View 3 Replies View Related

How To Set Up A Field To Store Irrational Or Recurring Decimals

Dec 13, 2011

How do I set up a field to store irrational or recurring decimals?

Eg 1/3, 1/6?

I'm trying to store times, so they can be added up later: The idea being that 1h20m would be 1.3333333333333333333 etc.

View 2 Replies View Related

How Can I Store 500KB Text Data Into A Memo Field?

Oct 15, 2006

Hello,

The title says it. I want to store 500KB text data into a memo field. How can I do that?

Someone told me there is no limit on the size of a memo field, up to the maximum for a .mdb file of 2GB!!!

Your help would be greatly appeciated.

View 9 Replies View Related

Tables :: Check Box Field - Store Only Two Possible Data Choices

Oct 7, 2014

Is it possible to create a field in a table that stores only two possible data choices: a check or null value ?

View 6 Replies View Related

Any Special Character That Will Allow To Store Date Field Blank?

Apr 30, 2013

I am building a database for a client who manufactures car parts. I have a table to store vehicle model. Each model has a date range of production. I have two build dates from and to. Both of these fields are setup as date fields on the table. I made both fields required with a mask for validation. In the "build date to" field if a car is still in production I need to leave the field blank. Is there any special character that will allow me to store a required field blank.

View 2 Replies View Related

One Query Cannot Store 2 Different Textbox In Different Forms

Nov 26, 2005

One Query cannot store 2 different textbox in different forms:
Query Name: rem

Form Name: QR
Form Name: Pro

Query parameter: Forms!QR!txtbox1
Forms!Pro!txtbox2

I tried it, it cannot run.
If you run the form "Pro" and run the query rem, then you will get the message:
Forms!QR!txtbox1?????

same thing if you run the form QR and the query rem

View 2 Replies View Related

Forms :: Store Lookup Value In Table

Sep 9, 2014

I have form with student details on it and I want to add some additional information against that student (stored in a seperate table). I've created a form to input the data and a button on the main form to open the new form.

On loading the form I've brought with it the name of the student but I also want the UPN. I've done all the above fine.

What I need to do is then store the UPN in a field in the new table which is where I'm stuck.

What do I put in the Control source to make it store it. Currently I just have

=[Forms]![PupilPremiumStudents]![txtUPN]

View 9 Replies View Related

Forms :: Buttons To Store Actions And Dates?

Apr 8, 2015

Suppose I need a database with customers, able to store: what different events, were performed on what date.

So let's say possible actions are: a customer called, emailed or visited.

(note, it might be possible that a customer both called, emailed and visited on the same day)

Should I start with four different tables for: customers, called, emailed, visited? Or would the three actions just go into one table?

Another aspect that I don't understand at all yet is how to proceed with the dates.

Should I create another table with a long list of possible dates for the coming x-years?

I would like it to work:

I am thinking about creating a form with buttons behind the terms 'called', 'emailed' and 'visited'. When one of those buttons is pressed, I want an entry for that action, day and customer entered in the database.

So that later on I could e.g. look up on what day how many customers called, etc. etc.

View 11 Replies View Related

Forms :: Display Absolute Value But Store Negative Value

Nov 18, 2014

I have a subform displayed in Datasheet form and I would like to store in a field negative integers. But, for UI and usability purposes, I don't want the user to have to write the "-" for the negative value to be stored. is it possible that the user will write the number i.e. 1 and in the table -1 will be stored?

View 7 Replies View Related

Forms :: Store Calculated Values Into A Table

Jul 20, 2015

I am trying to get a value from a textbox into a table I created...

The textbox "calculates a number based on which radio button is pressed example if radio button 1 is pressed it returns 0 if radio button two is pressed it returns 8 and if radio button 3 is pressed it returns 15." I need to save the 0,8, or 15 depending on which radio button is pressed into the table...

I know you aren't supposed to store calculated values into a table but the report would never need to be changed and it just saves a new one each time with that being said anyway to make this work would be very useful!

Also how can you use the answer of calculated textboxs in other calculations?

View 14 Replies View Related

General :: Possible To Store Forms And Reports In Separate FE

Jul 27, 2013

I have an A2007 database used for time and billing. As time goes on I've had to add more forms and especially more reports. I feel the because of all these "additions" the FE is getting a bit bloated, something like 2.2MB right now.What I want to inquire about is the possibility of moving at least some (if not all) of the forms and reports to another FE and can this be done without having to move tables and/or queries?

The navigation pane is "hidden" from the users so they don't see all the tables, queries, forms and reports but some are smart enough to figure out to "unhide" the navigation pane.Concerning the forms; there are certainly some forms that I do not want other users to open out of curiosity, or for whatever other reasons they might have, so these I would want to move. The same basic reasoning would apply to the reports.

My thinking would be this; move a particular form/report to a separate FE that merely acts as a "bucket" to store the form/report. Clicking on the control in the main FE would open the form/report stored in the other FE using the tables and queries in the main FE.can it be done without having to re-write a bunch of code? I know I can add code so certain controls aren't visible to certain users but I've not found a way to permanently lock and hide the navigation pane.

View 4 Replies View Related

Forms :: Store A Value From Subform In Main Form

Sep 19, 2014

I'm getting a #name? error in my text box in the footer (doesn't matter where this is placed on main form. I've changed this to be forms. and forms! but no difference in the outcome.I just want it to view the total figure from a purchase order subform. This is populating correctly but isn't being stored anywhere, just shows.Also, any way I could make this invisible when the form is in form mode?

View 3 Replies View Related

Modules & VBA :: Store Entire Query (single Field) In Array And Check Its Values

Mar 12, 2014

Basically, what's the best practice or how do we store a query's value into an array then checking what the max or min value is and how to check if let's say "4" is in the array?

View 1 Replies View Related

Forms :: Text Box To Store Numbers - Thousand Separator

Aug 11, 2015

I have a user input form with a text box that stores a number. When the user inputs the number, I'd like it to display the comma separator (e.g. "1234" becomes "1,234". I've tried putting "#,###" and "#,##0." into the format property of the text box, but I still get 1234.

View 4 Replies View Related

Forms :: Possible To Store Colors In A Form Or Table And Then Reference Them While In VBA

Dec 5, 2014

I am trying to see if it is possible to store colors in a form or table and then reference them while in VBA. What I am hoping to do is when I write all my code for command buttons to change On Got Focus, instead of writing xxx.backcolor = RGB (255,255,255) i could do something like xxx.backcolor = Forms!HiddenColors!Command That way if i want to ever change the color scheme of the db, I can change it in one place rather than hunt lines of code.

I have played around but with no success. Technewonline is a website that specializes in introducing the latest technologies such as Best Tablet Android Have Price Under $200 and Best tablet of Apple in 2014 and The Best Midrange Smart Phone In 2014 and Top Best Ultrabook Of 2014 and The Best Phones 4G Valued At Under 300 USD is also a website for sharing your tips about computers, mobile phones and tablets, products are available from leading supermarkets will surely satisfy you.

View 1 Replies View Related

Forms :: Way To Store Record Number In A Form Textbox

May 24, 2013

I have a Form with data entry property = No. If a user clicks the page down button accidently, this could move the form to the next record even when cycle property = current record. I want to create a macro that fires a message whenever the user clicks page down and moves to the next record.

Question1:Is there an event that is somehow linked to a user moving into the next record.

Question2: Alternatively is there a way I can store the record number in a form textbox. How can the record number be captured via a simple macro action ?

View 1 Replies View Related

Forms :: How To Store Data From One Textbox Into Another On Button Click

Jul 2, 2014

In my form, when a button (cmdContactedToday) is clicked, a text field to the left (txtDateContacted) is updated with today's date.

However, before this happens, I want the the current date in txtDateContacted to get stored in another (hidden) text field (txtPreviousDate)

Then when another (undo) button (cmdUndoDate) is clicked, the date in txtDateContacted should get replaced with the date in txtPreviousDate.

I've made it as simple to understand as I could.

View 14 Replies View Related

Forms :: Do Combobox And Radio Button Store Only Numeric Value

Feb 11, 2014

I would like to store the string in my table when I choose a string from a combobox or radio button in the form.For example, if I choose 'Business' ( from major field in my department table ) in my combobox, I expect there is a 'Business' in my major field in my department table. And if I click radio button labled 'A' (position field), I expect there will be 'A' in the position field in my table. However, those only store numeric values, for example '3' for 'Business' and '1' for 'A' in the table. How can I store the 'real value' in my table instead of number when I choose them.

View 3 Replies View Related

Forms :: Sum Total Of 2 Fields On Third Field

Oct 22, 2013

I've tried many things (compact and repair, Nz(,0), sum()) and I can't get it to work.

I entered =[field1]+[field2] but it behaves like if I had entered =[Field1] & [Field2].

Yes instead of adding the numbers it just puts them together.

For example: Field1=3 and Field2=5 instead of field3=8 it shows Field3=35.

View 3 Replies View Related

Forms :: Copy Certain Fields To Another Field In Same Table

Sep 8, 2013

I am using MS Access 2010 and I am trying to figure out how to copy a field(s) to another like record. For example I have simple split-form that contains detail items purchased (product number, item purchased, cost, etc). I have a check box call "chkApproved" and date box called "Approved Date". The user have a choice to select the invoice number, once selected the invoice number (there maybe anywhere from one or 2 to 4 rows based from the same invoice number).

The manager will go to the first record and check the "chkApproved" and date is automatically updated as today's date (Approved Date). This is fine if there is only one row, but when you have the same invoice number with 2 to 4 rows the user has to go to each row and check the box. I want to somehow automatically populate the rest of the rows within the same invoice number I don't need to create a new record only updating the existing records.

View 2 Replies View Related







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