Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Wanet Telecoms Ltd on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by mgbeye

  1. mgbeye

    Device Manager Equivalent in NT

    I would like to disable a network card in NT. I have disabled the bindings but the access attempts to that card are still causing problems. Is there a Device Manager equivalent in NT for this?
  2. mgbeye

    Retrieving user entered data with getline.

    Ok here it is. I have a simple program set up to prompt for the Employee name, id and pay. I have set up employee as a structure with three parts. My problem is with the get line that reads in the name. It works fine for the first Employee, but stores garbage in the variables and exits the...
  3. mgbeye

    Rounding

    My program figures the payroll details for two employees and then calculates a total. My problem is in rounding. My results are off by a penny. I need to know how to round a variable so that I can use it in an addition statment. Here is my code. /* Lab 03P2.cpp Name: Melissa Beyer Date...
  4. mgbeye

    Excel Vlookup in an if statement

    We have checked this formula several times, but it still will not work. If the statement is true it returns the 0 which is correct. If it is false it returns #N/A. Does anyone know why. (All cell references are correct) =IF(ERROR.TYPE(VLOOKUP(CONCATENATE(A28,&quot...
  5. mgbeye

    Determining Percent Range

    I have a set of numbers that I have determined percent accuracies for. what I would like to do is display in cell next to these percents what range they fit into. (IE: 30-40% or 40-50%) Does anyone know how I can do this without making one huge If-Then statement?? THANKS!
  6. mgbeye

    No current record.

    I believe my loop is trying to execute one too many times, but I am not able to figure out why.
  7. mgbeye

    No current record.

    I am preforming a set of calculations for each record in a table if it fits certain characteristics. For some reason I always get an error message that says "No current record." AFTER it has gone through all of the records. I can't seem to keep it from attempting the calculations that...
  8. mgbeye

    Could someone help with my code

    I'm not sure if I am understanding. I need to do a movenext for the recordset which I have done and then also do one for each field. "me.field.movenext" Is that right?
  9. mgbeye

    Could someone help with my code

    I am trying to basically take a copy of one table and add it to a pre-existing table. For some reason I can not get my loop to work right. It simply goes through and copies the same record for each line. It puts in the right number, but never changes value. I would appreciate input on what might...
  10. mgbeye

    Open recordset

    I am trying to update two tables from the code of a form. When the button is clicked I would like the information to be copied to these tables. Here is the code I have so far. Can anyone make some suggestions as to why I am still getting errors? [code] Option Compare Database Option Explicit...
  11. mgbeye

    DLOOKUP in a report

    I made the change you suggested, but it still displays #ERROR. Is there something special you have to do to be able to use it in a report? Thanks so much for your help.
  12. mgbeye

    DLOOKUP in a report

    I am running a report that pulls its information from a query. Is it possible to do a DLOOKUP in the report to pull information from the query. Here is the syntax I have. =DLookUp("[SUMOFQUANTITY]","REPORT","[OLD MATL] = BOT30026SS") The fields in the query are...
  13. mgbeye

    Repeat Untill

    You just answered my question. I was using repeat until instead of do until. Thanks! :)
  14. mgbeye

    Repeat Untill

    Does anyone know the proper syntax for a repeat untill loop? I am having trouble getting mine to work. THANKS! :)
  15. mgbeye

    Syntax to open a record set

    I am using a form that will be pulling from several different tables and a query. I am pretty sure I need to do open recordsets for them. I was wondering if anyone could give me a little help on how exactly to code this. THANKS!

Part and Inventory Search

Back
Top