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
I have 3 tables in my database; 1) Policies, 2) Salespeople and 3) Shops.
We have a several shops, and each shop has their own salespeople. In the table Policies we have to select the shop where the policy is sold, but also the salesperson that made that sale. As soon as we receive a policy from Shop A we have to add that new record in the Table Policies. This table we select the shop, say for instance Shop A. The next column there is a droplist of all the salespeople.
Now my question: Is there a way to get a dropdown list of only the salespeople from Shop A, or only the salespeople from Shop B when I select Shop B?
HI all, the objective is to grey out an item within a listbox, where the id number is the same in another sub form. The sub form is called contacts and the list is called list15. the unique id that is linking the two is SWD.
HELP...:confused:
Hi there guys,
I need a little help on a little situation. Basically, my client for my school project wants to be able to see graphically if orders sent to their bookstore have been processed or not. So i suggested a change of cololour of the fields.
Now I have created a Form containing the orders as they are stored in a list box, (both already processed and unprocessed orders), now I want to be able to allow each item in the list box to be either Red (if unprocessed) or green (if processed) so the user can see which ones they need to deal with. Im guessing this would take some VB, but if anyone could help me, I would really appreciate it :).
PS, if you do provide VB could you please explain a little of whats going on as i have to annotate all the code I use and im not too profficient in VB
Thanks a lot
Dan
I have a drop down list where you pick from 6 recruiters. i put it on my candidates from and when yiou change a recruiter on one candidate then all the candidates get changed to that recruiter. Any ideas what i did wrong?
View 1 Replies View RelatedHow do I change a combo box that I have on a form so that it will allow entries as well as edits?
View 1 Replies View RelatedI have a list box and a series of 11 fields a user can search by. My problem is that the List Box has changed the column order.
Example: In the design wizard of the list box I had it such that the columns were in order 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11
Now after I hit search the fields populate out of order... 4, 9, 2, 1, etc...
How can change column color in list box and also how to make alignment left or right for cells data.
View 1 Replies View RelatedIn my access form I provide the user a list of locations from various countries in a listbox . But the list is too long so I provide him a combobox for selecting a country. Selecting the country should update the listbox showing only the locations in that specific country.
So my SELECT from the listbox must cover the unselected state and show all entries and when a country is selected it must narrow the selection.
I tried to get this happen with the following SELECT statement containing a variable. Choosing a country in the Combobox results in a change of the variable and in a requery. This works after the first country is selected and for each country change, but the initial list is empty.
VBA in the loadform
'Application.TempVars.Add "varcountryselect", "*"
SELECT in the listbox "lstlocationsperproject"
SELECT tbllocations.locationID, tbllocations.country, tbllocations.localstreet, tbllocations.localcity FROM tbllocations WHERE ((tbllocations.country) Like [TempVar]![varcountryselect]);
VBA in the combobox
Application.TempVars("varcountryselect") = [Form]![kombcountryselect].Column(0)
Me.lstlocationsperproject.Requery
The values in [kombcountryselect].Column(0) are texts like "SPAIN", "MEXICO", etc.
Any hints, how I have to use the * for getting the complete list on the initial view ?
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?
View 4 Replies View RelatedOkay,
The subject is probably confusing but I'll try to explain.
Setup:
Table1
FieldID = Number
FieldName = Text
Table2
FieldID = Number
FieldName = Text
T1_ID = Number
Relationship
Table1.FieldID 1-> * Table2.T1_ID (one to many)
Now, I'm trying to create a 3rd table that has field populated by Table1 and a field populated by Table2 but I want to limit the field populated by table2 by what is selected in the field populated by table1.
Table1:
1st
2nd
3rd
4th
Table2:
1st,January
1st,February
1st,March
2nd,April
2nd,May
2nd,June
3rd,July
3rd,August
3rd,September
4th,October
4th,November
4th,December
Table3:
Table1Field = Number, ComboBox-Source: Table1, BoundColumn=1
Table2Field = Number, ComboBox-Source: Table2, BoundColumn=1
If Table1Field = 1st then
Table2Field Will only allow January, February, or March as selections, since ONLY they are a member of the "1sr" group via the table1 list.
Is this possible, or do i have to do some run-time checking or something?
Thanks
Jaeden "Sifo Dyas" al'Raec Ruiner
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.
View 3 Replies View Relatedhiya... he's my problem........
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.
How do i achieve this please..????
many thanks for viewing!!
hiya... he's my problem........
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.
How do i achieve this please..????
many thanks for viewing!!
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?
thanx for any help
Help needed: Large Yes/no tables!
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.
exampletable:
employeeID | auto
employeename | text
Hireddate | date/time
Fireddate | date/time
baking | yes/no
cooking | yes/no
driving | yes/no
juggling | yes/no
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.
Thank you, in advance.
Hi All,
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.
Thanks,
Evan
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...
View 1 Replies View RelatedI am using ASP to try to edit the column (field) names of my Access database. Here is an example of would I would like to work:
Code:data_source = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" & _ Server.MapPath("databases/logins.mdb")Set rs = Server.CreateObject("ADODB.Recordset")rs.CursorType = 2rs.LockType = 3 rs.Open "SELECT * FROM Users;" , data_sourcers(1).name="blah"
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?
Thanks.
I have an Application that I want to re-use for a second user. The only change I need to make is to re-name the fields.
Is there a tool that can do this across the tables, queries and reports for each field name change ???
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?
Thanks!
Carly
i have a temporary table which is created by importing an excel file
some extra fields are then added to the table using sql vb code for example
strSQL = "ALTER TABLE [TBL_TmpSubmission] ADD COLUMN [EnergyUnit] TEXT;"
CurrentProject.Connection.Execute strSQL
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
Hi everyone,
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.
-Walter
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)?
View 1 Replies View RelatedHello...
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???
Thanks for your time
d9085@hotmail.com
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.