General :: Selecting Specific Table From Listbox?

Apr 7, 2014

I have to make a multi-user manage database.All the usernames are sorted in one table and exported to listbox in Form.For each user there is a separate table with 3 columns where i must fill information from listboxes.The listbox (there are 4 listboxes, one for users select and 3 for different parameters) are located in MainForm where you select the information.My question is how can I select a specific username(table) from the listbox and fill the information from the other listboxes to the selected one?

The usernames table is named - Clients

each table for separate user is named client1, client2, client3 etc.

the form where you choose what to select is named Fill form.

The listbox for users is named - List71 And the listboxes for parameters are named - List75, List77, List79 Also there are 3 textboxes with calculated fields that i also need to insert in the specific user table.

View Replies


ADVERTISEMENT

Forms :: Adding Variable To Specific Row Of Listbox (Table / Query)

May 31, 2014

The VBA code I have at the moment:

me.Results.Rowsource = "SELECT car, title, FROM dbo_inventory"

Is it possible to add a variable to a specific row in listbox using the code above? In this case the price?

View 3 Replies View Related

Selecting Value From Listbox

Mar 14, 2006

Hi,

I have a two column listbox, list1.
How do I save the data on the 2nd column of the selected row?

To save data from the 1st column I do:

myData = list1.itemData(list1.listIndex)

Now for the 2nd column???:confused:

Why are lists so complicated?:mad:

View 3 Replies View Related

Forms :: Selecting A Specific Country Its Cities Should Appear

May 1, 2013

i have created tables as provinces, districts and sub-districts in my other forms say member i have create a look up wizard to the provinces, districts and sub districts. every province has multiple cities and every districts has multiple sub-districts my question is how to set properties so that if i select a specific province all its districts should appear in district field and districts of other provinces should be filtered. a good example is on some websites when we select a specific country all its cities or states appear in city field and if we change our option to some other country city drop box also changes to the cities of that respective country...

View 2 Replies View Related

Selecting Multiples Values From Listbox To Generate Report.

Aug 5, 2004

I have searched all the forms but could'nt find any answer which would help me , I have created a listbox , it works fine till the moment i set its 'Multi select' property to SIMPLE or EXTENDED , the minute i do that i get no results in my query , could someone please help me with this , i really really need to get this workin!! I have also uploaded my database so u could try it yourself...

View 11 Replies View Related

Forms :: Selecting Query Parameters From A Listbox - Select All

Aug 26, 2013

I've got a code that allows me to select one or many names from a listbox on a form and return data relevant to the name(s) selected from a query. The following code is triggered by a button on the form...

Private Sub Toggle4_Click()
'Set it all up for CSM selection
Dim db As DAO.Database
Dim qdf As DAO.QueryDef
Dim varItem As Variant
Dim strCriteria As String
Dim strSQL As String

[code]....

(Toggle 10 goes to the code for the second listbox which has the same code with different tables refered to giving two selections in the query.)

What I want to do is replace the "warning if nothing found" with a code to show data against all the names in the list box if nothing is selected in the listbox.

View 13 Replies View Related

Help Required Selecting Specific Records From Related Tables

Apr 15, 2008

Hi,

Hope someone can help me out on this one. Searched the forum but can’t find anything to help me out.

I have two tables:
tblCustomers that contains unique customer records (names addresses etc.)
and
tblComments that contains comment data for the customers

Tables are joined one to many tblCustomers -> tblComments on account_ref

tblComments can contain several records per customer, all are datestamped.

I want just the latest datestamped comment record per customer, just can’t seem to work the logic on this one. Must be so simple but can’t fathom it.:confused:

Ideally, I’m producing a report of Customer data (Name, address, contacts etc) + the last comment record for each customer. Have started with a simple query, but have hit an impasse. Have tried sorting, group by, top 1, distinct etc, but don’t seem to be getting anywhere.:mad:

If someone can point me in the right direction, and give me a starter for 10 I’d be much appreciated.

View 1 Replies View Related

Forms :: Selecting A Record From Listbox - Double Click Event

