My client has a system whereby those employees who are off for extended periods of time (sick, Workmens Comp maternity etc) are re-assigned to a different division.
The table PERSONNEL contains all of the information for each employee. When someone in the sales division (for example) goes off long term ill their data is entered into table LTILL. Their info still remains in PERSONNEL as it is expected they will return at some point.
When I enter their data into LTILL, I would like to change thier division in PERSONNEL from sales to LTILL at the same time.
What would be the best way to go about this. The LTILL has no primary key. The obvious choice EMPLOYEENO is no good since a person my be transferred to LTILL more than once during their career.
When the value "X - DISCONNECTED" is selected in the form I want the record to be removed from its existing table and sent to a new table which keeps all the "X - DISCONNECTED" records together.
Any ideas would be greatly appreciated. How would this be coded?
quick question. If i run a query and change some data in the query will in also change the data in the table? I tried it and it in fact did. If this really does work I don't think it should be allowed to functionally do that since people can easily mess up the data in the table.
I am new to access 2010. I need to change the primary key in a table ("stations", Primary key is "station number"), because future entries will result in double entries for this primary key.
I have another table ("species&stations") which has records of Species for each "station number".
So I created a new Primary key for the "stations" table, now called "species id", being a bit better in defining a unique station (as it contains the year and the species number, i.e. "451_2010")
Now the table "species&stations" references/(is in relationship with) the old primary key, identifying a station number for each record.
How do I get it to recognise the new primary key from the "stations" table, and keeping the records (over 1000...) with all there info.
Approach so far: I tried to create a new field in "species&stations", which should look up the new primary key from "stations" and then autofill the field. i did not manage this though
I attached a screenshot to make the relationships more clear!
i'm a Access novice. I have tables with existing data in numerical form, and would like to know how I can use Queries or VBA code to update these values into a new format in a new table. for example the original data might be of race type:
1 - caucasian 2 - african american 3 - hispanic 4 - other
how can i achieve this in Access? i know how i can do this conceptually with "if" and "case" statements, but I have no idea how i can do this in Access. I don't want to mess with the original data, so please help with CODE or QUERY examples.
I've tried to find this on my own, but without luck. I have a Microsoft Access form that I've build. The data is pulled from tables I built. There is a "User" dropdown, an "Email" field and a "Phone Ext." field. I'd like to set it up so that when the "User" dropdown triggers an On Change event, the "Email" field and the "Phone Ext." field automatically update with the appropriate data (all from the same table). Can anyone help me with this?
I have an on click event to mail a report which works. I want to change the text to include data from a table.
I changed the code to include the field 'office' from the table 'Checks' but get an error saying 'Object required'.
Code is : Private Sub cmd_mailreport_Click() Dim office As Object Set office = Checks.office DoCmd.SendObject acReport, "checks", "PDFFormat(*.pdf)", _ "info@company.com", "", "", office & " Daily Check - " & Date, "Attached is the report for the office", _ True, "" End Sub
Newbie here. Just trying to make a characteristic (e.g., color) of a button change based upon contents of a form field. Can anyone please adivise. All help is greatly appreciated.
I have a database with 200 clients. If a user pulls up a record and the customer's insurance has expired, is it possible to change the background color of the form so that this automatically alerts the user that this customer needs to be contacted and the record needs to be updated?
Or are there any other suggestions that may serve the same purpose?
I have a continuous form that has 5 columns of data per line and it also has a 6th column that I can enter data into. What I want to be able to do is if I enter data into the 6th column it will copy that record except the 5th column to a report.
I have tried searching this forum and other but not quite sure of the terminology so not getting good results.
I am trying to change the button color on a subform if a related form data changes.Main form is products with a continuous subform with serial numbers of products i.e, serial number, location, price and a button to add addtional issues if there are any for this particular serial number (this will open up another form related to the serial number so I can add an issues if there are any).The reason I would like the button to be a different color is so I can quickly see if there are any additional notes been added to the serial number. Just in case you may ask why not add the field to the continuos form is that the issues and be quite lengthy and there may be lots of serial numbers on the form
I would like to be able to change font color and appearance while entering data into a form (example: italicize a word). Is there any way to activate the font format while in a form?
I'm a new user of Access and I'm required to input a survey into access. The data collected is being analyzed afterwards and therefore there cannot be any alpha content in the original table so I assigned multiple choice options numbers to correspond to the answers. In form view however I need the drop down boxes to spell out the answers, not just the numbers so the interviewer can read them out, I've seen this done on other similar surveys..I also tried going into form view and editing the drop down choices but that changes the table values.
I would like to filter data from a table using a query (from an data input form). The objective is to output all results if input form field is empty and to output results higher or equal to the type in the field if field is not Null. The query code is as follows:
:confused: Hi I have some 100 questions for which user must answer by selecting any of the options provided using option buttons.
As i cant fit all 100 qtns in one form am splitting it into soem 10 forms.
User answers the qtns in 1st form and clicks on next button to goto to nxt form thn agn he answers the qtns in tht form and clicks on next button to goto nxt form..so on.. until he answers all the qtns in the last form.
I want to transfer the answers selected from 1st form till the last one..where all the answers are stored in one table whn a submit button is clicked.
please let me kno ASAP if thr is anyway i can do it. thnk in advance
Hi I have some 100 questions for which user must answer by selecting any of the options provided using option buttons.
As i cant fit all 100 qtns in one form am splitting it into soem 10 forms.
User answers the qtns in 1st form and clicks on next button to goto to nxt form thn agn he answers the qtns in tht form and clicks on next button to goto nxt form..so on.. until he answers all the qtns in the last form.
I want to transfer the answers selected from 1st form till the last one..where all the answers are stored in one table whn a submit button is clicked.
please let me kno ASAP if thr is anyway i can do it. thnk in advance
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.
I have not done much work in later version of Access. Now I found if I change a design in one form and similar forms (names are different) which are linked to the same tables got changed as well without openning them up and making changes. Is this something new with Access 2003?
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.
I have three tables: Vehicles; Vehicle Reallocated; and Vehicles Retired. I have a form that runs a query to find all the info in the Vehicles tbl that is not "Retired", not visible in the form. I then have the option to toggle to a Reallocated or Retired form. When i toggle to the reallocated form, i have the like fields in that table (ie Van #, Vin, Make etc) pulling the info from the hidden subform with the vehicle query, so i do not need to fill in repeat data. However, when i add a reallocated date and the new clinic that vehicle is for, i get the record ID for the vehicle reallocated table as expected, but when i save none of the data moved over from the query saves in the record?
How to get all the data on the reallocated form to save?
New to Access! I am creating a quotation database where a new company name will be entered. In 1 form a pick list of products which I then want to go into another table associated to the company name which can then be queried and displayed in a report for printing the quotation.
I will create a form to generate a new quote, enter the company name with a display of quoted items (QuotedItemsTbl) (Query QuoteID).
On that Form i want to have a button to 'add items' on that form be able to pick from items in StockTbl which when selected and button 'close' copy the data to QuotedItemsTbl
Any advice to a enthusiastic buy novice newbie much appriciated.
I have a table called "WorkRequest" consisting of some fields such as WR Number, WR Date, WR Time, WR Requested by and WR Work Requested.Once a work request is completed, I want to open a form called "JobCards" from a table called "JobCards". When I click on the pulldown box for the Job card number, it lists the "WorkRequest.WR Numbers" which is what I want.
My problem is: As soon as I select the WR Number and it displays in the jobcard form in the JobCardNumber field, and I press ENTER or TAB, it must automatically populate the corresponding fields on the JobCard Form. These fields are defined identically in bot the "WorkRequest" and the "JobCard" tables.
Here's a query that the bottom listview in the attached form i.e. a listview representing a table of calls(many) to fims (1 top listview)
Code: SELECT calls.id, calls.firm_id, calls.called, calls.said, calls.spoke_to, calls.next FROM calls WHERE (((calls.firm_id)=[firms].[id])) ORDER BY calls.called DESC , calls.next DESC;
When I run the thing...I get a dialog asking me for firm id.
I want to change this so when I move up and down the firms LV (top)... the bottom LV updates taking firm id from the top LV with focus.
Hi, I'm new in Access and facing a problem. Hope I’ll make myself clear.
I've a table "members" and I've created a form "member_form" based on this table (members).
1. I want to binde my form "member_form" with my table "member" so that the new data I store in form, automatically sotres in table. How can I do that:confused:
2. In form, I've fields "Member_ID" and "Member_Name". I want that when I type member_id in "Member_ID" field, the member name in "Member_Name" field come automatically. How can I do that???:rolleyes:
