Hi all,
A nice easy one for you. I am creating a database, one of the fields is total cost. Is there an easy way to have another field, which calculates the VAT without using a query? I would like this done as soon as the total is entered.
I have done this using a query, but didnt like this way.
I am sure there must be a very simple way of doing this but it has escaped me.
Help
Phil
I need to place fields on a form that is not linked to a table or query. Form was built by my predecessor and it already contains multiple fields, however the form itself is not linked to any data source. I have tried hardcoding the field onto the form, but it didn' take. How is this done?
View 1 Replies View RelatedNeed help placing fields on a form that is not linked to a table or query. The form was created by my predecessor. The form already has multiple fields on it, however the form itself is not linked to any data source. I have tried hardcoding the filed onto the form but it didn't take. How can this be done?
View 1 Replies View RelatedI have a form that I am inputting data into. I have been able to Clear the form. I have created an edit script and it brings the data from the table to populate the form. When I try to change the data in the form and run a VBA update to push the data down to the table I am having no luck. I can add/Delete recordswith no problems but I can't edit them and put them back in the table. I am novice and just learning the formats and scripting.
View 7 Replies View RelatedI have just tried experimenting with placing a Chart control within a form (Access 2010). Although the chart ultimately seems to work (based on my one simple example), I'm getting an Error 1907 (Could not register font.......) each time I launch the database or reload or edit the form.
This error message is itself contained within a "Configuration Progress" screen for MS Office Prof + 2010 which seems to complete if I select Ignore the error message but runs again each time the database is launched (with the same error message showing up part way through). I am logged on as Administrator.
I've got a table set up with sales info and all other kinds of data. How do I get a formula to work? Here are the inputs I have: Total sales (by outside company), total purchases (from my company). I want to know what percent of their total sales are made up of the poducts they purchase from me and have that field update automatically. Its a simple formula really, I just don't know how to enter it properly. Thanks.
View 2 Replies View RelatedHey guys hope someone can help me out here...
i need to have a currency field in one of my tables, the user will enter the price in euros, and the output will be in pounds... therefor i need the following formula to work:
[enterdprice]*[current exchangerate] = price in pounds
i would very much appreciate suggestions/help
hi i have a text field in with this calculation
=([Total amount requested]+[text3])/[Initial valuation]
it displays a div/0 error which i want to remove, i know i need to put this calcualtion in an iif statement but whenever i try and make the formula it never works
=iif([Total amount requested]+[text3])/[Initial valuation],?,""
where the question mark is i am not sure what should go there, as i want the total to of the calculation there and if 0 hide 0 with the ""
this has been bugging me for a while now and i can just get my head around it, probably very simple for someone to answer
regards
chris
I am trying to make a query using fields from multiple tables. I used the Expression builder to create it and it is a formula field where multiple table fields are involved. But whenever i run the query Access asks for a parameter value in a modal dialogue for the value of the fields. Is it because the field names has Square brackets around it? But access puts that automatically. How to make it work properly?
View 11 Replies View RelatedI have a field in my query which returns results based on a formula that is a function of other fields. The results are: Pass and Fail.
I want to make a query that returns only Fail rows. When I enter Fail as the criteria, a parameter box pops up requesting information be entered before continuing.
How can this problem be rectified?
I need to add a text box to my report that shows the value of a record in a certain field that is corresponding to a given value in another field.
For example, if my report shows the following:
N City
3 D
7 F
2 H
9 K
4 A
the text box should show the name of the city corresponding to the largest number which is in this case "K". is it possible through formula builder?
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
I have a field in my query which returns results based on a formula that is a function of other fields. The results are: Pass and Fail. I want to make a query that returns only Fail rows. When I enter Fail as the criteria, a parameter box pops up requesting information be entered before continuing.
View 1 Replies View RelatedI have rcently produced a label report for my Xmas cards, and I would like to add a picture to the label in the form of Father Christmas. Can anyone help me on this subject.
View 1 Replies View RelatedHi All:running Access 2000.I have a qry with a formula field that performs some calculation (Extension: CCur(([OnHand]*[Price])/[UnitsPer]))and it works fine. How can I update the actual table with the result of the calculation for every record? The problem I have is that there's some null values in the results therefore when I try to get totals on that field, it errors out saying "invalid null use"thanks
View 7 Replies View RelatedI got a table salaries master I want to extract some info out of and calculate some values. The formula below doesn't work, I'm pretty sure it has to do with [pay period] being a text field. Is there no way to make it work?
'Gross monthly Salary: IIf([Salaries Master]![Pay Period] = "weekly";[Salaries Master]![Daily Wage]*5*52/12,IIf([Salaries Master]![Pay Period] = "monthly";[Salaries Master]![Daily Wage]*20))'
I have a date in "date to engineering" of 13/ 01/2010 but I am not getting a value in my field which should be 1479 my field is just always returning an empty field
Code:
=IIf(IsDate([date to engineering]),"",IIf(IsDate([date from engineering]),Now()-[date to engineering],[date from engineering]-[date to engineering]))
Hi,
I've performed a search using a SQL statement which is based upon the results of two combo boxs.
Combo66.RowSource = "SELECT Product_Id FROM Product WHERE (Name_Suffix='" & Combo60.Value & "') AND (Name_Family='" & Combo56.Value & "');"
There will only ever be one result, I can display this result in a combo box without problems but I would like to display it in a text box. Is this possible?
I'm very much a newbie to Access so any help would be greatly appreciated.
Thanks
Lee
I have a database with a couple of search forms to use for my company. My boss wants me to place this on the intranet so anyone can use it not only those with MS Access, which many people do not have on their computers. Please let me know if there is a way to do this and still make it interactive by means of searching. Thanks
Riley
Hi everybody.
I'm trying to secure the table records in my db. I'm looking for something that will allow me to input regular text from a form and then once the form is closed it would add texts to the record that is stored in the table record.
Example: Input "HELLO" into form.
Table record would show record as "xegaHwueEoieLwoiLiwoO"
Also, recalling the text would also have to be able to revert the jumbo text back to regular texts also. This would be needed for forms and reports.
Any help, much appreciated.
Ok so I'm very new to access. What i want to happen is for there to be a textbox on a form that changes depending on what is in the other text boxes. Eg 1st box = 1, 2nd box = 2. I want the third box to equal the ammount of the first two added together (textbox1 + textbox2 = textbox3) how do i do it? Where do i put the formula. Thanks.
View 1 Replies View RelatedI have a database I inherited that I'm trying to do some clean-up on. One of the things I want to add is a text box on the startup page that tells users the date of the most recent record in the DB. The date field is stored as "Batch Posted Date" (already yelled at them for spaces) in a table called "Adjustment Data."
I tried using =Max([Adjustment Data]![Batch Posted Date]), but I get #ERROR. I thought it might be a problem because of the spaces, so I wrote a query to pull the max value of the date, and tried dlookup. When I try =DLookUp("maxofbatch posted date","qryHighDate"), I also get an error message that says #ERROR.
I'm a bit new to formulas in Access, can someone help me out?
I am trying to write a query that selects multiple rows of a table and puts those into a single string with a comma delimiter.
I want it to select all rows after a specific word is found in the row above and then stop selecting when another specific word below the last row is found.
Example below: >>>
The data i am using is very unorganised and has not headers, so I have to try and specific lines in order to allocate them to a specific user.
Sample Data:
IDFullContent
459Authorized Privileges:
460ACNT ALLSPOOL ALTPRI AUDIT BUGCHK BYPASS
461CMEXEC CMKRNL DIAGNOSE DOWNGRADE EXQUOTA GROUP
462GRPNAM GRPPRV IMPERSONATE IMPORT LOG_IO MOUNT
463NETMBX OPER PFNMAP PHY_IO PRMCEB PRMGBL
464PRMMBX PSWAPM READALL SECURITY SETPRV SHARE
465SHMEM SYSGBL SYSLCK SYSNAM SYSPRV TMPMBX
466UPGRADE VOLPRO WORLD
467Default Privileges:
Output Expected:
"
ACNT,ALLSPOOL,ALTPRI,AUDIT,BUGCHK,BYPASS,CMEXEC,CM KRNL,DIAGNOSE,DOWNGRADE,EXQUOTA,GROUP,GRPNAM,GRPPR V,IMPERSONATE,IMPORT,LOG_IO,MOUNT,NETMBX,OPER...etcc "
The delimiter can be anything.
I created a Access 2010 database query to allow a user to search a list of orders between 2 dates, and I created a form for them to use for this search.
Then I created a report for the search results to land on. What I want to do is have the 2 dates that the user provided be displayed in the header of the report.
I created a new Text Box and placed it in the header. In place of the "Unbound" filler that was there, I placed
"=[Forms]![frm_DateRange]![txtStart]".
I used the following steps to do this:
Clicked on the Text Box controlPressed the "Property Sheet" buttonSelected the "Data" TabPressed the "..." button next to the "Control Source EntryThe "Expression Builder" came upDouble-clicked on the database name in the "Expression Elements" windowDouble-clicked on "Forms", then double-clicked on "All Forms"Selected the rpt_DateRange" formSelected "txtStart" from the "Expression Categories" window.I did not select anything in the "Expression Values" window.
When I go to "Report View", and see the Text Box I added, but inside it, it just says "#Name?"
I've built a table and used it to build a form. One the form I have three boxes, one to enter the DoB, and two others that record the age and also put the individual into an age bracket.
In the latter two categories I have entered a formula in the Properties Box under Data & Control Source (the formulas are below) to automatically work out what the age and age bracket is when the DoB is entered. This works fine but the information isn't transferred back to the table.
Do I need to do the info in the table first and then update the form? And if so where do I enter the info in the field properties in the table design view?
=Int((Date()-[DOB])/365.25)
=IIf([age]>=50,"50+",IIf([age]>=35,"35-49",IIf([age]>=25,"25-34","16-24")))
Many thanks in advance
I am getting an error everytime I try to use the SumIIF formula in my form.The relevant fields are Qty, Unit Price and Vatable (check box)..I then created a field in the form's footer with the following formula
=Sum(IIf([Vatable]=Yes,[Qty]*[Unit Price],0)