Jan 3, 2014

I would like to select a record on an already open form called "form_candidates" using a search facility but can't get it to work.

In "form_candidates" the data settings are set to "yes" (filters/edits/deletions/additions) and data entry is set to "no". On opening, the form is set to go to a new record.

In this form I have a button that opens a record search form so both forms are now open. I enter the first few letters of the surname into a text box, press a button and the listbox is populated.

In the doubleclick event of the list box I have the following code:

Dim CandID As Integer
CandID = Me.List4.Column(0)
DoCmd.OpenForm "form_candidates", acNormal, , "forms![form_candidates]![Cand_ID]=" & CandID

So I double click on the record, the candidate form is being filtered but the record isn't being shown.

View 3 Replies View Related

General :: Put Combobox / Listbox Values In A Separate Table Or Not?

Jan 29, 2015

Whenever I create a combobox, Access asks me if I want to grab the values from another table, or if I just want to manually input the possible values.

My question is: is one of the two solutions "better" than the other?

Let's imagine I am creating a Form where I can create a new Contact, and in a listbox (with multiple selections allowed) I want to list the possible character traits, so I have

- Funny
- Annoying
- Smart
- Interesting
- Good-looking
- ...

I think that if I need to store in the Contact records these possible traits, I will have to create a Many-to-Many relationship (therefor creating a junction table) between Contact and Traits.

On the other hand, could I do everything without grabbing values from an extra table and directly inputting the values in the listbox? How would these elements be stored in the Contact record if I allow multiple values in one single field?

View 9 Replies View Related

General :: Subtract ListBox Items In Field Of A Table?

Sep 26, 2014

I have a form with a textbox, listbox and a button.

my textbox is based on one of my tables, and when I enter a value (which is saved in my table) in my textbox and press enter, certain values in my table goes to my listbox, and my listbox will just additem whenever I do same thing in my textbox all overagain.

how can I subtract listbox.column(1) items in my table field "Item_Quantity" where my Listbox.column(0) is equal to my table field "Item_Description".

My Listbox column count property = 4
Row source type = value list

View 1 Replies View Related

General :: Syntax Of Export ACCESS TABLE To EXCEL In Specific Cells

Sep 1, 2013

For instance, first table export to EXCEL CELL A1 and then second table export to the same EXCEL but to CELL A5! I simply do not know the sytax to tell ACCESS to do the correct export!

e.g. DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, "EXPORTDATA", "c:EXCELSHEET.xls", True

View 3 Replies View Related

Forms :: How To Go To Specific Record In Listbox From Another Form

Dec 11, 2014

I have three forms: Form1 that contains subform1 and Form2 which is totally separate. Form1 contains a listbox that I use as a search form. When a record in the listbox is clicked, it populates Subform1 with more details.

If I am in Form2, I would like to be able to click a record which opens the listbox in Form1 to the same record (this will automatically update subform1 with the details).

View 7 Replies View Related

Forms :: Filtering Listbox - Cannot Go To Specific Record

Apr 28, 2014

I am using the Filtering a listbox method from this post [URL] .....

It works great apart from when i type too many characters and no search results can be found i get a run time error '2105' you cant go to the specific record.

I think it may be because my form has a row source. When the example uses an unbound from?

View 1 Replies View Related

Pick Listbox Item To Open Specific Record?

May 19, 2012

i have a list box that fills based on the following code.....

Dim strSQL As String
strSQL = "SELECT Products from [Client ProdVend] " & _
"Where Client_Account_Name = '" & Me.Client_Account_Name & "'"
Me.List91.RowSource = strSQL
Dim strSQL As String
strSQL = "SELECT Products from [Client ProdVend] " & _
"Where Client_Account_Name = '" & Me.Client_Account_Name & "'"
Me.List91.RowSource = strSQL

There is another field in the [Client ProdVend] table called ID. I want to be able to select a product in the listbox, but have that selection open up a form based on the ID field associated with that product. Right now i use this.

DoCmd.OpenForm "ProductDetailsEditor", , , "Products='" & Me.List91 & "' AND Client_Account_Name='" & Me.Client_Account_Name & "'"

