I have a property form for keeping track of houses and buildings owned and then on that form i have a policy field for the policy number of the insurance called txtPolicy. Next to that field I have a little button which opens a form so it will show all the insurance policies associated with the housing group which the property is in. When i select the appropriate policy and double click it in the listbox I want it to close the form and set the value of the txtPolicy to the one just selected in the listbox. I know how to get the value of the item selected in the listbox but I just don't know how to set the value of a field on another form...
I am a newbie to Access or any database for that matter. So please be gentle. I'm in the process of writing an automotive invoicing database and have gotten stuck early in the game. On my form I have Qty1 - Mat1 - and Amt1 fields placed from my database. In Amt1 I would like to typein an amount and have it multiplied by 15% (.015). I fiddled with the "On Enter" in the Amt1 property box but got nowhere. Can someone help???
I have made attempts at this but none have worked, so I am looking for guidence.
What I creating is a database that I can track students and their community service hours.
I have made several versions but I figured the experts could point me in the right direction.
So far I created two tables:
tblStudents STUDENT_NAME - Text HOURS_GIVEN - Long Integer
tblHours STUDENT_NAME - text Links to tblStudent DATE_COMPLETED - Date HOURS_COMPLETED - Long Integer
I created a form "frmStudent" with the following:
a drop box to chose a student name from "tblStudent" a text box "txtSTUDENT_NAME" another text box "txtHOURS_GIVEN" another text box "HOURS_REMAINING"
Then I have a subform that has two text boxes "txtDATE_COMPLETED and "txtHOURS_COMPLETED"
I need a code that will enable me to chose a student from the combo box and then have that students name and hours given automatically enter into the respective text boxes in the main form. Then I would enter the date and hours completed into the respective text boxes of the subform, which in turn would update the fields in "tblHours" at the same time subtracting the new hours from the hours given and displaying the new total hours remaining in the respective in "txtHOURS_REMAINING" of the main form. Can anyone give me any help in coding that? Thanks in advance.
I have made a table and quered that table. I have a form that I designed and is working well. It updates the table like it is supposed to. The problem I have is when I go in and change the master table. I decided that instead of havinga field titled "Unlisted/Listed" I just made it Listed and you put a yes or no. But when I do that and go back to the form a box pops up asking for some value. How do I fix this? Thank you.
I have a simple add form that will add an entry to one of two tables: Box 1-1, or Box 1-2.
They have the exact same fields. In the add form, I want the user to specify a Rack field and a Box field. Box 1-1 would be Rack 1, Box 1. Box 1-2 would be Rack 1, Box 2 (there will be more tables later, but just using two for now until I get it working).
But right now my form always adds to the table Box 1-1 - I can't get it to switch.
I've added the code I have so far below. The first part is what I'm having trouble with, the second part just uses a Submit button to add a new record - I'm just including it in case it's interfering in some way I'm not seeing. I'm running Access 2007.
Code: Private Sub Switch_BeforeUpdate() If Me.Rack.Value = "1" And Me.Box.Value = "1" Then Form_Add.RecordSource = "Box 1-1" ElseIf Me.Rack.Value = "1" And Me.Box.Value = "2" Then Form_Add.RecordSource = "Box 1-2"
I currently import data into a table and it it has a text field which looks like this: 12,345.67 GBP...I need to use a query to make this a number field so that I can sum it's contents. I've managed to remove the 'GBP' part but can't seem to get rid of the comma?
I have a table Client-Details,in which i have a record namely "bharti-chennai".this table is associated with aother table "release-details". bharti-chennai has records in relase details.i want to change the name of bharti-chennai to bharti -mumbai ..how to do it.
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.
This might be simple but I just can't figure it out.
I have a table that has a number field. Everytime I enter the number 1.50, it changes to 2. I would like to keep the 1.50. Somehow, I can't get this right. Is there a setting that I have to change? Would I need to make setting changes on the form portion also?
I have a form with names of employees, and different skills that employee has.
It is listed in a form as columns with the employee name in rows, and columns for the skills. The form is in fact really great, but I see that the solution might bring problems in the future because of maintainance issues, and field limitations. I add fields frequently, and the table is growing without me beeing able to control it.
I have organized this in only one table, and used the name of the skill as a field. There is many other tables in the DB, but none of them covers this area.
With this solution I get the skillname as a heading, and the name as a column with lots of yes/no values. I love the filter functions, and the form is quite nice...
exampleform:
Employee baking cooking driving juggling employeeeID1 yes no no yes employeeeID2 no yes yes yes employeeeID3 no no yes yes employeeeID4 yes yes yes no
and so on.
Is there a way to organize this so that the skill name comes in the top row, the results get listed as shown above when the skill is placed as a field value, not a field itself?
I have looked for a solution with many-to-many relations with 3 tables, but cant seem to make it work right. It is especially the form I have trouble creating with the new design. I have also tried to make crosstab queries with minor success.
Does anyone have a suggestion on how I can make the relations work. One employee can possess a great number of different skills, and the skill can be possessed by a great number of employees. This is not a difficult issue by itself, the problem is to make the form as shown over.
I have built queries based on tables. The field names are the technical field names of an application. For example pernr is actually Personnel Number etc.
My queries are set up as follows:
Field = pernr Table = etc
I would like to rename pernr to Personnel Number so that the column heading in the datasheet view is Personnel Number.
I know I can do this manually for each query by using the following as the field: Personnel Number: pernr
Is there any way of getting this be done dynamically using a lookup table etc. I have lots of queries and I don't want to manually change them all. Furthermore, if I wanted to rename Personnel Number to Personnel No. then I could do it in the mapping table rather than in all the queries.
Hello, I have a form that I need to modify. Currently, the field list shows Query 1 as the 'control source' for the text boxes on the form and I need to change to use Query 2 but I am unsure of how to do this. Do I have to delete the test boxes and start fresh or can I change the field list and use Query 2 as the source? Thanks for any help. JTP
The last line is the problem. A field name in an ADO recordset is limited to read-only persmissions for opened (already exisiting) recordsets. link:http://www.w3schools.com/ado/prop_name.asp
Is there another way around this without using an SQL "ALTER" statement. In other words, by accessing the field's name through a number like rs(i).name instead of rs("fieldname").name?
Does anyone know how to change a field FORMAT default? I am creating lots of tables with lots of number format fields. I don't, however, want a zero default value (or any default value for that matter) for all of these fields. I can go in and delete them manually, but that seems like a backward way of doing things. Does anyone know how to elimate that default value from the format of a number field in general?
these fields are later populated conditionally using an update exectuted again from vb code
If Me.cboProgram.Column(0) < 3 Then strSQL = "UPDATE TBL_TmpSubmission SET EnergyUnit = 'GWh'" Else strSQL = "UPDATE TBL_TmpSubmission SET EnergyUnit = 'CarbonTonne'" End If CurrentProject.Connection.Execute strSQL
the problem is that this field now has a memo data type, this is a problem because i need to write a query which uses this field in a table join and access won't let you join on the memo type
anyone know why this might happen? for the time being i'm going to try and fudge this by using a further ddl statement to change the data type back to text but i'd rather know whats going on here
The problem I'm having is I need to have the background of a field change color depending on what's contained within the field. There's only three possible entries in the field: active, inactive, and a blank entry. I need it to show green if the field contains "active", red if the field is "inactive" or is blank (I also want the blank fields to show inactive, but that's niether here or there right now.)
I've been trying to get it to work with an if then statement, and setoption to change the background. I've had no luck with any of it, though.
Any help would be greatly appreciated. Thanks in advance.
I am working on a french version of Access but in my english forms, I need the current date field to be written in english - is there a way/expression to change the language of the date field on a form (from french to english)?
I'm opening a form in snapshot view and would like the background colour of all the fields in the form to be a dark colour to show that it is in snapshot. the user then clicks Amend and the background colour would change to something lighter to show they can amend the record. Is there any way of on the OnClick event of the Amend button change all the fields (and there's lots) at once without having to name them all individually, ie:
Hi guys, I need a little help on next record stuff...:eek:
Can someone please explain how I can make my database actually go to the "Next" record after I update the "LName" field on my form? My database is sorted on "LName". After I update the "LName" field and save the record, the sort order is messed up. If I requery the form in the sub routine, the database goes to the first record. I need it to go to the "Next" record (the one that would have actually come next before I changed the LName). For example, if my database contains these names:
Baker Doe Franklin Goodwin Johnson Jones Smith Taylor
and I change the current record's LName from Franklin to Phranklin, I expect the database to go to Goodwin (the record that would have followed Franklin) after pressing my next record command button. Likewise, if I changed Phranklin to Franklin, I expect the database to go to Smith (the record that would have followed Phranklin) after pressing my next record command button.
I've tried different versions of FINDFIRST on this site, but can't get it to work. I would like to find the next record based on my key field (autonumber) named "rec_id".
I just wanted to know the VB code for changing the value of a field in one table from another.
What I need to specifically do is implement code in an AfterUpdate to change the value of a field in another table if a certain threshold is exceeded (in this case, entering a dollar amount greater than what I have specified). Effectively, I need this to 'flag' a contract by changing the field in another table to read "VOID".
I have a query that pulls records from a main table based on a check box and I need a macro or code that will set the field value as if it were unchecked.
BTW I am self-taught and new at this so don't make fun of me if the question seems stupid.
I've purchased & downloaded this Zip Code Database which has every Zip zcode in the U.S. which I use for different projects/reasons. The problem is, ALL of the data is upper case letters. I was wondering if in Access (or Excel) is there any way I could convert all of the letters (except the first letter) from upper case to lower case letters?
I am trying to change a field lenght of a large database (access 97) It is at 50 right now and want to change it to 25. When I try to change it and save the table I get a error when the bar is about 3/4 the way accross the bottom.
Microsoft can't change the data type - there isn't enough disk space or memory.
then
not enough space on temporary disk
This is error 3183. In the help it says that the TEMP DOS enviroment variable location doesn't have enough space. (summerising). Now I have a 100+gb drive that isn't close to being full. I also changed the MaxLocksPerFile registry dword to 8,000,000 as my table has around over 3 million records. I have tried this on a xp and 2000 machine same results. Next I am going to try it on a 98 machine. I could do it by breaking up the table into 2 differnt ones and do each one individually but there is an autonumber field used as a reference number (I know I know). So that would screw up the numbering scheem (Yes I know there are ways arund that also). this database is about 400MB
Couple of questions 1. Is there a way around this? I have not found a solution on line yet. 2. Will lowering the field length make the database smaller (the data that is in there now is less than 25 charecters and the field is set to 50.) I have gotten mixed info on this. there are a few fields I would like to reduce.