Search results

Yeah I agree....I don't know why they did it that way.....I know I could change it on my end without changing the format at the source but having had time to do that yet.... When I get some downtime (yeah right) I planned on making thing easier for myself (new job,thrown in the deep in...

Well the date is goofy....instead of 07/31/17 it is 20170731....I was trying to compensate for that oh...btw it is a short text field...

Hey Guys, I have a query the takes the current month and filters the criteria to give me the last day of that month and the last day of that same month one year ago. So it looks like (for instance) give me everything Between 20170731 and 20180731 So it looks like this in the query criteria...

Yep, I agree....however I am not allowed to changed the data type coming from the companies mainframe..... I don't understand why they did that?? But your talking about a mainframe system that was created........yeeeeeearrss ago...lol gotta work with what I got...lol...:rolleyes:

Bro, you are awesome!! that worked great!:D

Good point! the field type is originally number...and it is formatted like "20070325" as a date...I don't know why they did it that way... So that is most like what is causing the trouble...so I am looking possibly doing a date format for "yyyy","mm","dd"...

Here is the error I am getting..

Sorry, that was a typo.....The extra> was not in the query....I did that when I have typing the question.... Any Ideas?

Hello All, Trying to use some criteria in a query that is giving me a error. When I put this in the query >DateAdd("yyyy",-1,Date()) I get an error.....what I am trying to get is: "One year ago today" for the criteria..... So whenever the query runs, the criteria will be that day a year...

Thanks alot guys....nice to awesome people willing to help!!

Hello All, I am trying to put the date in the file name. I am outputting a table to an excel file and trying to put the date before the file name. What i was working with so far......sorry relatively new to this Function testthisone() Dim FilTim As String Dim FilNam As String Dim OutNam As...

I got it to work.... did not check the reference.....it works now

Yeah, it says User Defined Not Defined here: Dim outl As outlook.Application Tried yours...did not work...says something about wrong number of arguments...

Hello All, Trying to figure out why this code is not working. Function SendMail() Dim outl As outlook.Application Set outl = New outlook.Application Dim mi As outlook.MailItem Set mi = outl.CreateItem(olMailItem) mi.body = "Hello, blah blah blah" mi.Subject = "CV_blah" mi.To = "blah@blah.com"...

Thanks for that....I did look that over...def a keeper...just finding out out which one has been difficult... Does anyone have an example of a working connection string? I am using these drivers: DataDirect Shadow Client 7.3 DataDirect 5.3 Oracle Wire Protocol Just not sure on format and...

Hello All, I have multiple table linked via ODBC connection. This includes a connected oracle db. I have a code that is running some queries and then send it to excel. However during the code it is asking for user name and password. I input the details and it continues. I am trying to have...

This query is getting a error about missing syntax...I will try to see why

Thanks! I am actually getting a error....so I did a HEX(VAL((MID(EXTRA_IN,1,3)) AS FKT_AMG1 because I am thinking its trying to return a numeric value....and I just get a 0 What do you think?

Hey guys, I and trying to convert some mainframe query to Access. I am working with: HEX(SUBSTR(EXTRA_IN,1,3)) AS FKT_AMG1 Obviously, Access does not have a substr function...so I tried to use Left or Right....I got some results with Mid but some time I got nothing.... I tried...

Wow...this worked great!!!! It took a while to run because there was alot of data. This is a keeper template for sure...At least for me! Your awesome chief!! Thanks again!!