The Problem is if there are multiple products with the same name, instead of going to the specific instance of the product(cased on the ID)...it just opens all of the products with that name up, starting with the first one.....

View 1 Replies View Related

Selecting Data From A Combobox To Get More Data In A Listbox

Nov 21, 2005

im new to this so hello every1!!!

umm.. i have a form with a combo box which is linked to a table which gives me customer id numbers. and i have a listbox which i want the names and addresses to appear when i select a cusotmer id number from the combo box

so on the list box i put
" SELECT CustName FROM Customers WHERE CustID=$combo43; " in row source; if i change $combo43 to 0 the name appear but that is fixed and i want it 2 change when i select a cusomer id number from the combo box

can some1 plzz help me, its 4 my college project!

thanxs in advance!

purejoker!

View 1 Replies View Related

General :: XLS Links And Selecting Options

Jun 9, 2012

I want to use information supplied to me by suppliers as spreadsheets to create a database that i can navigate through by selecting from drop down options.

Example;
Imagine a product being broken down by its features, such as a washing machine.

Here is a list of what i would need to sort on,

Manufacture
Model
Type
Size
Price
Colour...and so on

So, if a customer asked "what 8kg 1200rpm washing machines do you supply for under £300 and in black" i would like to able to find all that info by drilling down a few selections.

View 1 Replies View Related

General :: Selecting And Storing One Or More Choices

Oct 17, 2014

there could be one or more categories for each person, and in the end there could be a lot of categories, certainly 20+, but the idea is that i could add more when needed.

What's the best way to store these data?Should i create a new table called groups and create a coloumn for each category and write the ID there? Should i add one field to the common table and store all interests there as csv? Many coloumns?

how to collect these data? i don't want text field due to spelling errors and inconsistency (don't want someone to add automobiles and the other cars). Plenty of checkboxes? Multichoice box?

View 5 Replies View Related

General :: Second (Cascaded) Combo Box Only Selecting First Option

Mar 31, 2014

I have two dropdown boxes on my form, the second is dependent on the first and shows only employess from the company selected in the first dropdown box. I am using an AfterEvent update to filter the employees.

Now when I try and choose an employee other than the first one on the list it automatically goes back to the first person and the info in the subform only shows their information.

View 9 Replies View Related

Selecting From Table

Jan 17, 2007

heya all- ive got sql max working on my table beacause i changed a field type to number and then sql selects the maxium value- but i now need to select a specific number along with its record from that same table.
This specific number will depend on whats been selected in a drop down box- but when im running the sql its comming up with this error:

Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E07)
[Microsoft][ODBC Microsoft Access Driver] Data type mismatch in criteria expression.


Could this be to do with the field- beacuse i needed to change it to numeric type as i wanted to use sql max, and what way could i get round it???
Heres my sql command that im running to get a value:

Code:sub sqlCmd( )'==SQLSTATMENT=================================set objrs = server.createobject ("ADODB.recordset")dim sqlStatmentsqlStatment = sqlStatment & "SELECT * FROM [Areas] WHERE [Area_Code] = '"& Code &"' "objRs.OPEN sqlStatment,objConn,1,3'==============================================end sub

any suggestions??

View 1 Replies View Related

Selecting The Correct Table

Mar 10, 2006

I have an order table and depending on the the product grp it needs to then be able to select the appropriate size scale table.

e.g.

I order suits, and select a size grade A ( there are 7 size grades ) I then then to enter the size scale for that product. I am not sure whether to create 7 differant tables with the different size grades and link that to the table, if so how do i get it select the correct table.

please help...

H

View 1 Replies View Related

Selecting The Correct Table

Mar 10, 2006

Selecting the correct table

--------------------------------------------------------------------------------

I have an order table and depending on the the product grp it needs to then be able to select the appropriate size scale table.

e.g.

I order suits, and select a size grade A ( there are 7 size grades ) I then then to enter the size scale for that product. I am not sure whether to create 7 differant tables with the different size grades and link that to the table, if so how do i get it select the correct table.

