Over 1 million tech questions and answers.

Access list and perfix list

Q: Access list and perfix list

Hello everyone,
Please help me to understand this.

On Router2, we can see the routes advertised:
Network Next Hop Metric LocPrf Weight Path
*> 1.1.1.1/32 10.1.1.9 0 0 100 i
*> 192.168.1.0 10.1.1.9 0 0 100 i
*> 192.168.2.0 10.1.1.9 0 0 100 i
*> 192.168.3.0/25 10.1.1.9 0 0 100 i
*> 192.168.3.128/25 10.1.1.9 0 0 100 i
*> 192.168.4.0/25 10.1.1.9 0 0 100 i
*> 192.168.4.128/26 10.1.1.9 0 0 100 i
*> 192.168.4.192/26 10.1.1.9 0 0 100 iClick to expand...



If I use an access-list to filter out few networks:

R2#conf t R2(config)#access-list 5 deny 192.168.4.0 0.0.0.127
R2(config)#access-list 5 permit any
Click to expand...

Will this command filter out 192.168.4.128/26 and 192.168.4.192/26 along with 192.168.4.0/25? If not why?
I think it should filter out because /26 comes under /25.
And why we need to use prefix list to filter 192.168.4.192/26 and 192.168.4.128/26?

R2(config)#ip prefix-list exclude_4 seq 5 deny 192.168.4.0/24 ge 25 le 26
R2(config)#ip prefix-list exclude_4 seq 10 permit 0.0.0.0/0 le 32
Click to expand...
Please help me out. I am really confused.

RELEVANCY SCORE 200
Preferred Solution: Access list and perfix list

I recommend downloading and running Reimage. It's a computer repair tool that has been proven to identify and fix many Windows problems with a high level of success.

I've used it in the past to identify and fix everything from blue screens (BSOD's), ActiveX errors, corrupt files and processes, dll/exe/sys errors, recover lost memory, Windows update problems, defragging, malware removal etc.

You can download it direct from this link http://downloadreimage.com/download.php. (This link will automatically start a download of Reimage that you can save to your computer.)

A: Access list and perfix list

Am I posting this in wrong place.
If so please let me where am i suppose to post.

Read other 1 answers
RELEVANCY SCORE 71.6

I had a distribution list for a mass email for some of our customers. But when we got Microsoft Exchange everything copied over but this one (the most important list!) did not copy over. But I checked through the sent messages and was able to copy the list from the BCC Field to a text file.

Now, I need to get this list of people back in a distribution list. If anyone knows how I can achieve this, please help me out! I've been google-ing this and cant seem to find something to work for me!
 

A:Solved: Import list of emails to Outlook Contacts or Distribution list

Read other 11 answers
RELEVANCY SCORE 71.6

I'm running Win10 Pro 64bit and Revo Uninstaller Pro v3.1.5. There is a huge discrepancy in the installed programs lists provided by Revo Uninstaller and the Win10 Programs and Features control panel. They both say there are 83 installs (that's good). But Revo Uninstaller claims that 15 programs were installed a few days ago on 2/29/2016. The correct number is 3 which is what Win10 says. Today I uninstalled Revo Uninstaller (using Revo Uninstaller to do it) and then reinstalled it. No help.

I guess it might be OK to ignore this discrepancy but I find it surprising.

Suggestions?

-- Larry

A:Revo Uninstaller List Differs from Win10 Progs and Features List

Originally Posted by larrymcg


I'm running Win10 Pro 64bit and Revo Uninstaller Pro v3.1.5. There is a huge discrepancy in the installed programs lists provided by Revo Uninstaller and the Win10 Programs and Features control panel. They both say there are 83 installs (that's good). But Revo Uninstaller claims that 15 programs were installed a few days ago on 2/29/2016. The correct number is 3 which is what Win10 says. Today I uninstalled Revo Uninstaller (using Revo Uninstaller to do it) and then reinstalled it. No help.

I guess it might be OK to ignore this discrepancy but I find it surprising.

Suggestions?

-- Larry



I show same thing. You may have discovered a "leap day" bug in the Revo app. I wouldn't worry about it, honestly. It's how it calculates the term "Recently". If you use CCleaner and look at tools/uninstall it list progs. Sort descending date...you get a another answer.

Read other 1 answers
RELEVANCY SCORE 71.6

I have an EXTERNAL USB Drive 1gb that I use to IMAGE machines all the time.  An employee got a new laptop Dell E5470 with an M.2 Sata SSD, and when I boot this machine to the external drive to apply a new image, diskpart does not show the External HDD under List Volume or List Disk.  I have played around in the BIOS thinking because of the new M.2 Sata SSD there was a setting that was causing this but I am unable to find anything that allows this to work.  It will boot from the External Drive but when running diskpart, it will not sow the drive so I can't apply and image or take an image since I have no were to place the image or copy it from.

