ms access

[CHIGGI123]

Hi ,



I have a excel sheet in which there are certain columns like BSC ,TRAFFIC RANGE AND PORT NO ,
Every BSC had 3 traffic range and upto 1-126 port no in a single traffic range so i want if a user input a BSC it will tell which port can be assigned .although i had more columns but actual logic is that only.Pls help

[pbaldy]

FYI I deleted your other 2 posts on the same topic. Please don't post the same question multiple times.

Is this an Excel question or an Access question? You have it in an Access forum and titled it Access, but it appears to be related to Excel.

[CHIGGI123]

sorry for repeated thing but all this databse is in access

[rzw0wr]

Sorry, I don't know what you are asking.
Can you explain with a little more detail what you are having a problem with.

Dale

[CHIGGI123]

Hi ,

Please see attached sheet i have such multiple sheets combined and uploaded in access .
so there will be a column " B" WITH certain character and corresponding to it are certain "TRAFFIC RANGE in column "C".

and there are 1-126 "PORT NO" AVAILABLE corresponding to every value in column "B" AND "256-2056" in column in column "E" value of column "F " will be same as Column "E".

What i want is if user inputs any value for column "A" and "B" it should tell the available COLUMN for "C" "D" and "E" and if user want to save it it should give option to save it in data base .

[June7]

You have links to worksheets? Or did you import into tables?

Might need cascading (dependent) comboboxes. Review http://datapigtechnologies.com/flash...combobox2.html

[CHIGGI123]

Hi ,

I will import everthing into Tables and then assign the new ports available and save those in tables to keep it updated .

[CHIGGI123]

the combo box can be helpful to view exsitng information but i want is the Ports which are currently not assigned and other things which are currently not in tables based upon values and save it

[CHIGGI123]

Sorry, I don't know what you are asking.
Can you explain with a little more detail what you are having a problem with.

Dale

can you help me with this now ?

[rzw0wr]

CHIGGI123,

I have not forgotten you

I am still fairly new to Access and I am thinking about what to do.

Will this data you uploaded ever be brought it from Excel again?

Are you converting from Excel to Access.

The reason for asking is that most of your data appears to need it's own table to work like you are asking.

Dale

[June7]

If you want the combobox to list only Ports not currently assigned, that will require a query that joins tables to be used as the RowSource. However, until you have working database structure, it is fruitless to even try to deal with requirements like restrictive combobox lists.

[CHIGGI123]

If you want the combobox to list only Ports not currently assigned, that will require a query that joins tables to be used as the RowSource. However, until you have working database structure, it is fruitless to even try to deal with requirements like restrictive combobox lists.

Yes i only wants port not assigned ,but in tables are those only where port is assigned ,so how can i get that combining tables?

[June7]

I don't know your database structure (that Excel was not helpful) so can't be specific but something like:

SELECT Ports.PortNum, PortsAssigned.PortNum
FROM Ports LEFT JOIN PortsAssigned ON Ports.PortNum = PortsAssigned.PortNum
WHERE PortsAssigned.PortNum Is Null;