please help...

H

View 2 Replies View Related

Selecting A Field Twice From The Same Table ?

Feb 5, 2007

I have a database spread accross a number of tables, I'll simplify it a bit here - there's questions, answers, respondents each as seperate tables.

Respondents includes
RID
Name
PostCode

Questions
QID
Question

Answers
AID
QID
RID
Answer

The answer table contains answers to all the different questions.

How can I query this to compare questions ? grouping answers to spot trends in the data

So I'd want to pull out the answers for questions 1 and 2 showing someone that answered question 1 with Yes and question 2 with No.

Any help would be much appreciated, or even a point in the right direction.
I've played with Crosstabs, multiple queries and pivot tables - none seem to be able to do this.

Thanks :)

View 8 Replies View Related

Selecting 2 Table At Same Time / Please Help

Oct 23, 2004

Hi
I want select 2 table at same time
this is my code and my first table
Code:
strSQL = "SELECT TOP "&Cint(intTopCount)& " * "
strSQL = strSQL & "FROM T_WEBLOG "
strSQL = strSQL & "WHERE b_published = true "
strSQL = strSQL & "ORDER BY b_date DESC, b_time DESC;"

the above code work very good
but I want select second table

I added this code to above code
Code:
strSQL = strSQL & "SELECT T_IMAGES.* "
strSQL = strSQL & "FROM T_IMAGES "

so this is my code
Code:
strSQL = "SELECT TOP "&Cint(intTopCount)&" * "
strSQL = strSQL & "FROM T_WEBLOG "
strSQL = strSQL & "WHERE b_published = true "
strSQL = strSQL & "ORDER BY b_date DESC, b_time DESC;"
strSQL = strSQL & "SELECT T_IMAGES.* "
strSQL = strSQL & "FROM T_IMAGES "


but after I added second code to it
I get this error
============
Microsoft OLE DB Provider for ODBC Drivers error '80040e14'

[Microsoft][ODBC Microsoft Access Driver] Characters found after end of SQL statement.

/functions.asp, line 71

===========


whats the problem
Please help me I need it

Thanks

View 5 Replies View Related

Selecting Multiple Postcodes From Table

Aug 15, 2006

This must be the easiest of things, but I haven't used access in a while in now in my new job I need to run the following query.

I have to select a number of postcodes from a single table to see how many are in there. For example select postcodes beginning with B, CV, DY, HR, ST, TF, WR, WS, WW. Then I need to write down how many records found with the above postcodes.

Also I may have to omit some too like omit CV12

Thank you in advance

View 1 Replies View Related

Selecting A Name Based On Table Contents

Apr 25, 2008

Hope this works, The table is as follows, ish

Name1 y/n1 y/n2 y/n3 y/n4 y/n5
a...........y......y....n.......n.....n
b...........n......n....y.......n.....y
c...........y......n....n.......n.....n
d...........n......n....n.......n.....y
e...........y......y....y.......n.....y
f............n......y....n.......y.....y
g...........y......y.....y......y.....y


what i need to be able to do is take a form/query answer some questions, y/n1= y/n2= y/n3= ......

Then off the back of this be able to pull out the correct item from column name1.

But i don't need an exact match on all columns. If i am only interested in y/n2=y i need to display all matches

My head says the following If y/n2=y and y/n3=y Then Name1 = e and g
or another example if y/n2=y and y/n4=y and yn5=y Then name1 = f and g

if a y appears in more columns it doesn't matter but it has to be in all those columns i am looking at

can anyone suggest the simplest way forward on this.

View 1 Replies View Related

Selecting Data From Multiple Table

Nov 17, 2004

Hi,
I have 13 tables in all. 2 are Area and Scope which have unique entries of areas and scope and the remaining 11 will have a primary key, Tag_No.
I want to select data from these 11 tables such that ALL the data will be pulled out but say table 1 has a column MOC and remaining 10 tables dont, then it will be a blank or null in those columns for the 10 tables. How can this be done? (I hope I am not confusing!!!)
Adwait

View 3 Replies View Related







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