Recent content by jkpats12

Not sure either.....the same issue happens when using Crystal, but I am able to convert the AM/PM to what I need by using Char("MYField")in Crystal.....just can't seem to convert it in MS Access ????

Thanks to you as well Stopher.......looks like I'm almost there, only issue is the milliseconds, you guys have any ideas on that ? I know the millisecond info is there somewhere as I described earlier it converts it into the AM/PM fromat when I link through the SQL pas-through query, so I need...

Thanks LagBolt....I'll give that a shot & let you know; also those are the milliseconds that you asked.

Hello, I was wondering if anyone knew of some code to convert a time such as 10/22/1992 3:00:02 PM to 1992-10-22 15:00:02.300003. My issue is that a ODBC connection I am using allows me to connect to some tables & not to others, the ones I can't connect to I created a SQL pass-through query...

Thank you rolaaus........I'm familiar with what you reference. I was just hoping to send the report that is contained within Access due to roughly 100 e-mail's that will be sent & the report is dynamic to each e-mail since it is based off of a dynamic query. Thanks again for the help.

Below is the code I'm currently using, everything is working fine; however the .Attachments.Add code is where I would like to just place a report created within the Access db rather then sending it out to a location to pick it up from. Any help would be appreciated. Thanks Option Compare...

Hello, I have some code put together with help through this site which allows me to send e-mail's out as high importance, voting options, flags..etc. My issue is I would like to send a report that is built in the current database instead of attaching a report from a network share ? The process...

Not sure if anyone else was looking for info on this but I found something on the Microsoft website that did the trick. Thanks http://support.microsoft.com/default.aspx?scid=kb;EN-GB;q171146

Hello, I was wondering if it is possible by using some code to set up an Oracle connection through MS Access if a client does not have this connection set up on their desktop ? I'm basically looking to create a button the client can press which would establish the connection for them in the...

Hi everyone, Is there anyway to possibly put together some e-mail code that will attach a file from a specific folder but the file name is constantly changing ? Basically I went to attach this file & send it out via e-mail, but with the file name constantly changing I'm unsure on how to...

All set Bob.....came up with this: Private Sub DSN_Check_Click() On Error GoTo Err_DSN_Check_Click DoCmd.OpenQuery "Query1", acViewNormal Exit_DSN_Check_Click: Exit Sub Err_DSN_Check_Click: MsgBox "Your Message Here.", vbOKOnly, "WARNING" Resume Exit_DSN_Check_Click End Sub Thanks again

I'll give that a shot & keep you posted.....again thanks for your time & help !!

Thanks Bob, but I don't think I can get them to change their ways unfortunately. I was hoping when the users access the database to just let them know via message box they need to contact the group for the install, I would prefer that rather than the ODBC connection fail message popping up...

Hi everyone, I was wondering if there was a way through code to verify if a DSN connection is set up on a user's system, and if it is not create a message box pop up letting them know they need to contact the tech group for the install ? I've seen code within this site to set up the DSN...

Thanks Rich, not familiar with For I loop ??? Any guidance would be appreciated. Thanks