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

Grocery List Style Entry

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

Puttin A Subform In A List Style?

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

Wizard Style List Selection Interface

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

Forms :: Access Style And Window's Style Form Border?

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

Creating A Windows Wizard Style Form (list Boxes)

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

3 Tier Combo - Based On A Sample Database

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

How Do I Add A Drop Down List?

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

Drop Down List Value Help

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

Drop Down List

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

Drop Down List In A Query

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

How To Add A Drop Down List To A Query

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

Search By Drop Down List

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

Drop Down List Of Years

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

Customer Drop Down List

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

FORM HELP!! With Drop Down List

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

Drop Down List Not Getting Records

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

Drop Down List In Access

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

Lookup Drop Down List

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

Drop Down List In A Query Form...

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

Data Entry From A Drop Down List

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

Refresh Combo Box (Drop Down List)

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

How Can I Link A Drop List To A Query?

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

Drop Down List Is Changing All Entries

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

Produce A Report - Using A Drop Down List

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

Add Drop Down List To Parameter Query

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







Copyrights 2005-15 www.BigResource.com, All rights reserved