Search results

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

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

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

When i sort values, for some reason the negatives are at the top, followed by the highest positive values. Anyway to turn this off? Tried google and searching these forums.

I replied to a post about this already, but it was in the wrong section. As you see in the screenshot, I'm having a weird problem. I have tried re-installing Access but it didn't help. Any ideas?

This is for anyone who has made a form with a lot of check boxes and wants to make a report out of them thats decent. Hopefully this simple example file is enough to assist people. Keywords: Checkbox Checkboxes report check boxes box

Any idea how I can display this information a lot neater? Its a bunch of check boxes (I wasn't sure how to go about doing this without them, as they can choose multiple things, if it was just 1, I would have used a dropdown). I've been trying to fiddle with this for a while now with no good...

Hey, its been a while since I've posted here, wow. I had a database that contained samples on different date functions (first of the month, last of the month, first weekday, etc...) I can not find it, I have tried searching. I am pretty sure I got it from here. Does anyone know where this is?

Tried to search for this, maybe I am searching the wrong term. Anyways.. I have a table linked from a large mainframe, and what I am trying to do is trim any numbers that are 1 million and over, and still keep it a number. Currently I have this: VEHICLE_KMS2...

Ok, I have kind of a confusing thing. Every employee has an ID, and a start date. Some employees have pictures (stored in a folder). When someone is terminated, the picture does not get erased (as it shoud). So, I need to run a query that deletes any pictures older than the start date of the...

Hey, I tried searching for this one, but I'm not really sure what to search for. I am running a report that is double sided. However, I do not want the start of the next group, on the same physical page. I also do not want a starting blank page (as I thought about inserting a blank page after...

Creating a query with VBA Code I am trying to have my program, check for a query, if its there, erase it, and make a new one based on an SQL string. I tried searching for this (tried "vba create query" and "create query with code") nothing came up related to my problem. So here I am...

Created a Door Reg Database, basically people come in the door, give their account number and guest names, badges get printed. Simple right? Well, when all the data is in, for the accounts and everything, when I add one customer, it works. WHen I add another, it tells me that someone else is...

Not sure what this is called. What I would like.. is a function that works in all my programs. So as soon as I create a new DB, the function is usable in that DB. Is this possible? Also, if I send the DB to someone, will it be transferable with the DB? the functions would also be used in...

Tried a search on this, google and the boards. Perhaps there is a different name.. Anyways. I have this variable in a DB I took over, and it is causing annoying things to happen. I'm not sure what this variable is for. So I was wondering if there is a way to monitor what is happening to the...

I know the basics, I have created a sample database, but I have a question.. I took over this place, and the databases that were created do not follow proper database structure. There is redundant data everywhere.. its pathetic. Now, the main database, that is used daily is a database of...

I have a form where users enter things. I want to allow ONLY Capital letters and numbers. Anyone have any ideas? the fields are never more than 3 characters long. Usually formated as such: 69k 79g 110 345 etc... Any ideas? Oh, and it has to be like this in the table, not just appear this...

Post screenshots of your report layouts. Preferably false data if needed, try to avoid blur outs, as it ruins the look of the report. I'll start.

How would I get the second tab to work in this? Just curious what the best way would be? That is, getting the date selectors to work. There is no data in this database yet.