Read other answers
RELEVANCY SCORE 71.6

I have two lists.
List one is raw data. List two is a collection of flag/alert words.

I need to find any term in list one that contains any flag word from list two.

Examples
LIST ONE
appleworm
wormapple
woapplerm

LIST TWO
Apple

In this example every term on list one would return a result of 'true'. LIST TWO is always much shorter than list one.

I was trying to set it up so that in the column directly to the right of LIST ONE produces a 'true' if that list one term contains in any fashion any term from LIST TWO.

As you will see in the example I was also trying to have a similar column to the right of LIST TWO so that I could easily see how many of the key terms had been found in the much larger list.

The sample also has color fill based on the True/False to make it easier to visualize.

Can anyone help make this work correctly?
Match does not work because I am not looking for identical strings.
I have not been able to get Find or Search to work either.

As of right now it only seems to look at the other list's entry on the exact same ROW.
 

A:Excel - Two lists, search for any string in list 2 in any entry in list 1

Read other 16 answers
RELEVANCY SCORE 71.6

Anyone know what program can merge word/excell lists of email address to a window mail contact list?

Read other answers
RELEVANCY SCORE 71.6

Hi there (time to stop lurking!)

I have already created a Macro to create a local distrobution list(s) from an Excel sheet with email addresses.

Assuming the user already has write access to modify members to the Exchange list, is there a way through VBA to;

A) Check if the email address already exists;
B) If not, then add the member to the list

Thank you

Raf
 

A:Updating Exchange Distrobution List from Excel Contact List

Read other 12 answers
RELEVANCY SCORE 71.6

Hi,

Attached is an excel sheet (Book1), in which I need to Copy the items from A1 to D3 in a comma separated value as in F.

For example,
A1 A2, A4, B4, C4, D4
A1 A2, A5, B5, C5, D5 and so on.

And transpose the above sheet as in Sheet2.

Thanks you,
miha
 

A:Copying a list into Comma separated values and transpose the list as well

Review your Sheet and let me know do you need in this fashion

Parent Class: Sprocket Child: Simplex Pitch
Unit
Teeth
Type
This is what i get on transposing, if this the case then just confrim it so I can give you the code.
 

Read other 2 answers
RELEVANCY SCORE 71.6

I am currently receiving 27 reports that I have to compile into a master list on a daily basis. I tried creating an .bat file using notes to copy these lists into a master list but it is not working (please see code below).

copy *.xls importfile.xls

When I run this file it only copies one of the 27 files. Is there a way that I can run a macro to do this for me. I am really not familiar with macro's and am hoping that someone can point me in the right direction.

The files in question are all identical except that each file pertains to a different Div in our company.
Thanks,

 

A:Solved: Using a macro to copy several excel list into one master list

Read other 7 answers
RELEVANCY SCORE 71.6

Can you tell me the number of emails you can block in the Block Sender list in Hotmail is it unlimited or is there a limit if so can you tell me the limit and for the contact list for both Hotmail and yahoo
 

A:Hotmail and yahoo block Sender list and Contact list ?

http://forums.techguy.org/showthread.php?t=255890
 

Read other 1 answers
RELEVANCY SCORE 71.6

Hi Everyone,

Am looking for a way to remove the actual option to "Log on to: computername (This Computer)" from the list so users will only have the option to logon to the domain.

This can be done as they did it in my uni...

Thanks for any help / ideas you might have.

Karl
 

Read other answers
RELEVANCY SCORE 70.8

OK. This is driving me crazy. Using Active Directory I created a Global Security group. I also tried Global Distribution group. Neither of them are showing in my Global Address book. What am I missing?

OS: Windows 2003 Server
Mail: Exchange Server 2003

Please help.

Wayne
 

A:Solved: Distribution List in Global Address List

It has to be set up as a Global Distribution group and you have to ensure it has an email address. I am not sure it will show up until you restart Outlook.
 

Read other 2 answers
RELEVANCY SCORE 70.8

Why do I have so many lists of svchost files?
Please see the attachment of the screen shot
Task Manager List. Does anything in this list raise a question?

Read other answers
RELEVANCY SCORE 70.8

Complete list of Ransomware, Browser Hijacker, Keylogger, Adware, Toolbar, Trojan Horses, Computer Worm, Spyware and Bot?

A:Where can I find a complete list or comprehensive list of these malware

