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...

Andrzejek, thank you for your reply. For some reason the filter option didn't work no matter what I did. Here is the revised code. The findfirst method seemed to do great. Private Sub ChangeNSN_Click() Dim selectedCommand, strSQL, strSQL1 As String Dim NSN As String, NOMENCLATURE As...

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...

Thanks, it appears I was keeping track of a running sum in my report. The code was updating the table, but the report was showing my a running sum. Thanks for checking that out for me.

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 was looking in report view not print preview. That was easy. Thanks, Al

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...

If I take the Cancel = True out it works fine and opens a blank report. Why does the NoData subroutine declare "Cancel As Integer"?

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...

The link helped. I ended up loading a different version of Microsoft Active X. Thanks, Al

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...

Thank you for replying. Maybe it is easy, but I am stuck. I know how to retrieve one field request("Mvalue1") or if I knew how many I would retrieve request("Mvalue1") request("Mvalue2") request("Mvalue3") request("Mvalue4") How would I retrieve an indeterminate amount of fields? Is there an...

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...

Thanks, that did it :)

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...

Thanks, that works great!

Sorry, I will take either solution.

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...