I have an employee field in my purchase orders from and when I do stock transactions - i have an employee field against each item in the purchase order. I would like to just copy the employee field from the purchase order form automatically next to each product listed instead of having to keep typing the same thing.
the reason i am doing this is because when people come to take stock out - i would like to see there name against each item in the products from so people can not not take more than they ordered.
I have a Form that has a subform and in that there is a subform that runs a query. I need to take the value of in one of the fields returned in that query and transfer it to a field in my original subform.
Hi im new to msaccess so bear with me plz; is there any way to copy data from the first column ie say the primary key which is a autonumber to the next column because i cant seem to have two autonumbers soi was wondering if it the next column would update as a new record is created
say coulmn 1 is ID column 2 is NameID i want the autonumber generated in iD to appear in NameID
I need to create a New Form control for this situation:
If I enter a date into a field and the choice for another field is equal to a certain value. How can I get the date I entered to be automatically populated into another date field.
For example:
If I enter 11/10/2005 in a date field and I choose either "BN", "BA", or "BT" in a text field, I need that date of 11/10/2005 to be automatically populated in another date field on the same form.
I currently use forms for adding new pupils, and updating pupil subjects/arrangements/levels.
I also have forms to search for specific pupils, and to create lists for faculty heads showing which pupils are taking subjects within their faculty and the arrangements we expect to provide.
I use the forms to run queries, which can then output to reports for printing.
Where I am currently having an issue is the faculty field in the tbl-SubjectLevelArrangements. (If I didn't have to report to faculty heads I would just leave it out, but management will insist.)
Currently I have a form with dropdowns for adding subject, faculty, level and arrangement manually. This is acceptable for the subject, level and arrangement because they are completely interchangeable and dynamic throughout the academic year as pupils may drop down a level, or change the type of arrangement they require.
However as faculties are inextricably linked to subjects, I want to remove the possibility of human error. i.e. when a user (me) chooses either geography, history, or RE, then the faculty will always be Humanities, likewise if the user chooses French, German, or Spanish, then the faculty can only be Modern Languages etc.
I'm convinced there must be a very simple way to ensure that the faculty field prefills based on the limited keywords available in the subject field, but I just cannot figure it out.
I made a report that have 'txtRemarks' field, I just want to get remarks automatically in 'txtRemarks' field based on the other field in report. that is why I used a function like below:
Code: Private Function Estd_Remarks(Estd_Point As Long) As String If Me.Estd_Point < 20 Or Me.Estd_Point = 0 Then Estd_Point = "Earlier Established" Esle Estd_Point = "OK" End If Estd_Remarks = Estd_Point End Function
And I wrote in properties 'On Format' event this code below:
Code: Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer) If Estd_Remarks = "Ok" Then Me.txtRemarks = "Ranked & Sortlisted" Else Me.txtRemarks = "Estd_Remarks" End If End Sub
When preview the report then it shows Compile error Argument optional
I have two tables, each has a "status" for a project. In the first table there is only one instance of each project name, in the second table there may be more than 1, will always have the same name but may have a different "Status" (field).
I need the Status field of the first table to be set to "Assigned" if ANY of the records in the second table pertaining to that project are set to "Assigned".
Can I do this with my table or will I need to do it with a query/form combination?
In Access 2013, in a table named DOCSDETAIL or form, I want the UTENTE (meaning user) field (Currency type €) automatically receives the same amount of PVP field (Currency type €) but can be modified as needed.
Example: Registration of documents in which the amount paid by the USER has two possibilities;
1. DifferS from PVP (Public Sale Price) 2. Equal the PVP
Looks like it might be used
= "Update your_table set your_field_new = your_field_old"
= "Update DOCSDETALHE set UTENTE = PVP"
But do not know where to put and if the syntax is correct!
I didnt know whether to post this here on in the table forum, so sorry if its in the wrong place!!
http://x402.putfile.com/4/10309543998.jpg
http://x402.putfile.com/4/10309512643.jpg
Ok, so in the frist screenshot the green box is based off of the table labelled 3. The red box is comprised of the InvoiceID from table 1, ProductID from table 2 and name/price is drawn from table 3.
The green box is used to view products, the red is an invoice. How do I add the currently viewed product (in this case, a case) to the invoice? I need to copy the product ID from table 3 to table 2. How do I go about this?
I am having a problem with my frmAddCustomer. I need it so when a new record is entered into tblCustomer (via the form) the autonumber made in CustomerID will be copied and entered into tblDelivery.CutomerID. Thus making a new record in tblDelivery. The form uses a query will all tblCustomer fields and tblDelivery's CustomerID.
How do i go about making it so when a new record from tblCustomers, the autonumber generated is automatically entered into CustomerID of tblDelivery (leaving other fields in tblDelivery empty ready to be edited at a later date)(also how do i make it so when I open up frmAddCustomer it goes straight to a blank record instead of viewing already entered customers)
The database I've inherited has a primary key autonumber set up which is randomly generating numbers. It also has another field which has yet to be used, of a clients reference number.
I thought it would make sense to use the reference number field as the primary key, as it seems redundant otherwise and it would give us another field to perform searches on (if we record a clients reference number on their paper file, then finding them on the database would be much quicker).
Because of the relationships in the database, I didn't want to remove the existing primary key as I'm afraid it would mess up the whole thing. I was wondering if there is a way of having the autonumber which is generated in the primary key to be automatically copied to the clients reference number field? This would leave the primary key intact but give us this extra level of information to search on.
I am using access 2007 and cannot seem to find in the field properties.I need to input data in one field in a table and it appears in a field within a different table.
I have a main form with a field "Calibration Date" which shows the latest calibration date of a specific item. I have a subform that has a field "Cal Date" that is the latest calibration of this specific Item. In the Subform there may be multipul "Cal Date" enteries for that specific item but in the main form I want the "Calibration Date" to update to the newests Cal Date enetered into the subform.
I would like the text from the previous field Invoice_Contact copied into the field Invoice_Contact of each new record created. I think I can use CTRL ' - but would like it done automatically if possible.
Field location: Form = PatientUpdate - Subform = F_Invoice - Field = Invoice_Contact
The form and subform are linked through: Pat_ID
The subform is based on the table called Invoice with Invoice_ID as the primary key.I tried several variations of this DLookup from examples I found on the web but the field comes out with "error" in it and its flashing!
I have one memo per change (user input)...I need to have the comment the user inputs to copy into other records that were queried. I tried insert. My coding does one of the records or all of the records ..I need it to copy just to the queried records ...and I have a query but no filter set.
i have 3 tables: tblVolunteer, tblMedicalCondition, tblVolunteerMedicalCondition.
in tblVolunteer i have: volunteerID, volunteerName, HEALTHY (yes/no)
If a volunteer doesn't have a record in tblvolunteerMedicalCondition, i would like the HEALTHY field in tblVolunteer to default to 'yes', and if they do get a related record in tblVolunteerMedicalCondition, i would like the HEALTHY field in tblVolunteer to change to 'No' automatically.
i have 3 tables: tblVolunteer, tblMedicalCondition, tblVolunteerMedicalCondition.
in tblVolunteer i have: volunteerID, volunteerName, HEALTHY (yes/no)
If a volunteer doesn't have a record in tblvolunteerMedicalCondition, i would like the HEALTHY field in tblVolunteer to default to 'yes', and if they do get a related record in tblVolunteerMedicalCondition, i would like the HEALTHY field in tblVolunteer to change to 'No' automatically.
(*It really isn't code, I just couldn't figure out how else to keep the columns in place!)
------------------------------------------------------------------- Store Name Invoice Number Customer Name Customer Address Store1 1 Bob PO Box 55 Store1 2 Joe PO Box 789 Store2 3 Chris PO Box 1254 ------------------------------------------------------------------- On my input form, for entering a new invoice, when you select the customer name, I want the form to automatically fill in the correct address in the "Customer Address" field.
I think there has to be a way to do this because there is only ever going to be one address for every customer. And the same customers will be comming back very often.
I am currently handling an insurance operation. I have 5 Sales Executives (SE) who receives certain percentage of commission for each sold insurance policy. SE receives their respective commission on a pro-rata basis. Meaning, if they give 4 equal monthly payment scheme to their clients, they will also receive their commission -- 4 times.
Example: SE Commission for one sold policy is: 100.00. (Granted SE gives 4-month-term, SE will be receiving 25.00 monthly, upon cleared payment)
On my 2 tables lies the following fields: [Table1] SECom1 SECom2 SECom3 SECom4
This is probably very simple to do, but, I am most likely missing the obvious... I have 3 fields, UnitPrice, NumberPerUnit, and NumberPerUnitCost. I would like to have the NumberPerUnitCost field filled automatically based on what I have entered into the other 2 fields. I would also like to have this saved in my table as I will use this single unit cost when calculating some production costs. Any and all help would be appreciated. If I am going about this the wrong way, please redirect me.
My "MainMenuForm" contains a button that imports a specific csv on a specific location.Someone should do this import once per day. The problem is that there is no way for me, once the import has been done, to know which records are "new".There is no unique field that distinguishes the new records from the old ones.
I was thinking of adding like a Date() field to that csv (= the date where it was imported). Can this be done automatically? So if I import a file today, the final column would be 05/02/2015If i import a new file tomorrow, it would be 06/02/2015.
My boss has been asking me to create forms in which he can add new records at any time. He has different review cycles for each company he owns (either monthly, quarterly, or annually). I have a form called "REVIEWS" where my boss wants to be able to add a memo with a time stamp each time the review cycle is updated.
How can I use the "addNew" function so that a new memo text box appears in the form each time the review cycle is completed? My boss wants to be able to see each of his notes for each time he reviews a company so I want to be able to keep the old memos as well.