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 Mike Lewis 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: *

  • Users: lieip
  • Order by date
  1. lieip

    >> ?

    I'm trying to to translate a C hash function into VBA. But I'm a bit rusty on my C. What does << >> means? I thought it was only used in cin and cout. Here: h += (h<<10); What does this << mean and how would I convert that to VBA? TIA
    • lieip
    • Thread
    • Replies: 2
    • Forum: C
  2. lieip

    Export without hard returns in for line wraps

    I'm having a similiar problem too with the return carriage before each line wrp.. Anyone has a solution to this?
  3. lieip

    Taking a sum of three fields

    the query is this: SELECT [BurdenDollars]+[GandA]+[Profit] AS Total FROM (qryBurdenDollars INNER JOIN qryGandA ON (qryBurdenDollars.LaborID = qryGandA.LaborID) AND (qryBurdenDollars.TypeOfChange = qryGandA.TypeOfChange) AND (qryBurdenDollars.DeptName = qryGandA.DeptName)) INNER JOIN qryProfit ON...
  4. lieip

    runn a macro automatically when accessing a query?

    I'm using the web as an interface... I'm coding the interface using vbscript/javascript.. is there a simular cnd that does the Do.Cmd in vbscript or javascript or any kind of language that i can use to program within an ASP page?
  5. lieip

    Taking a sum of three fields

    I'm trying to take a sum of three fields from three different queries but when i run it it gives me an error stating that the query is too complex...what can i do? I tried converting the 3 queries to a make table query and use the 3 fields from the the table that it produces and it works... the...
  6. lieip

    Running a macro automatically when accessing a predefined query?

    Can I use VBScript to run a macro? i know that you can run a macro when you create a button on a form... but if i was to create a button using vbscript or javascript can I program the button to run the macro?
  7. lieip

    runn a macro automatically when accessing a query?

    How do I call run a macro as soon as I access a query? I'm creating a database in access and also creating a web interface... now my problem is that i need to run a macro when i access a query that i've already defined in the Access database.. how can i do that without having to create a button...
  8. lieip

    Running a macro automatically when accessing a predefined query?

    How do I call run a macro as soon as I access a query? I'm creating a database in access and also creating a web interface... now my problem is that i need to run a macro when i access a query that i've already defined in the Access database.. how can i do that without having to create a button...
  9. lieip

    creating a query using 3 other queries

    This is the SQL statement from microsoft access in the sql view: SELECT qryBurdenDollars.DeptName, qryBurdenDollars.TypeOfChange, qryBurdenDollars.LaborID, [profit]+[ganda]+[burdenDollars] AS totalLabor FROM qryProfit, qryBurdenDollars INNER JOIN qryGandA ON (qryBurdenDollars.LaborID =...
  10. lieip

    creating a query using 3 other queries

    I'm trying to create a query that gets the sum of 3 fields and these 3 fields are from 3 other queries.. but when i do that i get an error stating that the query is too complex... how can i fix this problem?
  11. lieip

    creating a query for the Sum of 3 fields from 3 different queries

    I get an error message query is too complex when i try to create a query that adds 3 fields from three other queries. What can i do to fix this error?
  12. lieip

    Run an Access macro through the web

    I have an Access database and I'm creating a web application using ASP. I need to access a macro that i created. How would I run an Access macro using ASP? any help would be much appreciated

Part and Inventory Search

Back
Top