i have a table of 3 columns Named as C_Name, C_City and C_PIN..i have a combo box with All Value (All,C_Name,C_City and C_PIN)...i want to display All columns ,when i select All in Combo box and when i select Column C_Name, only display C_Name Column).
View RepliesMy question is that can we do multiplication of data of two columns and result is automatically displayed in third columns in datasheet view.? Is it possible ?
View 1 Replies View RelatedMy problem is I have two tables. One of the tables was made specifically to draw information from to populate the second table. The second table has a combo box that draws information from one of the fields from the first table. What I am hoping to do though is have each selection from the combo box in the second table to draw different information from another field in the first table and use that data to populate another field in the second table.
Simplified: Combo box in Field (1) on table two has multiple selections that I want to autofill the data in Field (2) on table two based upon the selection of the combo box. Data from both fields in table two would come from two different fields from table one.
I have tried to work with the After Update button in the After Events section on the ribbon at the top; however, I am simply lousy with coding. Is there an easier way to do it other than using that option?
Is there a way to run a query against a table that would return the column names, no data just the column names.
Thank you for any help.
Here is my problem. I have a table with a lot of columns. I want the user to be able to select which column he wants to display in a query/report, how do I do that? Is there some kind of way to do a command
SELECT [table].[like [user input]]
either in SQL or Query Design, so that a form would pop up and ask user for input, and then display column whose name corresponds to that input.
i have a form that will have a column called [animalID] which is a 5 digit number. Only the first numer really matters. If the five digit code starts with a:
1,2,3,4 = cat.
5,6,7,8,9 = dog
example
animalID
29878 - cat
67424 - dog
47812 - cat
92435 - dog
I want my form to show "CAT" or "DOG" not 92435.
How do I do that? thanks.
I have a table called ComponentIndex with about 3000 entries. Each entry has an ID field and data in a hyperlink field called MSDSlink.
For each entry, I want to copy just the address part of the hyperlink to a new text column, let's call it MSDSAddress. This way, I only have the URL and no displaytext in that new column.
How would I go about doing so?
I am using the Desktop Project Management template in Access and want to change a Open Project query from displaying the "id" which is a number, to the name column. In the projects table the field is set to number which is in a relationship with the employees table. Without changing any of that is there a way to run a query that will display the name instead of the number?
View 6 Replies View RelatedI have reports that total the figures in a column and displays the total at the bottom of the column. I would like to display the total at the top of the column since the length of the column continues to grow and I would like to see that total before scrolling down to view the various individual entries.
No matter how I try the =count(x) always shows an error. Is it not possible to display the total figure at the top of a column instead of at the bottom?
So i have a access database with a main field that we can call vendor # (LIFNR) and another called Company code (BUKRS). There are multiple company codes under a single vendor #. Example:
LIFNR
BUKRS
0000010535
1010
0000010535
5060
0000010535
5610
0000010536
1010
0000010536
5060
0000010536
5610
What I am trying to do is create a 3rd column where i can have a unique row for each of these fields without it repeating. There is no unique identifier in this table and that is what i am trying to achieve.
I am looking to generate a total number of a given column based on two criteria.I would like a label (or textbox if necessary) to display a given total of "Active" devices based on a given month.The table name is "Blackberry" and the specific columns I would like to check would be "Activated?" and "Registration Date". I'm not sure if I should be using a dsum or dcount and the error i keep getting is a type mismatch.an active device would have the text value of "Yes.
Dim advalue As Integer
advalue = DCount("[Activated?]", "Blackberry", "[Activated?]=yes" And "[Registration Date] > #01/01/2000#")
lblad.Caption = advalue
I have a database which has a table for the quotes prepared, each record has a quote amount. In a query linked to that table I have the ability to get just a specific month view which shows all totals in that month. I want to calculate a grand total for the amounts shown in quote amount:
Record 1 : 100.00
Record 2 : 100.00
Record 3 : 50.00
Grand total : 250.00
Then I want to display this grand total on a form which is visable on a screen based in the office that has an auto refresh on it so after 2 minutes any new records added to the table will increase the grand total on the form on the screen.
I have worked out how to do the totals bit, but now I need getting this figure (I.e. 250.00) on a form without having to run the query and have it looking in the background.
i would like to sum all the column fields in a tables column where an id is the same as the id in that table.
I know you can use the SUM function in the select statement of your query.
But how can i set this sum result into a variable, so i can use it for calculation further on in the program?
I work with Access 2010
I have a combo box with the following 4 columns:
ItemID, Item_Name, Item_Cost and Taxable.
The fields are Autonumbered, Text, Currency and Yes/No, respectively.
I am trying to SUM sales tax, in the form footer, based on the Yes/No settings. Some items are taxed and some are not.
So far, I am able to get tax calculations on everything, only.
With this code as Control Source for the footer control:
=Sum(IIf([Taxable]=0,([Item_Cost]*[Quantity])*0.0556,0))
I get tax calculated on every item, regardless of its taxable flag.
When I use:
=Sum(IIf([Taxable]=1,([Item_Cost]*[Quantity])*0.0556,0))
I get no tax calculated at all. Always comes out zero.
For some reason, the calculation isn't distinguishing the Yes/No values for each record, independently.
Can anyone assist me in fixing this?
I have a combo box with three columns bound to column 1.
I want an If statement to execute on the value of the contents of column 3 which contains text C or D.
How can I do this? I've tried
If Me.MyCombo.Column(3)="D" then
TakeSomeAction
Elseif
Me.MyCombo.Column(3)="C" then
DosomethingElse
end if
Thanks
My combo(cbxCombo1) has two columns - The code below is working on the ID - Bound Column in cbxCombo1 Where what I actually want is the second column(the bound column has to remain 2 in cbxCombo1 as I am inserting text and not an ID to the table...So what I actually need is to stipulate column1 in strSQL = "Select " & Me!cbxCombo1.
Private Sub cbxCombo1_AfterUpdate()
Dim strSQL As String
strSQL = "Select " & Me!cbxCombo1
strSQL = strSQL & " from tblModels"
Me!cbxCombo2.RowSourceType = "Table/Query"
Me!cbxCombo2.RowSource = strSQL
End Sub
Cheers
Andy
I have a combo box with 5 columns. When I click it I want to display columns 1 to 4, together with the headings. But after making my selection, I want column 5 stored in the field.
How can I do that? Currently it is storing column 1.
Thanks,
Dave
on the audit trail modul
when the field is combo box I need to capture the combo's column(1) to my audit trail table
i used the code :
If TypeOf ctl Is ComboBox Then
rst("OldValue") = ctl.OldValue.Column(1)
End If
but it's not working
can any one help me with that
many thanks in advance
I have a combo box that has two columns, the second one is bound.
Is there any way to reference the 1st column (the unbound one).
What I actually want to do is have the 1st column show up as a status line message or as a quick help message when the combo text is mouse_overed. The problem is the combo box field is a date that is unique 99 % of the time but in that one percent the user needs to see the beginning of the 2nd column ( think of a persons doctors appointments, where one percent of the time a individual needs to visit the same doctor twice in one day , in which case the procedure and the date becomes the selection criteria (but I don't want to show the procedure and the date in the combo box because the procedure is so darn long.)
Confusing enough?
Any ideas?
Thanks
I have combo box # 1 with value list of "OLD" and "NEW" and combo box # 2 with its row source coming from a query. Here's the scenario - A user chooses "OLD" on the first record from combo box # 1 and the code works fine. But when the user chooses "OLD" again on the next record, what code do I write so that combo box # 2 displays a 0?
So to re-itirate, please help me write the code if the item on the list is selected again, the value of the other combo box would display 0?
Please help. Thank you.
I've created a form with a combo box to allow users to set the Manager of an employee. I've set the control source for the combo box to the Managers table that contains a primary key and the manager's name.
I've set the bound column to 1, the column count to 2, the column widths to 1;2 (I want to show both columns in the drop down because users can identify managers by either their name or Manager ID).After updating the combo box, the Manager ID shows rather than the Manager Name. Is there a way to have the Manager name show instead of the Manager ID without setting the column widths to 0;2?
I am having a problem entering the 2nd column of a combo box.This is a lookup combo looking at a table called Accessories. The combo is looking up 4 columns in the table, the first column is called "Action" the 2nd column is called "Item". I click on the combo box in the form and decide on the action I want and click that row, it then enters the action I have clicked. But it is the "Item" column I want to enter on the form not the "Action" column.
This only works if I make "Item" the first column which I do not want to do. I want to keep the combo columns in the order they are but enter the 2nd column not the first. I have tried making the bound column the 2nd column but it still enters the 1st column. I am sure access must be capable of doing this but I cannot work out how. It seems you can only enter whatever is in the 1st column.
I'm looking for a work around for getting the bound column setting for a combo box to work. I created a simple table with 2 fields that i have a combo box pointed to. My settings for the combo box are
Column count 2
Bound column 2
The first field is "Description"
The 2nd field is "ID"
I cannot figure out how to have column 2 to be the value that is left in the combo box once I have made my selection.
I have a form that calculates freight costs. I'm using a combo box for the user to select the route of the shipment from shipping port to destination port. The combo box has 2 fields. The index which is stored in the database and the description which is displayed to the user. I used the wizard to create the combo box and set the index to be saved in a table. Everything works fine, the freight cost is calculated correctly and the data is stored as designed.
The problem is when if the user goes back later and opens the screen to view the freight information, the combo box doesn't display what was selected previously. Therefore, no freight is calculated and the user has to reselect the combo box again. When I check the table, the index value of what was selected is in the table, but it will not display in the combo box.
. . . . Additional info to this post. . . . The combo box is set to use a data from a standard table. The user can only select what is displayed in the list. However, the index is then stored in another table after the selection is made. I want the combo box to do something like, if a selection was previously made then displayed what was select, if not, then display the data from the standard table.
What did I do wrong during the set up? Thanks for your help solving this problem.
Jeff
I need some help please
I have a db that has three forms (1 frmSearch, 1 frmFindCountyInfo and 1 subfrmFindCountyInfo (embedded in the frmFindCountyInfo)
I also have 2 tables (States and CountyInfo with StateID and CountyID set as PK in each).
Now I am trying to design it in such a way that when someone double clicks a State from the Mainform (FrmSearch), it should bring the frmFindCountyInfo with the corresponding state info for that State and this works fine.
Now in the subfrmFindCountyInfo, I want the user to be able to pick from a combobox a county within the Counties from the state selected and displayed in the frmFindCountyInfo
Data Source for FrmSearch: States
Data Source for FrmFindCountyInfo: States
Data Source for SubrmFindCountyInfo: CountyInfo
I also have a one to many relationship defined between StateID in States table and StateID in CountyInfo Table (I dunno if I am using it right though)
I have a query that works in Datasheet view but when I run the form, it picks just one county and there are non on the droplist.
Any help will be very much appreciated. Here are my queries…
Query to get State and Corresponding Info (works Fine)
SELECT States.StateID, [State] & " " & [Alias] AS StateFullName, States.Alias
FROM States;
Query to get County and corresponding data (seem to work in datasheetview but pulls up just first alphabetical county in combo box on form)
SELECT CountyInfo.County, CountyInfo.ReleaseFee, CountyInfo.ReleaseComment, CountyInfo.AssignmentFee, CountyInfo.AssignmentComment, CountyInfo.AdditionalInfo, CountyInfo.LastUpdated
FROM CountyInfo INNER JOIN States ON CountyInfo.StateID = States.StateID
WHERE ((([Forms]![FrmFindCountyInfo]![State])=[CountyInfo]![State]))
ORDER BY CountyInfo.County;
Also when I run subfrmFindCountyInfo alone ( I have to input State) it has the drop down with all the counties.
I dunno whatelse to do. Any help willbe very much appreciated.
I have created a combo box that simulates browsing, but limits it to a single filepath. I would like to store this file path along with the filename into my database in a field. There are two ways of doing this that I have found work, but i need a less cluttered way. 1) My rowsource string is created byrowString = rowString & filePath & fileName &";"fileName = dirthat's in a loop that reads all the files in the directory.... the problem with setting this rowsource to my combobox is that its very long and cluttered looking combo boxMy secont way is: rowString = rowString & fileName &";"fileName = dirThen i make a hidden text box whose value is filePath + Me!cboBox where the cboBox has the string value of the file (Sample1.jpg) In this instance i make the text box the control source instead of the combo box... but I'm pretty sure that's a bad way of doing what I want to doboth of these ways seem ... redundant, so i was wondering if there is a way to do this otherwise ?
View 3 Replies View Related