Drop Down List In 3 Tier Style
Feb 23, 2005
hi there , i am trying to populate a drop down list using a 3 tier style
1 will be the class.vb , next webservice.asmx , next is the webform
currently i am having some problems with the coding
<code>
//class1.vb
PublicFunction getBanquetProvider()
cnn.Open
Dim strSql As String = "SELECT DISTINCT Company FROM Banquet"
Dim cmd As New OleDbCommand(strSql, cnn)
Dim da As New OleDbDataAdapter(cmd)
Dim ds As New DataSet
Return da.Fill(ds)
cnn.Close()
//webservice.asmx
<WebMethod()> _
PublicFunction banquetProviderlist()
Dim dl AsNew CalculatorData.Class1
Return (dl.getBanquetProvider())
//webform.aspx
Dim bl AsNew getService.Service1
ddl_provider.DataSource = bl.banquetProviderlist()
ddl_provider.DataBind()
</code>
thanks in advance
View Replies
ADVERTISEMENT
Feb 12, 2005
Hi all,
I am not sure how to search the forum for info on this issue as I don't know the key words (Lingo) that would be used, so I decided to just ask...
I have a table called tblProducts with a one to many relationship with a table called tblTransactions.
I also have a paper form, much like a grocery list, that has known types of products to purchased on the top have and the bottom half has blank line to enter products purchased that are not listed above (or are unknown). The list is much larger and takes up more than one sheet of paper, but is done on a weekly basis. Here is a short "Grocery list" style example:
Date:_________
.
Description....Qty...........Description...Qty
Ice Cream:....................Milk:
....Vanilla......___Gal...........Whole......___Ga l.
....Chocolate..___Gal...........2%.........___Gal.
.......................................Nonfat...._ __Gal.
Bananas........___Ea.
..................................Meat:
Bread:..............................Pork.......___ lb.
..White.......___Loafs..........Beef.......___lb.
..Wheat......___Loafs..........Chicken....___lb.
.
----------------------------------------------------
____________ ___ ___........____________ ___ ___
____________ ___ ___........____________ ___ ___
____________ ___ ___........____________ ___ ___
____________ ___ ___........____________ ___ ___
.
I want to create a form that you can enter data into exactly like this and have the data find the product in tblProducts and then create a new transaction for that product in tblTransactions. If the product is new, then it would create a new product and the transaction. The date also has to be entered into each transaction, and most times the data is entered weeks after the paper is filled out, so using "today's" date won't work, it has to read it from the entered data.
Any help or direction would be greatly appreciated. I haven't been able to find anyone else doing this, but then I may not be searching with the right key words, as I don't know what you call this type of data entry.
Thank you.
View 1 Replies
View Related
Jan 10, 2006
Hi,
In the subform i have the layout i want with the text boxes and so on.
Now i have that in the main form the sub form is fairly big, but the problem i get is the subform only displays 1 record at a time. Is there a way i can get the subform to display all the records and for it just to add a verticle scroll bar.
So it is a list effect.
Thanks
k0r54
View 2 Replies
View Related
Aug 15, 2005
I would like to create a "wizard style" interface to allow users to Select items (staff members) by moving them from a list of "available" staff to a list of "selected" staff (and back again if they change their minds :rolleyes: ). - e.g. Like the Report Wizard, where you move table/query fields between the "Available Fields" and "Selected Fields" lists.
Does anyone have anything to help me out with this, that they could "lend" me ?
Of course I am stuck using AC97.... so I may need to borrow a hammer and chisel as well :D
View 1 Replies
View Related
Nov 15, 2014
In my current database there seems to be two different types of borders in my pop-up forms! The best way to explain it is that some forms will have the Access style border while others have the glass style border that you see in windows. I can't seem to find any settings that will change this or even determine what causes it.
View 4 Replies
View Related
Feb 8, 2006
I am currently creating a database to link together a maintenance system and a conditional reporting system and I’ve run into a little problem.
I am trying to create a form for assigning skills to a given contractor (contractor selected via a combo box (cboContractor)) by transferring selected items from a list box on the left (lstAvailable) to a list box on the right (lstselected). (much like any windows wizard would) This is done through the 4 buttons cmdSelect, cmdSelectAll, cmdDeselect, cmdDeselectAll.
Now it has been a long time since I have had to work with VB and I am struggling a little to create the required coding to pass data from one listbox to the other.
For reference:
CboContractor takes information from tblContractor. The data is ContID and ContName and the bound column is 1.
LstAvailable takes information from tblSkills. The data is SkillID, SkillComm and SkillNotes. Bound column is 1
LstSelected will place data into tblcontskills.
Tblcontskills has the fields, tcsID, ContID, SkillID
Can anyone help or does anyone know where I can find some good examples on the net as I have browsed through the search pages here and not really found a great deal that is valid
Thankyou in advance for your help everyone
View 2 Replies
View Related
Aug 18, 2005
Hello!
I'm still working on this supplier database for my boss and the supplier filter section is still causing me problems.
Let me set the scene for you....
I have a form with 3 combo boxes on it. These are cboProg, cboPPS & cboSupplier.
I need to get the combo's working so that when you select a programme from cboProg it filters the list in cboPPS (Primary Product or Service) to show only products and/or services that are used on that programme. In turn I need to make it so that when you select one of these Primary Product or Service's from cboPPS it filters the list of suppliers in cboSupplier to show only suppliers that provide that product or service.
Essentially, I have a HUGE list of suppliers that I want to filter down to suppliers that work on a programme providing a particular product or service using the combo boxes in the order shown below.
Programme (cboProg) --(filters)--> Primary Product or Service (cboPPS) --(filters)--> Supplier (cboSupplier)
When I have filtered the list of suppliers down to a list that worked on programme X, providing product or service Y, I'd like to make it so that you can just double click on that suppliers name to open their details.
I've based my previous efforts on a sample database called dbcombos that I found on this forum (I've attached it to this post). The only problem with this database is that it’s 2 sets of 2 tiered combo boxes on the same form and not a 4 tiered set of combo boxes as I originally thought.
Any ideas? All help greatly appreciated!
View 1 Replies
View Related
Dec 18, 2007
I am creating a table in Access 2003, and I need to add a drop down list to one of my columns. See the attached picture - I need to add a drop down list to the "Division" column that will allow the user to select from one of 5 choices. How do I do this?
I'm an Access beginner, BTW. :)
View 14 Replies
View Related
Mar 18, 2008
Hello all!
I have a drop down menu that pulls values from a table. When clicked that value pops up in a total field. Currently I only allow 1 value to be selected. When the user (me at this point) chooses another value, the value is added to the total instead of updating with the new value. So the every time it is clicked it just goes up and up. So I decided to add a loop. However it seems my look is not having an affect but obviously it is being read since the first part is being processed. I thought I would post it to gather thoughts... Thank you!
Quote: Private Sub lstbagels_Click() Dim newcharge1 As Currency Dim newcharge2 As Currency Dim oldcharge As Currency If oldcharge = 0 Then newcharge1 = Me.lstbagels.Column(2, Me.lstbagels.ListIndex) Me.txttotal.Value = Me.txttotal.Value + newcharge1 oldcharge = newcharge1 Else newcharge2 = Me.lstbagels.Column(2, Me.lstbagels.ListIndex) Me.txttotal.Value = Me.txttotal.Value - oldcharge + newcharge2 oldcharge = newcharge2 End If End Sub
View 3 Replies
View Related
Feb 12, 2007
I have one more question:
I have a ComboBox in a form that is looking at a field in a Table. When I select one of the items from the drop down it finds the record and shows all the fields in the form...
Everything works great, but
THere are quite a few records in the database, maybe 1000. If I use the scroll on the drop down and drag it to its bottom and let go, its not actually at the bottom. I have to do this repeatably in order to get to the full set of records.
Is there and easier way to do this?
I have run into this on other occasions with smaller number of records as well.
Would this run faster if I grabed this list from a query instead? And then set the form record to the value of the drop down (runngin the query)
Thanks in advance...
View 7 Replies
View Related
May 25, 2006
Hello,
Ok, let me preface this with I'm a newbie at Access, and I'm currently using Access 2003. I'm just hoping someone can point me in the right direction. Right now I have multiple tables with set data in them that doesn't change linked to another table where I have a drop down menu (combo box I think it's called in Access) to easily select the given data from. I want to have a drop down box (combo box) to have a set of given variables I have in a table to put in the search criteria. That way a user doesn't have to type the exact criteria into a query. That way I can easily put in the variables I want to search from in the query with less chance of an error. I'm hoping this is possible.
Ideally if I could get help in how to make a form that would allow me to have the set of columns from the corresponding tables with combo boxes to select from and then be able to have a "subimt" button and have it organize the selected results into that form as well.
Thank you for taking time to read this.
View 2 Replies
View Related
Dec 7, 2006
Hi all,
I'd like to modify a query of mine a little ...
Currenlty, when I click on my query and have it begin ... I have it set up where I then enter three seperate pieces of distinct data so that the exact information I'm in need of, which is stored in 2 seperate tables, can then be pulled together and displayed into one final combined table ...
I'd like to modify this beginning point where ... once I click on the query to begin, I can then just choose from a Drop Down list which has all the various rows of information displayed via these 3 unique indentifiers ... I then just scroll through and pick what I need and it then populates the final combined table as before ...
How do I add the drop down effect at the start of the query?
thanks,
TIM
View 1 Replies
View Related
Mar 18, 2008
Hi Everyone
I'm not too sure if this request is a query issue or not so please excuse if this is posted in the wrong section.
I am creating a database that picks up the start and finish time of each employee and displays the total hours worked by day and week.
I would like to be able to search by employee name from a drop down list but I am a unsure how to do this.
Can anyone assist?
Many thanks :)
View 1 Replies
View Related
Oct 11, 2005
Hi folks,
I want to populate a drop down combo box with a list of 10 years (current year +/- five years). I can enter them as a Value list but I don't want to have to update the list every year. Neither do I want to allocate a table to maintain a list.
Any ideas as to how I can auto populate the combo with a 10 yr span (5 previous and 5 next) and default to current year?
Thanks,
Dave
View 9 Replies
View Related
Mar 21, 2006
Hey guys, I have a question that I am hoping you can point me in the right direction on. Before I ask it, I am new to access. I have been looking at templates and reading and things on how to build a database. I have my tables setup, relationships I think are right and my form created. One of the things I am having trouble with is creating a drop down list to be able to pick a customer name for. I setup the combo box and have a customerID as the control source in the properties. I have the Row Source Type as table/query and the Row Source query setup so it takes the info from the customer table.
query:
field: customer.* name
table: customer customer
I think I am doing this the same way the templates have the properties but for some reason it won't allow me to pick from the list. It keeps saying "control can't be edited. It's bound to unknown field 'CustomerID'".
I attached my database. I hope it is clear enough that you might see what I have done wrong. Thanks in advance.
View 8 Replies
View Related
Sep 8, 2006
I'm pretty much a noob to visual basic, I've only taken C++ so I dont really know VB language. ok here is my question... I have a form and I added a drop down list through a table. What I want it to do is output into another text box within the same form when an item in the drop down list is selected. I think I have to make an event procedure for the "On Click" or "On Got Focus" selection. please help me out !!
View 5 Replies
View Related
Feb 4, 2014
If i have a drop down list containing employee type names e.g. Plumber plasterer bricklayer from the employee type table. How would i select the bricklayer and bring back records associated with the selected employee type . I have done a query to go and get the records for the employee type and it works for one employee type.
But I cannot get the button to go and get the records when i select different employee types from the drop down list. I could add loads of buttons with the same query and change the employee type but looks a bit crowded and untidy. Am i missing something simple or is it just complicated.
View 5 Replies
View Related
Jul 10, 2012
I have a drop down list in a table with name and commission rate. When I choose the name it displays but I want both the name and the commission rate to display in my table. I want to use a data entry form to enter values in the table and I want the same in the form too (when I choose a name I want the corresponding commission rate to show up).
View 3 Replies
View Related
Oct 15, 2015
I have a people table for all the people .I set a query to select only those that are Family Navigator Mentors ID,FName,LName..I use this query for a lookup on the family navigator table to select a mentor on the form I want the ID FName and LName to show up not just the ID.????
View 9 Replies
View Related
May 31, 2006
I'll admit from the start that I'm a newbie at Access 2003 and I've tried looking in the help file and internet searches. But I've become stumped on how to create what I'm looking for.
I would like to create a form that performs a query that has drop down menus with info from each specific column in a table. That way I don't have to necessarily need to know off the top of my head what data is entered in that column, but can click the drop down menu and get all of the data listed in that particular column. Once have a particular set of info selected, then have a button like "submit" and then the query results appear in a form and click through each page or results.
Is this possible?
View 1 Replies
View Related
Jun 3, 2006
Hi-
Can anyone help me? I am trying to add new records/data entry on a Form from a list of drop-down options.
I have a database of vendors with names addresses etc. I will be selecting a specific vendor from the pull-down menu and then add data entry comments. Please help!
View 1 Replies
View Related
May 16, 2007
Hi,
I have a combo box in which it's value changes according to user input. It is working but it is annoying to have to click the combo box for it's list to refresh. How to make it seemless?
Thank you
View 6 Replies
View Related
Jul 27, 2005
I want to create a drop list, so I can do that:
I select an item from the drop list. I detect the ID of the item and, depending of this ID, I select some records from a table.
Can somebody help me?
View 4 Replies
View Related
Jan 31, 2006
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 Related
Nov 17, 2004
My aim is to produce a report - using a drop down list (of customers from customer table) so that users can look at customer history.
I have created a form with a drop down list of customers - from customers table. I have used this to filter the results for a query on the orders table (gives me a history of that customer). All this works perfectly. I get all the transactions for that customer.
My question - is there a way I can create the same result but in a report format instead of the datasheet format. I.e the user will be given the data in report format when they select the customer from the drop down list.
View 3 Replies
View Related
Dec 8, 2004
Is there a way to add a drop down list to the message box in a parameter query so that users can enter a value(s) from the list in prompt? Thanks.
View 2 Replies
View Related