What Event To Use To Get Information From Two Fields
Apr 2, 2014
I have a record that has a field called "PG". Every "PG" has different standards depending on what quarter it is in. There is a field called "Quarter" in the record along with a field called "PC". The "PC" field is the "PG" field plus the "Quarter" field. (all are text fields). I would like the "PC" field to be automatically entered once the other 2 fields have their values. Do I use the formula
[PC] = [PG] + [Quarter]
And do I put that as an event, and if so, which one.
View Replies
ADVERTISEMENT
Apr 16, 2013
I have an after update event that populates, Date, Time and User into corresponding fields when the record status changes to closed.
However... Whilst the information is recorded on the form it does not record to the underlying table is there any reason for this, or anything that I am not doing correctly?
View 2 Replies
View Related
Sep 8, 2013
I have a form set to the table Client Information with a subform set to the table Event Information. Client Information has a one to many relationship to Event Information.
There is a button that deletes the current record in Client Information--also deleting the related records in Event Information--then closes the form. The code works fine but a blank record in Event Information is apparently being created before the form closes.
Here's the VBA that I'm using:
Private Sub CmdDelReturn_Click()
Dim CmdDelReturnMsg As String
CmdDelReturnMsg = MsgBox("Delete event & client then return to front?", vbYesNo + vbDefaultButton1, "Delete and Return?")
[Code] ....
It's not a big deal because the button won't be used often and I can manually go into the table to delete the blank record. But if there's a simple solution to prevent this that would be nice.
View 3 Replies
View Related
Dec 20, 2014
I have a table that contains Investigator1,Investigator2 and other fields
And another table that contains PID, Rank_Name_Family and other fields
I am making a query in that query i want to get the names of Investigator1 and Investigator2
Investigator1 and Investigator2 is the PID
for example
Investigator1 = 1
Investigator2 = 2
PID = 1 Rank_Name_Family= Roy Jalbout
PID = 2 Rank_Name_Family= Rony Jalbout
i tried this two solutions but the result is error
Solution 1
Code:
Name1: DLookUp([Rank_Name_Family];"tbl_Personal_Information";[tbl_Personal_Information].[PID]=[tbl_Driving_Expert].[Investigator1])
Name2: DLookUp([Rank_Name_Family];"tbl_Personal_Information";[tbl_Personal_Information].[PID]=[tbl_Driving_Expert].[Investigator2])
Solution 2
Code:
Name1: DLookUp([Rank_Name_Family];"tbl_Personal_Information";[tbl_Personal_Information].[PID]=[Investigator1])
Name2: DLookUp([Rank_Name_Family];"tbl_Personal_Information";[tbl_Personal_Information].[PID]=[Investigator2])
View 3 Replies
View Related
Jul 22, 2013
The database needs to have columns for 17 individual connectors. These fields are populated from another table containing all of the possible connectors that could be used and a description of them. I need to set up a query that contains the 17 connector fields as well a field with the description of each connector. Is it possible to have this query auto populate the description fields from the table that contains the connectors. I have attached a picture below.... Each pin has a label that has to be manually filled and a pin name that has to be chosen from another table. I want to have the pin description fields auto populate to match the selected pin names.
View 4 Replies
View Related
Sep 20, 2007
Morning everyone
I have made up a database to record generations of birds; along with others I have the following fields:
Ring number (primary key)
Sex
Year
Colour
Data entry via a form view.
For new entries I pick up from a combo box the parents, what I need to do now is create a relationship between 1, 3&4 and 2, 5&6 so that the data will automatically slot in the relevant fields.
1Parent Cock
2Parent Hen
3Grand Parent Cock C/S
4Grand Parent Hen C/S
5Grand Parent Cock H/S
6Grand Parent Hen H/S
would I do it via a query.’ And would one cover relevant generations
Thanks for any help
Norma
View 8 Replies
View Related
Jan 17, 2006
Hi, I was wondering if anyone could help me.
I have a simple database, consisting of two tables and one form. I'd like the form to display information mainly from the first table (table 1). For this, I have used the Form Wizard, which works well and displays as it should. My problem comes when trying to display data from table 2, without using the Form Wizard.
I have a simple field called 'Number' in 'Table 2'. I'd like this value displayed in a text box along with table 1's data. I've tried using the expression builder, which gives me something along the lines of:
[tbl_Table 2]![Number]
But this is displayed as:
#NAME
...when I open the form. Could anyone explain how I do this correctly please? All I'm trying to do is display data from other tables in the form.
Any help is much appreciated.
View 5 Replies
View Related
Feb 6, 2015
I have a table which now contains a couple of hundred records with more than thirty fields each, and will ultimately contain over 1000 records. Some of these fields use the multiple value feature, and the fields and the forms which fill them work beautifully. Now comes the challenge.
Without going into detail that I'm not at liberty to share, I can say that there are different offices which have different people who are responsible in different ways for the work covered in these records. It is possible for each record to have multiple people assigned to it from the same office. This requires setting the control that shows the people from each office to allow multiple values. I need to be able to create a report which will allow me to hand a list of all the records each person is responsible for in the office to the person responsible, in spite of the fact that this will mean records will show up on more than one person's report.
Before I knew that there might be multiple people in the office for each record, I created great reports grouping and ordering by this office's control and field. Now, since they allow and store multiple values, I can't use them any more. I need to be able, as I said above, to get the same effect. I think the answer lies in some sort of calculated field or formula that applies text filters. What I need to be able to do is look in the field for this office and see if a person's name is contained in the field for that particular record, regardless of who else might be in the field, too. I need to be able to use the results from this filter or calculation or formula to generate something I can use in the group and order by processes.
View 7 Replies
View Related
Dec 20, 2013
I have attached a portion of my database. if you go into the form called frmtest, select a branch from the very top drop down, select a detail and click the Edit button.how to have the information populate all the fields for editing. The Cost and Quantity fields work but my combo box fields don't properly work. The top combo box populates but when the record is updated it doesn't save the id. The second combo box doesn't even put the data in the data box.The main table where IDs and fields are is the BRANCH_EXP table, it's a linking table which links tables with many to many realationships.
View 3 Replies
View Related
Jan 21, 2014
I need to know a query to pull information from two date fields into one. I have a BuriedStartDate field and an AerialStartDate field. In a third field I have PlacementStart. I would like to put the date into the PlacementStart field which ever is the oldest date bewtween the BuriedStartDate and AerialStartDate. It has been awhile since I have done any queries on Access 2007. I am completely self taught in Access.
View 2 Replies
View Related
Jul 26, 2012
I have a form to record student information. On my student table i have a school I.D that links to the primary key of my school table.
My problem is that in my form, i want to be able to fill in the rest of the fields about the school info based on the I.D chosen.
i.e.
student table:
Student id
name
address
school I.D (FK)
School info table:
School I.D (PK)
school name
contact name
email
address
My form that's linked to the student table needs all the information from the school info table in separate fields
but i can only select School I.D in the Control Source Property.
View 1 Replies
View Related
Nov 26, 2005
I have a data entry form where country(ies) (there can be more than one for
each project) is/are entered in a sub-form on a tab control. Countries not
listed are entered by the following:
Private Sub CountryName_NotInList(NewData As String, Response As Integer)
Dim strSQL As String
Dim strMsg As String
Dim ctl As Control
Set ctl = Screen.ActiveControl
strMsg = "Country " & NewData & " Is not listed!" & vbCrLf & "Do you want to
add it?"
If MsgBox(strMsg, vbYesNo, "Not listed") = vbYes Then
strSQL = "INSERT INTO tblCOUNTRY (CountryName) "
strSQL = strSQL & "VALUES('" & NewData & "');"
CurrentDb.Execute strSQL
Response = acDataErrAdded
Else
ctl.Undo
Response = acDataErrContinue
End If
End Sub
This works fine. However, if I restrict the country names by a region
selection on the main form (for example if region Africa is selected on the
the African countries are preselected) the NotIn List does not work. Any way to work around this?
Another question, I want the user to select a region (a combo box ) on the
main form and when a new country (using the NotInList event) is entered in the subform both values go into
the same record in tblCountry (which has two fields CountryName and Region).
For example, I enter AFRICA for region on the main form and on the sub-form I enter Malawi which is not listed. I have tried the following:
Private Sub CountryName_NotInList(NewData As String, Response As Integer)
Dim strSQL As String
Dim strMsg As String
Dim ctl As Control
Set ctl = Screen.ActiveControl
strMsg = "Country " & NewData & " Is not listed!" & vbCrLf & "Do you want to
add it?"
If MsgBox(strMsg, vbYesNo, "Not listed") = vbYes Then
strSQL = "INSERT INTO tblCOUNTRY (CountryName, Region) "
strSQL = strSQL & "VALUES('" & NewData & "', FORMS!frmAddPro!Region);"
CurrentDb.Execute strSQL
Response = acDataErrAdded
Else
ctl.Undo
Response = acDataErrContinue
End If
End Sub
But it does not work (Region is the control on the main form named frmAddPro).
Any suggestions would be welcome. Thanks.
Niels
View 4 Replies
View Related
Jun 8, 2013
I have a form, which registers attendance at an event, with three fields - ID (a combo box), Name, and Present.
When an attendee comes in, they give their number which is entered into the first field. Pressing carriage return, their record is loaded, and I can then check the 'present' field. Then I click the next button and await the next person!
I'd like the simplify the whole process - so that as soon as the 3 digit attendee number is typed, the present box for that record is checked, and the form is reset (curser back to the combo box to search for next record).
In short - all the registrar ever has to do is enter a three digit number!
View 8 Replies
View Related
Nov 5, 2014
I have a form (form1) that will populate with records (table1) based on key fields of "Project Number" and at time-points we will update part of the record, and then we create a word document detailing the updates with a couple of other bits of information not in original record.
Basically I want it to go from the original form (form1) into another form (form2) (via a command button) taking the key field of "Project Number" where it will ask the bits of information that we don't need have already and the contact person.
I have got this to store in a different table (table2) using a key field of just "ID" from the original records (table1). A list of contact people are in a separate table (table3) using a key field of "contact name" which will include other details for them such as address and phone number.
So from "form2" I would like to produce a report that contains information form "table1" based on the "Project Number" and "table2" based on "ID" as just been generated and "table 3" which is based on "contact name".
So I want to pull information form the records based on the certain key fields but struggling for it to pull it successfully...
Got relationships between:
"contact name" fields in both "table2" and "table3"
"project number" fields in both "table1" and table2"
In a query for the report I have all the appropriate fields, but only have the "contact name" and "project number" from "table2" is this right? or do I need both in?
Or would it be easier to draw all this information into "form2" but don't really want to select that many drop down boxes or would it be able to pull it from the "contact name" and "project number" boxes????
View 6 Replies
View Related
Apr 16, 2012
I have a database in which we are trying to have a field "Headcount" automatically fill with the correct value based on information in multiple fields. The "Headcount" field will be based on about 6 or 7 rules. Most of the rules i can figure out, but im having trouble figuring out what the best way would be to search for a single individual's projects when they are on more than one project at a time. I thought about using a counter of sorts to count how many projects someone was one, but how do I pick them out of the entire table once i have found out the number of projects? Would a for loop work best or just many if statements?
View 5 Replies
View Related
Oct 23, 2013
I am working on a database which has two tables used as part of a registration and login process.
I would like a couple of fields from table one to automatically update in table two, once the fields in table one are populated without using an 'on click' event.
The reason I would prefer not to use an onclick is because the completion of the form used to generate the users table does not require any buttons for the data to save.
View 1 Replies
View Related
Jan 4, 2006
I wonder if anyone has a quick fix for me. I have two tables in a project management DB that I am making. The first table is a projects table and the second is a tasks table. I would like to have a list box in the projects table containing all the tasks completed for the specific project. However, the current list box is showing all tasks rather than the ones specific to the project ID. The project ID is the primary key in the projects table and the foreign key in the tasks table. I am not sure if/how setting up a filter would correct this or if I just need to adjust the relationships. An example of the DB is avaiable if helpful.
Any advice or ideas would be greatly appreciated.
View 1 Replies
View Related
Jul 12, 2006
I have a client who wants his Accs db converted to MySQL. I have no problem understanding MySQL. However, my knowledge is limited with Accs.
This db is quite large (53mb) and has several tables, queries, reports, forms, modules, etc. I suppose he tried to create a backup and sent it to me. The problem is that all I have are the tables...nothing else.
Did he do something wrong or is that standard w/ Accs? Is there anyway I could have all of the information saved to some type of txt or .doc file and send that to me? I understand that would make it larger. The problem is right now Im on his computer (networking) and it's running too slow. I'm having to make screenshots and what-not (and that's when his secretary ISN'T WORKING...so pretty much at night). Really need some suggestions with this.
Thanx,
Tim
View 2 Replies
View Related
Jun 14, 2005
I am brand new to Access(I started yesterday). I have a ListBox that gets its selections from a Query. I set it for MultiSelect, and now I have to figure out how to store the selections. The list is organized in accending order, which does not match the table that the Query is based on. I have no experience with VBA. The form name is Trouble_Ticket and the ListBox name is List24.
Thank you
View 1 Replies
View Related
Jul 4, 2006
I have got a set of information that has a mixed bag of names. Some have only a first name but some have a middle name also.
I am looking to shortern the information just to the firstname (i.e. in stead of the results showing "Bill William" as the firstname, i want to just show "Bill").
i tried using the Left function but because the strings are of varied length i need the cut off to be the space between the various names.
Any help would be much appreciated.
View 4 Replies
View Related
Dec 27, 2006
I seem to remember - way back in my access class that I have not used regularly, therefore have forgotten much - that there is a way to put a description of the query or form or table that pops up in a kind of box when the cursor is placed over the name. I hope that makes sense - if not, read on.
I have a lot of queries and would want anyone using them to know what they will do before they click on one - because it might mess things up.
Thanks in advance,
Peg
View 7 Replies
View Related
Feb 8, 2007
I am having a hard time linking some certain information. I think I have my relationships formatted correctly but not all the information is connecting.
For example: I have a form where I am creating a sales quote. In the form I have a combo box where I select my product ID. When I select the product ID, the product name automatically populates but the price does not.
I have attached a screenshot of my relationships. Can someone please look it over and see if anything stands out to you as being incorrectly formatted? Or offer any advise in getting my price to connect to the product ID I enter?
View 14 Replies
View Related
Mar 14, 2007
Hi there..
We have Access 2000 database. Everythign is working fine but suddenly it have started loosing information. I entered one record last week and its not showing up now.
I am not a remote user. I entered the data from local machine.
Do someone have any idea about this issue.
Thanks
Danny
View 5 Replies
View Related
May 25, 2007
I am implementing a quoting system at work. Many times, a customer wants the same job that he asked for last year or 2 years ago, so basically it's the same information. So when the customer calls, I look for his last quote, and then would add a button that would create a new quote (record) but with the same information. It would be a burden to enter all the same information each time the customer calls for the same job over and over again.
Thank you
View 4 Replies
View Related
Oct 10, 2007
Did you know that when you create an MS Access database, personal information such as your user name and the name of the person or company that the software is registered to is saved and displayed with the database file for others to see. Prying eyes simply goto 'File->Database Properties->Summary Tab' to see your personal information.
The fix is simple goto:'Tools->Options->General' and select the 'Remove PersonalInformation from file properties on save' check box. Next time you save, no more personal information.
Don't believe it? Look at some of the sample databases posted here - :eek:
:)
ken
View 1 Replies
View Related
Nov 26, 2007
Hi to everyone Could anyone please tell me if there is a developer for access so I can get them to finish my database.
A friend started a data base for me but he had a motorcycle acident and the worst happed I have tryed to finish it myself but I'm not very clued up.
I would like to get a quote to finish I have just gone self employed and need this to produce surveys for Asbestos.
Im sorry if i'm not aloud to post this here if not please remove.
I live in soton uk I can put the database up on my server for people to download.
Thanks again
Please can anyone help here
View 3 Replies
View Related
