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 Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. RENENGER

    Call Function within Query

    Ok. It looks like I got it to work. However, if the query runs that actually contains the CASE statements in the Function (Pre-Fin is BR28 or DrStyle = DCREAG) then I get an error that the expression is typed incorrectly, or it is too comple to be evaluated. I had to change the Function around a...
  2. RENENGER

    Call Function within Query

    What am I doing incorrectly? I am still learning this VB stuff.
  3. RENENGER

    Call Function within Query

    I am trying to calculate a Work Order Start Date in a query. This is based on some characteristics of the order and it skips weekends. However, when I run this query, the date shows as 12:00 am. What am I missing? Function CreateWOSDDate(ByVal PreFin As String, ByVal DrStyle As String, ByVal...
  4. RENENGER

    Update Query

    Ok. I am an idiot I got this to work. My main table update query will update or add to what I already have. My problem now is with the details table. If I have two rows for one unit, it will only input one of them. For example, I add the following to the .csv file: 80506 ANTHONY 19 72 , ...
  5. RENENGER

    Update Query

    I am importing a .csv file into tblCSVImport. From there I am running a Make-Table query that copies all of that information into a tmptable with the correct field names. I am running another Make-Table query that groups that same information that will be the Main Table with the header...
  6. RENENGER

    WINDOWS 2000

    As far as I know, the printers are setup by computer name. For example Printer04 is setup on BSmith. We only have to keep the computer name the same as far as the printer is concerned. The user is in the emulator, chooses the print program they want to run and then tell it what printer to use...
  7. RENENGER

    WINDOWS 2000

    OUR SETUP WAS A WINDOWS NT DOMAIN AND A UNIX SERVER. OUR UNIX SERVER IS ACCESSED THROUGH TERMINAL EMULATORS. WE HAVE UNIX PRINTERS ASSIGNED TO SPECIFIC WIN 98 MACHINES. LAST WEEK, WE INSTALLED A NEW WINDOWS 2000 SERVER AND CHANGED THE DOMAIN NAME. NOW WE CANNOT PRINT OUT OF UNIX. WE ARE NOT...

Part and Inventory Search

Back
Top