With the very general nomenclature you ascribe to each form of malware. It is highly unlikely you will find a single repository for a comprehensive list for each category.

Read other 0 answers
RELEVANCY SCORE 70.8

Like so many, I need help with a slowing computer, and appreciate your site. Would someone please tell me why my Task Mgr. Processes list showed 54, and the System Configeration Utility showed only 23 that were checked? I already unchecked 14 of those, & have shutdown several times since, and now have 47 processes showing in Task Mgr. (??) Do I simply use the definitions on sysinfo.org and delete what I determine in Task Mgr? I wonder why the lists do not match?

Also, can someone suggest the best computer cleanup program, free, or otherwise for a medium knowledge user? And, I am wondering what my virtual memory should be at. I have a 1.7, with currently 640 MB ram. (I had to take out one stick when I learned the slot is bad). What should it be when I bring it back to 1 GH. I am running XP Pro, Ser. Pk 2. ..........Thanks!

A:Why Is Task Mgr. List Longer Than System Configration List

Task Manage shows running processes - System Configuration shows several things in it's Startup and it's Services tabs.The svchost.exe processes house (typically) between 1 and 25 other processes running beneath one instance of it.The System Configuration tool is designed for troubleshooting, not for tuning your system. For tuning I'd suggest this free application: http://www.microsoft.com/technet/sysintern...s/Autoruns.mspx

Read other 1 answers
RELEVANCY SCORE 70.8

I've been banging my head on the desk trying to figure out how to simplify my zip list. Can anyone help with the attached example. I'm thinking I need VB code to do this but haven't been successful finding a solution.

thanks,
Jeff
 

A:Solved: Convert Excel zip list to simplified list

Read other 8 answers
RELEVANCY SCORE 70.8

Using the inbuilt duplicate highlight function in a column lists everything that is a duplicate. Even when a filter is applied it still shows entries as duplicate. Which is correct, it is a duplicate.

How to only show duplicates in the filtered list pertaining to the filtered data?

Niemeyer 60242 $1,178.10 12/11/2009 Niemeyer 58186 $1,178.20 18/06/2009 Niemeyer 7907 $1,178.10 24/02/2009 Niemeyer 7449 $1,178.00 22/01/2009 Niemeyer 7007 $1,178.00 22/12/2008 Niemeyer 7007 $1,155.00 22/12/2008
the date col shows a duplicate 24/02/2009 but is totally unrelated to Niemeyer, date belongs to another record for another company that is not in the filtered list
 

A:Filter list to show only duplicates in the filtered list

i have not used the duplicate function in excel 2007

I would create another column and concatenate the columns

=a1&b1&C1&e1

that will bring column A, B, C and E into one cell - say cell H

I want to test for duplicates and then use something like in Column I
=IF(COUNTIF($H$1:H1,H1)>1,"Duplicate","Unique")
OR
=COUNTIF($H:$H,$H1)=1
to test that new column and then filter

But i'm sure an excel guru will be along to propose a better solution
 

Read other 1 answers
RELEVANCY SCORE 70.8

Hey Guys,

I am having this problem where in the system tray the network icon is showing incorrect information. It displays a red "x" even though I am surfing the internet. When I hover over the icon it displays "Connection status:unknown The specified service does not exist as an installed service".

I stumbled upon this post and I noticed that I am completely missing Network List Service. How do I make this option visible in the list of services? Can I somehow install this service?

TIA.

A:Network List Service is missing from the list of services

Hi Digital-flex,

Welcome to Vista Forums.

You might try running a sfc /scannow command to see if it can find and fix any system files that may be causing this. This tutorial will show you how to if needed.

System Files - SFC Command


If that does not work for you, then you can do a Repair install. This tutorial will show you how to if needed.

Repair Install For Vista

Hope this helps,
Shawn

Read other 2 answers
RELEVANCY SCORE 69.6

Hi, I need some help from you guys to clarify some issues in Outlook 2003.
I have added some contacts, catagorised them, eg. Colleagues, Friends, Family. Now that I want to send e-mails to all my colleagues.

I opened the "New Message to Contact" then clicked on the "To" button and waited to see the list of my contacts show up, however, it shows a dialog box saying:

"The address list could not be displayed (not including the smiley ofcourse). The contacts folder associated with this address list could not be opened; it may have been moved or deleted... blah blah blah"

Knowing that nothing is deleted or damaged, I ignored it, and tried to create distribution list, gave it a name and clicked on "Select Members" then the same messsage box appears (as above).

