Search results for query: *

I have a Cisco Catalyst 2960-S switch. I didn't set it up and I am a newbie trying to learn. I have a workstation connected to gi1/0/4. If I try to connect to any other port I cannot get a connection to the server on another switch. I did a show interface status and gi1/0/3 is connected and...

When I execute this code it takes about a 30 seconds to execute. The first part of the code goes through about 1500 records looking to see if NSN and command match. Is there a better way to do a two factor search or filter? Private Sub ChangeNSN_Click() Dim selectedCommand As String Dim...

When I run this code I would expect each field to be assigned the value 1. Instead, the first record's VOC-lbs is assigned 1. The second record is assigned 2. The third record is assigned 3 and so on. I have tried batch update and regular update. How do I fix this? Thanks in advance. Dim...

I have Access 2007 and I am making labels for the Relay for Life. I go to the create tab and choose labels. I follow the prompts and the report comes out like it is supposed to with to columns and the correct number of rows. If I go into design view and change anything I only have one column...

Hi This code works fine when the query produces data. When the query produces no data I get, "No orders for this date.", "Microsoft Office Access has encountered a problem and needs to close". Then I get dumped out of Access. I have seen error 2501 traps, but I don't seem to be getting an...

I am not sure what I am doing wrong. I am trying to get data from a few different queries and post the results to one report. I can't get past the first statement: "Dim rst As ADODB.Recordset". I get compile error: "User-defined type not defined" I appreciate any advice. Private Sub...

Hi everyone, I hope someone can help. My company has asked for a web link to my MDE file. I made the link using the UNC for the Network address (\\Server1\Link\Myprog.mde). When I click on the link I get the choice to open or save. I choose open. Then a security warning that asked if I still...

I would like to sell some of my Access programs. I have a trouble ticket program similar to Helpstar. I also have a program that tracks training classes of employees. Where would be the best place to sell them or promote them as shareware? Would making them into mde files be the best way to...

Hi All, I am stuck on this one. If this were Access I would have no problems. I divided this into three pages. First page takes the information the date of the meals and the filter. Second page has the following code. The idea is to choose the radio button of the meal choice for each...

Hi Everyone, I am stuck on this (what should be easy) task. I am retrieving "MealCard" from a calling forms page. Then I want to match to check for duplicates by comparing what was entered on the form with what is in the data base. The nearest I can tell is that the data types might be...

Hi everyone. Having some problems with this form. There should be a Javascript solution, but I can't find the answer: I want a form that prompts the user for a specific date if they choose a certain option(Meals on a specific date) from a drop down list. This is what I have so far. <form...

Hi everyone, I hope I can explain this correctly: I created an animated gif. When I first post the gif, it functions the way it should(without the glitch). After a while a frame gets added of a black box: http://www.lemoore.navy.mil/test/flagglitch.jpg I don't know what event causes the...

I created a layers page using the instruction from this site: http://www.webmonkey.com/webmonkey/06/09/index3a.html. Basically I am using layers to create animation on my site. Here is a practice site I made: http://www.lemoore.navy.mil/test2.htm If I have "Every visit to the page" checked in...

I have a report with a signer's name at the bottom of the report. The signer changes about every 6 to 9 months. When the report is printed only the current signer should be listed on the report. My first idea is to set a Public variable equal to the signers name: Public Global_Signer1 As...

I have a database that has employees' first names and last names, but no SSN or employee number. My problem is the prevention of duplicates. I would like to prompt the data entry clerk if the clerk tries to enter any person who is already in the data base. For example: You type in Johnson for...

I am getting &quot;Error Accessing file. Network Connection May Have Been Lost.&quot; I found this answer from Microsoft: http://support.microsoft.com/default.aspx?scid=kb;en-us;304548 I have VBE6.DLL version 6.3.91.8. I have Windows 2000. To find the version I right clicked on the file and...

I was wondering if someone could help me out on this. I have searched all day and can't find an answer. I have one delete.asp file that pulls from a data base and allows me to select a record to be deleted. Here is the code: <% Dim Conn, Rs, sql Set Conn =...

I am posting data from a form. I want to check if the data is valid and make a choice on the result. After I make the choice and go through the error checking, the variable &quot;yesno&quot; is null. This is the code that checks the value yesno: if (frm.yesno.value == &quot;Yes&quot;){...

I am using the following code and the frm.fld.value gives an execution error: frm.fld has no properties. I know the variable &quot;fld&quot; gets passed correctly, but I can't put the value of fld in the frm.fld.value line. Is there anyway to make the fld value take the place of the variable...

I made some code that works great on a single form, but doesn't work on the subform. The code checks to see if the current record is new. Private Sub Form_Current() Dim intnewrec As Integer intnewrec = Forms(&quot;Training&quot;).NewRecord If intnewrec = True Then Course_not_selected...