Recent content by hyp527

Hi, I have this module and I'm trying to tweak it so it can add more columns, but everytime I run it, it's giving me error: Run-time error '2147217900: Invalid SQL statement; expected Delete, Insert, Procedure, Select or Update. Did I miss something? Thanks! Public Sub s_runMe() Dim...

Thanks Bob. I ask the same question myself.

I linked the table from an oracle table. In the data type in access it's indicated as a number. Does that mean it needs to be rewritten in Oracle to represent a date? Is there a way to reformat?

I have a set of data that's formatted "20030306" but when I input a parameter on that column such as >=Date()-180, I get an error that reads ODBC - call failed. [Oracle][ODBC]ORA-00932: inconsistent datatypes: expected number got timestamp (#932). What am I doing wrong? I have oracle client...

I want to write an auto calculation date like >=DateAdd("m",-6, Date()) but the dates are divided out in such columns: cc - century - 20 yy - year - 9 mm - month - 2 dd - day - 4 Is there solution to mimic the >=DateAdd("m",-6, Date()) ? Concatination would not work in this case since...

it does exactly what i want to do. thanks bob!

what is >=date()-180? if I want to write 1 year back from today's date of run or 6 months, what's the best way to write this? i don't want to keep rewriting this everytime I do a run that has a date range for a sales column. thanks.

sorry raskew. i didn't mean to sound unappreciative. :( i'm very greatful for everyone's help. I apologize for being so repetitive. I'm very new to access and heard that vba does a better job than building queries. I used the above but I keep running into problems. Any suggestion...

Thank you JANR and MSAccess. Visual aids are so great for beginners like me. :) Is there another way to rewrite this query to produce faster results?

Hi I have a query that I would like to get it converted to a module or vba but doesn't know how. Can someone help me? SELECT VehicleMiles.CarNum, VehicleMiles.DorDate, VehicleMiles.SpeedoEnd, (SELECT SpeedoEnd FROM VehicleMiles AS Alias WHERE DorDate = (SELECT Max(DorDate) FROM VehicleMiles...

I have a similiar audit trail situation, but my data are so large (999,000) that this query is too slow for me to run. I ran this for over 4 hours and only produced about 1 bar even with an append table query. SELECT VehicleMiles.CarNum, VehicleMiles.DorDate, VehicleMiles.SpeedoEnd, (SELECT...

Thanks Mike!

This is exactly what I want to do. I don't see codes in the form. Are there special codes embedded behind the button "Run Routine"? Thanks.

That looks like what I want. But all these coding is like Greek to me. Do you have a visual in the design view? Thanks.

My purpose for doing this is to find all the corresponding R items for the C unique value and put it in a string format. Can you show me steps to do this or codes to do this? What is a good function to use? Thanks.