I've been told that it uses contacts in the "Address Book" of Windows (to my knowledge, when you back up Outlook 2003 .pst files, these entried aren't backup too) and I would liek to keep my contacts in one place, in the .pst that is, so does this mean, to have distribution list (mailing list) to mass mail to my colleagues, I must use Windows's Address Book ? This has also been an issue with my clients who use Outlook.

How does all these contacts thingy work ? I would like to get my head around it, gimme a hand guys
 

A:Outlook Mailing-List / Distribution List

You need to set up Outlook to use your Contacts as an address book. Go to Tols > Options and click the Mail Setup tab and select the Mail Options button. Select the radio button for View or Change Existing directories or Address books. Click next and see if there is an entry for Outlook Address book and if it isn't there add it. If it is there it may be corrupted thus your message so delete it and recreate it. Once it is in there open your contacts folder and in the Outlook bar on the left right click on the contact item and select properties. select the Outlook Address Book tab and put a check in "Show this Folder as an Address Book" Should work after that.
 

Read other 2 answers
RELEVANCY SCORE 69.6

Edit: Sorry I made the topic an forgot to change the title. Should be: "List Files in Folder With Ignore List" or something along those lines.

I'm a game server admin. What I want to do is generate a text file which will be used when I launch the server. An example of the text file I want to produce is here:


Code:
sv_name "PlayMyServer"
sv_maxplayers 16
sv_mapcycle_add wizard ctf3
sv_mapcycle_add bloodgulch ctf3
sv_mapcycle_begin
Line 1 and 2 will be hard coded into the script. In fact, this section will have more lines but for this example, I've cut it down. Lines 3 and 4 are codes that add all maps to the server: wizard and bloodgulch. These are *.map files. Line 5, like lines 1 and 2, are to be hard coded.

The map files are in the \maps subdirectory of the game. What I'm looking to do, is create a batch file that will generate the above text. That is, getting a list of map files in the \maps directory and concatenating it with the proper text before and after. I also want to have the .map extension removed from the lists.

The \maps subdirectory has a few *.map files that aren't actual maps, in fact I don't know what they are. So, I would like to be able to allow for exclusions, which I will hard code as well. (i.e.: ui.map, sounds.map)

Note that this script will probably be saved somewhere in the Quick Launch folder and I want to specify the location of the output and the name of the file. It will be in a text file format.

If ... Read more

A:List Files in Folder With Ignore List

DIR "D:\Data\" /s > "D:\List.txt"

This script will make a text listing all files in a folder.

D:\Data is where the folder is located and D is the drive where the text file "List" will be created. Note Windows 7 will NOT allow the text file to be created on C-drive.

You may have to edit to get what you want in the text files. I have found this script to be very useful.

Read other 4 answers
RELEVANCY SCORE 69.6

when I go to scan my computer with eset, there is a list of drive letters to scan but they don't go anywhere, don't show up on the list in "computer". and even eset gets an error. Is it possible they are hidden and from vmware use? or could it be something else? I've scanned with eset and malewarebytes but my computer is clean as far as I can tell. Any thoughts?

Read other answers
RELEVANCY SCORE 69.6

I am curious why a listing of 22 products in Norton Systemworks and Norton Firewall Live Update list would have dropped to 7 products in the last week or so. The rest have been there since early December.(only antivirus still showing). I don't know what is being updated now other than the antivirus program. Anyone have any ideas?
Can I remove Systemworks and Firewall and re-install them or will that cause problems?
Thanks for any info.
 

A:products disappearing from liveupdate list list

The 22 products will have been compacted down to 7. I think what happens is that as soon as fix is needed a stand alone update is put out pretty fast and is then refined and eventually combined with a few others into a single update.
 

Read other 1 answers
RELEVANCY SCORE 66.8

Hello,

I'm a Windows Vista Ulitimate 32 user since 2008. I've always updated the system using "Windows Update" but since two weeks ago, the system jut don't show the list of updates available. It tells me I have new updates (system tray icon) but when I open it, I cant see nothing. Here is the printscreen:

The gray background is just my personal configuration... So, I can see I have 41 optional updates, for example, but there is no list of them! quite strange.

Anyone can help me, please?

Best,
retrolectro
S?o Paulo, Brazil

A:Can't see updates list (blank list)

1.If it is English Vista and you have installed Spanish language pack then restore English language and uninstall Spanish
2.Reset WU components in aggressive mode http://support.microsoft.com/kb/971058
3.





The gray background is just my personal configuration



restore original configuration

Read other 4 answers
RELEVANCY SCORE 66.8

Sent here from thread here: http://www.bleepingcomputer.com/forums/t/558424/the-perils-of-email-attachments-something-definitely-wrong/
 
While earlier scans found a few things and cleaned it up, was recommended to come here to make sure there's no deeper issue.
 
DDS.txt:
 
DDS (Ver_2012-11-20.01) - NTFS_AMD64
Internet Explorer: 7.0.6002.18005
Run by Lewis Family at 15:47:33 on 2014-12-14
Microsoft® Windows Vista™ Home Premium   6.0.6002.2.1252.2.1033.18.6142.2476 [GMT -5:00]
.
AV: Norton 360 *Enabled/Updated* {D87FA2C0-F526-77B1-D6EC-0EDF3936CEDB}
SP: Norton 360 *Enabled/Updated* {631E4324-D31C-783F-EC5C-35AD42B18466}
SP: Windows Defender *Disabled/Updated* {D68DDC3A-831F-4fae-9E44-DA132C1ACF46}
FW: Norton 360 *Enabled* {E04423E5-BF49-76E9-FDB3-A7EAC7E589A0}
.
============== Running Processes ===============
.
C:\Windows\system32\lsm.exe
C:\Windows\system32\svchost.exe -k DcomLaunch
C:\Windows\system32\svchost.exe -k rpcss
C:\Program Files (x86)\Trusteer\Rapport\bin\RapportMgmtService.exe
C:\Windows\system32\Ati2evxx.exe
C:\Windows\System32\svchost.exe -k LocalServiceNetworkRestricted
C:\Windows\System32\svchost.exe -k LocalSystemNetworkRestricted
C:\Windows\system32\svchost.exe -k netsvcs
C:\Windows\system32\SLsvc.exe
C:\Windows\system32\svchost.exe -k LocalService
C:\Program Files\Dell\DellDock\DockLogin.exe
C:\Windows\system32\Ati2evxx.exe
C:\Windows\system32\svchost.exe -k NetworkService
C:\Windows\System32\spoolsv.exe
C:\Windows\syst... Read more

A:Install List list installed twice

Hello, Welcome to BleepingComputer.I'm nasdaq and will be helping you.If you can please print this topic it will make it easier for you to follow the instructions and complete all of the necessary steps in the order listed.===Download the version of this tool for your operating system.Farbar Recovery Scan Tool (64 bit)Farbar Recovery Scan Tool (32 bit)and save it to a folder on your computer's Desktop.Double-click to run it. When the tool opens click Yes to disclaimer.Press Scan button.It will make a log (FRST.txt) in the same directory the tool is run. Please copy and paste it to your reply.The first time the tool is run, it makes also another log (Addition.txt). Please attach it to your reply.===Please paste the logs in your next reply DO NOT ATTACH THEM unless specified.To attach a file select the "More Reply Option" and follow the instructions.What are the remaining issues with this computer?Wait for further instructions.

Read other 8 answers
RELEVANCY SCORE 66.8

Sorry bad title, hard to explain the issue. I'll try to do better now.

On my Apps list is the installed apps. As expected. But many of the installed apps include more than just the app in the list. An example, I have installed RoboForm on the Apps List is a list of several RoboForm icons. The icons, Buy RoboForm, Generate Passwords, New version check, RoboForm, RoboForm Editor, Search Box, Search Files, Taskbar Icon, and Uninstall. A total of 9 Icons for this one program (App.) I have other apps with the same issue, but RoboForm is the worst. Is there a way to group these icons so that I only have 1 RoboForm icon? There are also other icons on the list that I would like to delete such as the "Register Device" that came with my new Dell laptop. It was registered now I don't need / want to be reminded to do that again.

Hopefully this makes sense to readers, it is very frustrating to me.

Thanks,
Ron

A:How can I group the list in the Apps list?

Hello Ron,

If you like, you can sort the Apps screen by name, date installed, most used, or category. Name or category may be best for what you are wanting.
Apps Screen - Sort By in Windows 8.1
Afterwards, you can also add or remove items from your Apps screen.
"Apps" Screen - Add or Remove Items in Windows 8
Hope this helps,
Shawn

Read other 1 answers
RELEVANCY SCORE 66.8

is there a way to take a list of objects in a folder, and output it to a text document that lists everything in that folder?
 

A:Folder List into Text List?

Get Karen's Directory Printer, it will make lists of folders/files plus the common attributes.
 

Read other 2 answers
RELEVANCY SCORE 66.4

I have accidentally clicked on an associated Windows Media Player file, so many times, destroying the list of songs on the "now playing" list? How do I go back to the previous playlist (unsaved) if I accidentally select a WMP file? How many playlists does it go back?

