Recent content by VBAguy22

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

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!

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.

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?

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

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!

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

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

too big for excel

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

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

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

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!

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

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