Total Noob Can't Update/append Form Field
Jan 14, 2004
Hi guys- totally in the frying pan here...I can't seem to get past this initial stumbling block with Access
i've made a simple form that "should" create a primary key from the first two digits of a clients last name and last four digits of their phone number...i've tried an update query button and a refresh data button...the key field gets filled in on the form, but it will not transfer to the underlying table...I keep getting a null value error for the key....any help would be greatly appreciated...
heath
View Replies
ADVERTISEMENT
Dec 20, 2007
Hi,
I am trying to put together a mailing list to send out invitations to local schools.
I have exceed documents with several school addresses and I need to add to each school, a listing for all of the homeroom teachers (i.e. 1st grade homeroom teacher, 5th grade homeroom teacher, etc.) as well as Art teacher and counselor for each grade
How do I create a querie that adds the title (art teacher, principal etc) to the list of addresses?
I am not very Access savvy so, you may need to dumb it down a bit. Feel free to ask any questions.
Thank you.
Doug
View 1 Replies
View Related
Oct 30, 2012
After testing it, the database got corrupted. I had backed it up just prior to using this.
It was something like = Sum(Abs[AmountPaid], [Paid] = "X")
I have a continuous subform with an "AmountPaid" column. The total is displayed in the subform footer. I need it to display the total for only the fields with an X in them denoting that they were paid. This total should match the statement we receive.
After clicking the button to put the X in the Paid field, then I used the formula to update the AmountPaid field.
Joe..........10..... X
Al..............5.....X
Flo.......... 25
.....Total = 15
View 3 Replies
View Related
Sep 13, 2005
Hi all,
First of all....my first access database and I'm still a VB newbie...so my apologies if this is a stupid question. I tried searching the web and this forum but could'nt find what I was looking for.
Basically, I am developing an authentication script for a training tutorial. The user either logs in with there existing info, or prior creates a new record. When they login they also select a team (eg Team 1, 2, 3, 4, admin and so on). This is selected from a combo box - the teams are on their own table.
I have another table storing the user info - name, password, the users team...and so on. When they log in and the team selected does not match the team in 'tblusers' - I want access to change the record to reflect the new team.
Can anyone help me with the code to make this happen? So far I have -
If Me.defineteam.Value <> DLookup("Team", "tblusers") Then
MsgBox "You have changed team. This will now be updated", vbOKOnly, "Required Data"
GoTo verifypassword:
End If
This authenticates the team....I just don't know how to replace the one in the record with the value in the combobox.
Thanks for your help.....I'm losing hair!
cheers
Sd
View 7 Replies
View Related
Dec 2, 2007
Hi guys,
I was wondering if someone could help? I am using Access 2002 and I am struggling to find out out how you can insert/update/delete records through a form using the design view. Is this possible or do you need to do this another way?
Could some one point me in the direction of a comprehensive tutorial or outline some instructions for what I need to do?
I need to create a form that inserts people's details into a table
When user types in a surname as a parameter query, up pops the form with the details of the person stored in the database, and the user can update the details through the form and the details are saved to the table they came from.
Thanks in advance!
View 9 Replies
View Related
Nov 7, 2013
is possible to run an Append Query and update a field at the sametime?
i.e. I would like the MealDate field to be incremented by 1, just not sure how to write the code within the query!!!
This is what I have so far!!! not working
MealDate: ([MealDate](Date()+1))
View 5 Replies
View Related
Feb 25, 2014
I am giving two tables and I need to create a macro that automatically updates these tables depending on the value of a Yes/No field. If it's No, it's in the 1st table TableOne, if it's Yes it automatically updates to TableTwo.
So, the best way I saw to go about is to set up an append query and then create a macro that runs it
So my tables have the values FirstName, LastName and isValid (more but keeping it short)
So for my append query, I put TableTwo in the pop up I get. Then, where it asks for the field I put it
Field:FirstName
Table:TableOne
AppendTo:[TableTwo].[FirstName]
Criteria:[TableOne].[isValid] = 1
I do this for all (it was autocompleted except the Criteria field). I tried to keep Criteria with data only for isValid but that didn't work. I wrote it for all the field names, still didn't work. Whenever I click run it says it'll append 0 rows.
View 5 Replies
View Related
Aug 12, 2005
Hello everyone,
I'm quite new to access (used to php mostly) and for usual task it's ok but now I have trouble for a quite simple query I think.
I have to compare the values from 1 field and select only the rows just before the value becomes smaller and also the very last row.
example:
if I have a row with 1, 2, 3, 4, 1, 2, 3, 4, 5, 1
I need to put 4 and 5 in an other table
View 1 Replies
View Related
Sep 14, 2007
I have to count the number of records in a subform that meet certain criteria. I have a yes/no field and presently have a field in the subforms footer that =Count(*) and I would like to be able to count only the "Yes" records. Is there a way to use the count function to do this.
View 4 Replies
View Related
May 4, 2015
I have three tables (Group, Customer, Savings).
Every member of a group do savings once every 15 days and each group has maximum 20 members, group has one to many relationship with customer and customer having one to many relationship with Savings (there is no direct relationship between group and savings) i have created a continuous form for saving entry. in this form i select a group which is unbound and based on that group, its members are listed in the combo box named CusID, after selecting customer other saving details are entered.
What I want, is that for every group i want a total saving for all that specific group's members selected in the mentioned unbound combo box in that continuous form, this total should be based on the group selected in the mentioned unbound combo box, in case i select another group the total should also be based on newly selected group.
View 12 Replies
View Related
Jul 15, 2015
=([frmservices_2013].[Form]![sub2013])
I have this expression in a field on a form. It's been a really long time since I worked in Access. Is sub2013 a field on a form, in a table?
It's doing a running total of a field from a form. I can't find a subform with this name, or a field anywhere, I'm drawing a blank.
using Access 2007....
View 4 Replies
View Related
Jun 10, 2006
Hi.
I am setting up a database to run a shop. In my 'Orders' form, i have a subform of the order details (The item (combo box), price, quantity and subtotal (price*quantity).
In the form in which the subform is displayed, how can I display the total of the subtotals? Is it easy, could anyone show me roughly what i need to write?
Many, many thanks,
- Smiffezo.
View 2 Replies
View Related
Dec 16, 2004
I have a report with a calculated field. This calculated field needs to pull the value or total from a field in another report. I think the formula is :
=([AssmntC].Reports!totalreqamnt4)
but I'm getting ?Name as the result.
The report is AssmntB where I need to have the value copied.
The original report is AssmntC and the field is totalreqamnt4 where the value is originally calculated.
totalreqmant4 is also a calculated field which sums fields from a query.
Help with the formula? please?
View 2 Replies
View Related
Jun 16, 2015
I wanted to take the values from the frmInvoiveItems' [LineTotal] field, subtotal all of them for a given invoice ([InvoiceApplied]), and place them in a new field under frmInvoiceInfo that I haven't created yet.
(I.E. I have three different items under frmInvoiceItems for one invoice. They all have a different price. I want to add all of their prices together, and display them in a "Total" field in the frmInvoiceInfo table. This new "Total" field should be the total amount due minus the "Deposit" value and anything in tblTransactions [I still have to figure out how to assemble that too... another question for another time]).
Is all of this possible without me having to store the information in a query? How?
View 11 Replies
View Related
Nov 13, 2006
Hi all, I'm pretty new to Access, but catch on quick. I have posted this question at another access forum, but have not received any input - maybe it's in the way the question was asked.:confused:
I have a developed a database to track patient ID, patient name, then several other fields of data such as therapies recieved, medications etc. The main form is used to input the data for each record.
The point I'm at now is the switchboard. I have created a command button that when pressed will open the main form at the first blank record for data entry on a new patient.
I want to add another command button that when pressed will open a pop-up/form/text field that will allow me to input a search criteria. The two criteria I would like to use are Patient ID or Patient Name. When the search criteria is entered, I would then like for the main form to appear at the record specified by the criteria for record editing.
Clear as mud? I'm pretty sure there's a fairly easy way to go about accomplishing this task, but I'm clueless. I have tried a couple of different routes, but wanted input from you guys about what would be the easiest way to address this.
Thanks in advance.
Frank
View 3 Replies
View Related
Sep 12, 2005
I am creating a form utilizing all of the fields of my table (table1). I want the form label names to be from the description of the fields from table1. I have over 50 fields and was wondering if I could do this automatically.
Example:
table1
Field: Description:
Policy_Date Date policy began
Form
Label: Text Box:
Date policy began Policy_Date
Any help would be appreciated.
View 4 Replies
View Related
Apr 6, 2013
I have a form that is displayed continuously and there is a text field in it (Text12).In the footer of this form I would like to add a textbox that is the sum of all Text12's on the form.I tried =Sum([Text12]) in the textboxes control source but that is just displaying an error when I run the form.
View 2 Replies
View Related
Apr 25, 2006
I think I can achieve what my boss wants with just one table.
I work in a legal department and we track employee contract complaints/issues. Simple data entry is used and one table (Complaints Table) has been created with fields like: employee name, emp #, what union rep issues the complaint, who from our department responded, when the complaint was sent, when the response was sent, two memo fields to describe the problem and the resolution, and ... perhaps most importantly... contract section.
It is possible that one complaint could touch on multiple contract sections.
The data-entry form I've created has the following fields:
contract section 1:
contract section 2:
contract section 3:
Now I need to create a Search Form and I'm having all kinds of headaches trying to understand how to make this work... trouble with setting up the right macro, too.
I'd like the main form to contain the following search fields:
Rec # (which is set as an autonumber in the "Complaints Table")
Employee name
Employee #
Contract Section
...or perhaps just a "contract section" search form...
1. If a contract section # is entered, I want to push a button and have every record of that contract section # filtered from the database and show exactly as the data-entry form beneath the "search" portion of the main form.
(did that make any sense?). I know how to create a general form and subform, but the subform always shows up as a table object rather than a form object. How can I fix that?
2. Some contract sections might be numbered: 3.A.2. ....others might have a longer name like 22.C.3.a.vi.(b). ....
Obviously, the filter/search needs to catch all records which include the contract section specifically, regardless of which of the three "contract section" fields from the main data-entry form contain data.
What's the easiest, non-VBA way of setting that up?
I just know nothing of VBA.
Any help is greatly appreciated...
tango..
View 3 Replies
View Related
Sep 1, 2013
In my database main form with subform. subform have query as recordsource.total of one of field in subform shown on main form. all is ok and show total correctly but when subform have no records then total field on main form shows #error. How to convert this value either into null string or zero(0).
View 2 Replies
View Related
Jun 11, 2015
I have an access form (Customer) along with a sub-form (Work_done). On sub-form I have Running sum of Amount in Text box-1. I want that Total of Running sum be replaced with Main form's tables field total_amount. Is it possible that we can replace an amount of control of sub-form into main form's field?
View 1 Replies
View Related
Aug 17, 2006
Group,
I thank you in advance for considering this inquiry.
From within a Form.field (based on a master table query), I desire to trigger two events; one before update and one after update.
This function will serve to document specific form.field value changes to a "log" table for review prior to being committed back to the master table.
What I'm looking for are functions, which I can use in a Macro or VBA code to facilitate a field read and copy before change and a read and copy after change triggering.
I'm sure this is absurdly simple.
View 2 Replies
View Related
Feb 12, 2015
I have a main form and a subform.
Both forms have the field called JobID in common.
Both forms have a field called JobStatus.
Any easiest solution so that After I Update the field called JobStatus in the subform, it changes the field called JobStatus in the main form to the value which was selected from the subform?.
View 3 Replies
View Related
Apr 25, 2013
I have 3 peices of data that I am working with: Group number, plans and benefit elections. On my form I have fields for the group number and plan and 2 queries. When I enter a group number the first query displays a list of plan descriptions for that group. From there I can enter the plan description into the form's plan field and that runs the second query to give me a list of valid elections for that plan. This all works fine but I want to make the plan selection a little less tedious. What I would like is to be able to double click the query field housing the plan description and have it copied to the form's plan field. I could use the ID instead of the plan description but I work in a production environment and very key stroke counts so I would really like to have a simple double click process.
Is this even possible? If so how would I set that up? I tried using the double click on event macro builder but it does not seem to have this kind of option.
My form contains fields for group number and Plan. The same form houses 2 querys, one that pulls plans based on the group number and the other to pull elections based on the plan field (not the plan query). Would like to double click a plan within the plan query and have that description populated into the form's plan field.
View 6 Replies
View Related
Jun 21, 2005
Can anyone tell me how to modify data in a querry befor appending the data to a new table
Thanks,
View 3 Replies
View Related
Aug 12, 2005
Hi
Can someone please explain to me what I'm doing wrong.
I'm trying to update my table called Portfolio with information sent to me via spreadsheet. I've been able to import the data from Excel into a table called PortfolioUpdate and the data types are all the same, but when i try to run the append query it keeps coming up with the message below
Switchboard can't append all the records in the append query.
Switchboard set 0 field(s) to Null due to a type conversion failure, and it didn't add 1889 record(s) to the table due to key violations, 0 record(s) due to lock violations, and 0 record(s) due to validation rule violations.
I've checked that all the data types are the same and I've also removed/added primary keys from the PortfolioUpdate table to see if that was the problem but to no avail.
Am I even doing this right?
If anyone could help that could be great
Thanks
Trish
View 11 Replies
View Related
Sep 19, 2005
Just wondering if someone can point me in the right direction so that i can solve my problem?
Basically what i have is a select query that carries out some calculations based on data entered. These calculations are expressions as i am sure you guys know. what i want to do is put the value from the expression/calculation into my table in the correct fields made for these values. However i have tried everything i can think of to get this data into the tables fields but to no avail.
example. Expr1: [field1]*[field2] the answer created by [Expr1] is the value i want to be placed in [field3]
Can anyone help me on how i can do this
View 4 Replies
View Related