Actually I found a way to step back, but I can't seem to find it consistently. How do I do it?

Read other answers
RELEVANCY SCORE 66.4

I have a list box on Form A using a table/query rowsource. It is a multi-select listbox. I need to code so that the user select the records from the list. The rows will be saved to a temporary table so that I can modify the data and then append the base table with the new rows. The user will then open Form B with the new rows in a different list box.

Any ideas?
 

A:access xp list box help

I have a list box on Form A using a table/query rowsource. It is a multi-select listbox. I need to code so that the user select the records from the list. The rows (the rows will have approximately 20 fields of which 2 will be modified, and only 4 are visible on listbox) will be saved to a temporary table so that I can modify the data and then append the base table with the new rows. The user will then open Form B with the new rows in a different list box.

Any ideas?
 

Read other 3 answers
RELEVANCY SCORE 66

Can I use switch user option on power option list or on start menu list ?

A:switch user option on power option list or on start menu list

Hello jk22,

If you like, you could already use either option in the tutorial below to natively switch user. OPTION ONE is the closest to what you want.

Switch User in Windows 10

Read other 1 answers
RELEVANCY SCORE 65.6

I have a combo box setup to populate a listbox found on a subform. However, there are some entries in the combo box that are empty, so they do not populate the listbox.

Is there a way to hide the entries in the combo box that will not populate the listbox?
 

A:Access Combo Box and List Box

Read other 16 answers
RELEVANCY SCORE 65.6

Hi, i have a form (FormPatient) shows the details of PatientTable, it shows the fields such as last name surname and patientnumber(unique). under this form i am able to create navigation buttons, and save record, edit, and delete records, so my next task is to generate a query with one click of the button to generate what does the patient ordered, like meals, but a patient can have multiple meals, hence the use of list box is the show multiple meals in one patient

ive tried several ways, but no matter what, it only comes out with 1 meal per record, to i have to 6 records with same PatientName with different meals, so i want to have 1 record that have 6 meals so i can put them in my listbox pretty easily by just using the form wizards

so example, Patient name Andrew Lim had ordered a fish, rich and apple, so first i open the FormPatient then browse for Andrew Lim then click the button called show meals, and it open another form which shows all the details including the FormPatient Detail with a listbox that shows all the orders that this patient had, in one record, one list box, how do i do that?! help plz! really desperate
 

A:List box in access 2007

Read other 8 answers
RELEVANCY SCORE 65.6

I am trying to get the wifi access point list nearby.I am using iwlist command but the result different each time each time I get the different list. Can anyone tell that what is the reason behind that as I think that while sitting at the same place result of iwlist should be same.
an other thing ,what does it men by quality and cell in ilwist response.
any helpful link ,reading material and guide line will be highly appreciated.
Ooo yes I am using ubuntu linux.
 

Read other answers
RELEVANCY SCORE 65.6

I am converting an Excel spreadsheet to an Access 97 Database and I wanted to make a drop down list which has all the info from a feild which is already there, and also allow the user to update the contents of the list.
Can someone tell me the easy way to do this?
 

A:Drop down list in Access 97

