Recent content by Crilen007

Glad I'm not the only one with this. Although eventually I find they both stop working correctly. I don't know why Microsoft did this.

Thanks I used the asc value between and that worked great.

Yea, I know how to convert them to lower case, but what I'm trying to do is detect the upper case ones to filter them out.

I have a list of emails that was taken from a database. We sent out a mailout to all of the emails and all the ones that were capitals got rejected. What I need is to detect which ones are capitals, and separate those so I can change the case and resend. Is there a way to detect if the last...

Well I guess I can use SQL instead of the Query Name, I love VBA sometimes lol

Well... What I'm trying to do is calculate the time difference between records in a table using VBA and cycling records. So I was hoping to select the records using SQL so I can choose what day and person it should be etc... It's been a while since I've had to use access lol, I would normally...

Hmm... There a way to select a record set using an SQL statement instead of the query name?

Whats the new proper way to do recordsets in VBA for Access 2007? Any examples would be great, thanks.

I'm trying to get access to send Queries to MySQL in the new ACcess 2007 (which is different than the other ones once again, yay) I used the direct ODBC connect method in previous versions of access but this one tells me it wont support it. How can I get access to send the password function...

Can someone post a sample database of this working? I guess I don't have the correct references or something.

Ah, very cool. Gives me a great place to start. If I could have the excel sheet open, and run an update query that had Access fill in the values. I could have access create the query with proper filters, then have acces make a copy of the template, save it with a proper name, then make it do a...

Wow... it's going to get nasty isn't it... heh Wonder if there are any examples anywhere. Any keywords you could suggest for finding an example DB that creates excel sheets that are more complicated than a simple export?

Ok.. I firstly just need to know if this is possible.. and if so.. if anyone has any example programs on how this can be done. I have to create a large number of excel sheets with data from tables. I need to have formatting (Image at the top, certain lines have to be highlighted.. etc)...

That fixed it for the table view, but not for the report =(

I'm sorting Decending. I'll check the above article.