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

Search results for query: *

  • Users: VBAguy22
  • Order by date
  1. VBAguy22

    Creating a RUNNING PRODUCT query

    To Clearify: The running product has to be on the FACTOR field.
  2. VBAguy22

    Creating a RUNNING PRODUCT query

    Hi all, I have a table, myTable, sorted properly by PROVINCE, POSTALCODE and AREACODE. The last field in the table is FACTOR field. I need to create a query that will create a running product based on area code. Note that the count has to restart each time we have a new area code. Any help? Thanks!
  3. VBAguy22

    Changing a query SQL programatically

    Hello, I have a query, say [myQuery]. And I composed an SQL string myString. Is there a function to change the sql code in myQuery to myString from whatever it is now programatically. I am aware of CurrentDb.CreateQueryDef(), but this function creates a new query, I just need to change the sql.
  4. VBAguy22

    Referring to previous record in my query

    Hi All, How would I refer to the element in my field on the previous record? Say I want to multiply the value of field [factor] by the value of the field [factor] in the previous record?
  5. VBAguy22

    Crosstab query with multiple column heandings?

    Hi I have a table of this kind: ID | Hair | Eyes | Shoe Size | Factor ------------------------------------------ 1 | Blnd | Blue | 11 | 1.2 2 | Black | Green | 9 | 1.9 3 | Brown | Hazel | 10 | 2.1 etc What I want to do is have a crosstab query, that will...
  6. VBAguy22

    Removing all spaces from a field in query

    Hi, I have a table that has a field that contains spaces. I would like to remove all spaces from that field. Is there a built in function in Access to do that in a query? Eg: I have: "this is an example" I want: "thisisanexample" Thanks!
  7. VBAguy22

    MOD (get remainder) in Access query?

    Hi Is there a function I can use to find the numeric remainder of a division? Something that corresponds to mod() in java. Say I divide 11 by 3: I want to get 2 11 - 9 = 2
  8. VBAguy22

    Query populates with N/A's or doesn't respond

    Hi I have a select query that's using an oracle linked table and joins it to another query by memberId. When I try to sort the results, the query freezes or populates with N/A's. I have to do it in two steps for some reason. Does anybody know why? The tables are rather small (couple of...
  9. VBAguy22

    Query to change table layout from columns to rows

    too big for excel
  10. VBAguy22

    Query to change table layout from columns to rows

    Hi, I have a table with cashflows that go for 100 years across (I know Excel layouts are not fun). I imported it into Access. I have the following fields: StartYr,Y1,Y2....Y100 In the Y1, Y2.. columns we have amounts that the cashflow takes, interest rate varies a lot so I can't re-calculate...
  11. VBAguy22

    ListBox keeps shrinking every time I re-open my workbook

    Hi I have a listbox in one of my sheets, it keeps shrinking every time I reopen my workbook and I have to expand it manually. It's VB code generated (every time I load the workbook the values are being sent into the listbox). Any ideas how I can lock the size? I know how to do it in Access but...
  12. VBAguy22

    Getting the source for a listbox in Excel

    Nope. I think it's reading from somewhere in the Workbook but I got about 200 sheets in it
  13. VBAguy22

    Getting the source for a listbox in Excel

    Hi, I inherrited someone's spreadsheet with a listbox in it. How would I check where the listbox is reading from? I tried to do Design->Properties but no luck there, also tried to look in Format Controls and still nothing. THNX!
  14. VBAguy22

    LEFT() gives me a compile error?

    You guys are right. Error in VB caused that formula not to work.
  15. VBAguy22

    LEFT() gives me a compile error?

    I have the latest ADO and DAO included. I thought Left() was a pretty basic experession in Build?
  16. VBAguy22

    LEFT() gives me a compile error?

    I am writing that in my query, hence references don't matter. I am running Access 2000, and I tried taking a Left of a "string" and still didn't work.
  17. VBAguy22

    LEFT() gives me a compile error?

    Access query I checked the data, it's all fine. Weird eh?
  18. VBAguy22

    LEFT() gives me a compile error?

    Hi This is driving me nuts I am picking up first letter of the clients last name field: FL: Left(LAST_NAME,1) Why do I get a compile error on this line? I've written 100000 Left queries before. SO frustrating.
  19. VBAguy22

    Creating a query from VB code?

    Hi I have a VB string myString that contains some SQL code. How do I create a query based on that code? 1000 THNX
  20. VBAguy22

    Using quotation " in string

    Hi, How would I use quotations inside a strng? Wouldn't it end the string? THNX

Part and Inventory Search

Back
Top