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!

Register Log in
  • Congratulations MikeeOK 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. miketheitguy

    Function undefined

    Any ideas as to why access is giving me the error that this function is undefined? It's entered as you see below and is compiled without errors. ---------------------BEGIN CODE Option Explicit Function Getwkdate() Dim currentdate As String currentdate = Getwkdate Select Case currentdate...
  2. miketheitguy

    Update the value of a Select AS field in a query

    Ok guys, I'm writing a query to bring together a number of different fields and values and append them all to a single table. My query looks like this. TableA TableB TableC TableD Field1 Field1 Field1 Field1 Field2 Field3 Insert Into TableE (Cuid...
  3. miketheitguy

    Top or Max function question...

    Ok guys here's the deal.. I'm designing an inventory transfer module. In one table are the goods to be transferred. In the other table is the list of goods sorted by inventory qty, bin and warehouse. So table A: Item# Desc Qty DP01090 Tortilla 10 DP01011 Corn Chip 23...
  4. miketheitguy

    How to port over an Access/SQL update query for VFP8

    Hey Gang, I'm not writing some huge database here, not even really writing a good ammount of code in Foxpro, just have an issue that's hanging me up and I hope to get the down and dirty about it. Here's the scenario. I work for a company that uses a pretty standard MS-SQL accounting...

Part and Inventory Search

Back
Top