Hi - cut and paste the data from spreadsheet into the relevant field and table in your database. Open the related form in design view and open the Toolbox (make sure that the wizard wand on the Form design toolbar is depressed then select the combi-box wizard, in the toolbox, and follow the instructions.

When you have finished, right click on the combi-box and select properties. Click yes for Enabled and No for Locked - that's it.

stepheno
 

Read other 2 answers
RELEVANCY SCORE 65.6

I have created a subform, and in the subform I have some fields from a table, I added some fields to this table, but when I go into the subform to add the new fields in, they are not in the field list. I did a seach on how to update the field list, but it said to click on some refresh button that I think doesn't exist.

Chad
 

A:field list in access

Close all the forms, reports, tables, whatever and reopen.

you can also try closing everything and then go to View>Refresh (f5)

if both of those fail....close the database and reopen it.
 

Read other 2 answers
RELEVANCY SCORE 65.6

I'm not a very experienced Access user - but have created a DB with 7 fields and have made a FORM for data entry. For one of the fields in the form I created a LIST BOX and entered several four letter abreviations for the list. But when I open the form, the list box doesn't appear!!

Anyone?
StanC
 

A:List box problem in ACCESS

Read other 6 answers
RELEVANCY SCORE 65.6

Would any Cisco experts be able to lend a hand with the following ACL requirements that I need to implement on a Cisco router at work?
Block all inbound ICMP messages with the exception of Echo Reply (type 0), and Time Exceeded (type 11). ICMP message number 3, code 4, are permitted inbound with the following exception: Must be denied from external access gateway (AG) addresses, otherwise permitted.
Also block outbound ICMP traffic message types except Echo Request (type 8), Parameter Problem (type 12), and Source Quench (type 4) Destination Unreachable - Fragmentation Needed and Don't Fragment was Set (type3, code 4).
Also block all inbound traceroutes to prevent network discovery by unauthorized users.

Thanks for any help!
 

A:Cisco IOS Access List Help

Assuming this is a router. Also, "blocking traceroute" is very ambiguous. It's close enough, a better way would be some reflexive ACL's, but this is assuming you're running 12.0x.

int x/x
ip access-group foo1 inbound
ip access-group foo2 outbound
!
ip access-list extended foo1
permit icmp any any echo reply
permit icmp any any time exceeded
deny icmp host x.x.x.x host y.y.y.y Destination Unreachable
deny icmp host x.x.x.x host y.y.y.y Source Quench
permit icmp any any Unreachable
permit icmp any any Source Quench
deny icmp any any log-input
permit ip any any
!
ip access-list extended foo2
permit icmp any any Echo Request
permit icmp any any Parameter Problem
permit icmp any any Source Quench
permit icmp any any Unreachable
deny icmp any any log-input
permit ip any any
 

Read other 1 answers
RELEVANCY SCORE 65.2

hey everyone

I was just wondering if anybody could spare some time to help me out with a problem
we have set up a network in our house with the use of a hub and router...we have broadband connected to NTL....with six computers connected

However one of our flatmates computers gives this error message when she tries to use IE: 'Forbidden, You were denied access by access control list'

She uses win XP..

She can still use messenger which shows the connection to her comp is fine... I have had a search around the net with no luck...something to do with her ISP connection although our ISP is well NTL i think..... i just plug and played this computer, no CD or anything...

any help would be hugel appreciated

thanks

dave
 

A:access denied by access control list

Read other 10 answers
RELEVANCY SCORE 65.2

I have installed the BT home hub (British Telecom) There are two user accounts on my pc. I am the administrator, and have no problems using the connection to the hub (either wirelessly or by cable) at all!

I do however, have a problem with any other user been able to connect to the internet. I have tried making them and "Administrator" too, and I get the same error message:

Forbidden

You were denied access because;
Access denied by access control list.

My reasoning told me that it might be a software problem, as a dial up connection, and a standard broadband cable connection all worked peviously with the two "Adimistrator", and "restricted" user accounts.

I spoke to BT who decided that it was a microsoft issue...microsoft UK want to charge me ?49 to help as my XP Home Edition wasn't bought from them, it was pre-installed. I contacted Time Computers for help from them, though I am utterly dissapointed in them...I am a novice computer user, but I recognised that my ?1 per minute technical help call was ludicrous...DON'T USE IT! They spend 5 mins getting and checking your details!

1, Since when has creating a shortcut to a connection ever "lifted" an access denied?

2, I was also told to delete the accounts that were not allowed the access. They told me to click on save files, after I had started to delete the account...they got mixed up with the order of how things are done! Luckily I got it halted!

3,... Read more

A:Access denied by Access control list

Hi Scudda, welcome to TSF..

apologies as i'm not familiar with the BT Home Hub system.....is there any software installed on the computer to enable it's operation?

Read other 15 answers
RELEVANCY SCORE 65.2

Hello,

I had to rebuild my PC a week or so ago and now cannot access a website that I have always been able to access before.

I keep getting a message saying "Forbidden. Access denied by access control list" but there is absolutely nothing within my access control list restricting this site.

I then went in and added the URL as an allowable site within the access control list thinking that might help and I'm still forbidden from accessing the site.

I've cleaned out my cache and ran Ad-aware to see if that would help and still nothing.

Any suggestions?

Thanks very much.
B.
 

A:Access denied by access control list.

Do you have a firewall running, the ACL within the firewall might have the URL listed.
 

Read other 3 answers
RELEVANCY SCORE 64.8

I am now getting this error when using IE...

Does anyone know what it is...? I am fully protected by McAfee, Adaware and Spybot.
 

A:Access Denied by Control List...???

If you're on a dialup connection, the problem is usually fixed by creating a new dialup connection and deleting the old.

My Computer>Dialup Networking>Make new connection, step through the wizard to make a connection identical to the old except for what you call it. Example: If the old connection is named "Internet," name the new one "Internet2."

If that works, just delete the old connection.

If it doesn't work, start looking here.
 

Read other 2 answers
RELEVANCY SCORE 64.8

I have been asked to build a database (access 03) to contain all our contacts separated by the type of reports we send these clients, this I was able to do (I think). Anyway Iím now to the point where the contacts have been added, I created queries for each of the groups, Now I want to be able to click on one of the groups and have a module open outlook if its not already open create a new message and add all the email address in the specific query to the BCC line in outlook and thatís it. I donít really want the message to automatically be sent. I want that to be a manual process so the subject and body or attachment can be changed each time (as the message varies from email to email so more like a .display instead of a .send. Is this possible?
 

A:Solved: Contact list access help

Read other 16 answers
RELEVANCY SCORE 64.8

Using Access XP

Is it possible to run a query on a list of records?

Example: Our database using vehicle registration numbers (VRM). I want a form where I can paste a list of VRMs then run a query on each VRM.

Something along the lines of...

If VRM={1st line of list} then FIELD2=Yes
Repeat for the following lines until the end of the list.
TIA
SlimboyFat
 

A:Solved: Access - Query From List

Read other 16 answers
RELEVANCY SCORE 64.8

I am a complete noob at Access (prior Filemaker usage... but alas, cannot find disk to install)... Here's what I'm trying to do:I want a report or form (not sure which is the best way to do this) where a teacher could choose a subject, then a grade, and get a list of the corresponding educational standards for that particular subject and grade. The teacher could then select multiple standards to add to a report. Ideally, I'd like to be able to allow the teachers to select standards from more than one area (not at the same time) and add them to the same report.Basically, I'm trying to find a quick way to create a lesson plan form that allows for multiple standards to be added without having to cut and paste from Word or Excel.All my information is in one looooooong table with columns (fields?) for Subject, Grade, StandardID, and Standard Txt. I think that cascading boxes is what I want to use to accomplish this.Here are my questions:1. Do I need to split my table up to make this work?2. Am I right in thinking cascading boxes are what I should use?3. If so, how do I make each box populate based on the selection made in a previous box?4. Am I insane to think I could do this?Thanks for any help you can give me!Here's a link to the file to download: http://www.box.net/shared/1kc69ts1s5 I couldn't figure out a way to just upload it or attach it (man, I feel kinda stupid right now...).Thanks,Amanda Y

Read other answers
RELEVANCY SCORE 64.8

hello.
i am trying to enter a drop down list validation for a customer's initials

so:
"Mr"Or"Mrs" etc..

but my drop down list is appearing empty
can anyone help?
im not sure im doing it right
thanks much appretiated.
 

A:Solved: access drop down list help

You want to setup data validation or a drop-down list? If you want to limit to list I would do that as well. This only allows them to use one of the list items.

To setup a drop-down or what Access calls a lookup list within a table click in the datatype section of a field and select lookup wizard. Go through the wizard and after you finish click on the lookup tab in the field properties at the bottom of the screen. Set the "Limit to List" property to yes.
 

Read other 3 answers
RELEVANCY SCORE 64.8

Hi,

im trying to filter a listbox based on a textbox value.

I'd like the listbox to filter as soon as anything has been entered into the textbox and to keep filtering as more is added to the text box.

e.g. if i enter "123" it shuold automatically filter the text box and look for values starting with 123

if i keep going.. "1234" it should find data beginning with 1234 etc etc
So far, i have changed the rowsource for the listbox to this...

----------------------------
SELECT tblTool.[Tool ID], tblTool.[Unit #], tblTool.Description
FROM tblTool
WHERE (((tblTool.[Unit #]) Not Like 'SYSTEM DEFAULT')) And (((tblTool.[Unit #]) Like "'" & [Forms]![frm_Def]![filter] & "*'"))
ORDER BY tblTool.[Tool ID];
--------------------------------

and i have changed the On change event of the filter textbox to requery the listbox.
However, nothing shows up. and nothing happens when i enter criteria into the filter text box either.

Any ideas?

Many Thanks
Lewis
 

A:Access 2007 List box Filter

Read other 9 answers
RELEVANCY SCORE 64.8

I have a combo box in a table Lookup with the Row Source Type being Table/Query. Limit to List is set to "No" so the data entry person can add other items not currently in the Table. Can this also update the table from which it is getting the Lookup information? In other words, if the data entry person adds a new item, can we somehow have it add this item to the table?
 

A:Access-Adding to Lookup list

It will automatically add items to the table if the combo box is directly linked to the table and the form is left unbound. This could be a problem if the form is used for updating anything else. You might also have to worry about duplicates in your pulldown list unless the table is set up to not allow dupes....lists will tend to get kind of lenthy also if you allow every data entry person to add to this list.
 

Read other 1 answers