Recent content by apryor

Worked like a charm!!!! Thanks for your help!!!! :D

Hi, I have a query that displays a list of e-mail addresses based on criteria from a table, but when I try to reverse the criteria in another query (to see what does not match) it displays all of my records. Thanks in advance for your help. :D VALID EMAIL ADD QRY (This one Works) SELECT...

I pasted that into the SQL and I'm getting the following error. Did I put it in the wrong place? Error: You have written a subquery that can return more than one field without using the EXISTS reserved word in the main query's FROM clause. Revise the SELECT statement of the subquery to request...

Here's a copy of the db.

The list of domain names I'm using actually includes several dozen items (.ca, .gov, .edu, .net, .co, .jp, etc). Is there a way to do the comparrison based on these items if they are listed in a table? What I'm trying to do, is verify that the e-mail addresses that are imported are valid (based...

Sounds like a good idea, but how should I structure the query if I'm only comparing partial info? For example: I have several e-mail addresses that are imported into the staging ground, and I only want the addresses that end in .net or .edu (which would be listed in the DOMAIN_TBL) to be...

Hi, I'm not sure if this is possible, but I've heard you guys really know your stuff. I have a client who would like to import a list of e-mail addresses, but would like to verify the domain name used in the provided address against a list of domain names pre-populated in a table. Do I need to...

Hey everyone, I tried doing a search for this, but had no luck. When I export a report to MS Word, Word cuts off some of my data on the due to a problem with the margins. I've checked the margins under "page setup" in Access as well as in Word, but for whatever reason, Word won't use the new...

Problem solved. Thanks anyway.

Hi, I just recently split my Access db (FE/BE), copied the FE to each of the clients, and it seemed to be working fine. This morning however, two users went into the db, and the second user kept getting the error can't find the file \\servername\share_name\db_fe.mdb. Now, none of my users can...

That makes sense to me. Although in my case, I can't imagine that 750 controls were added to this form since its recent creation, but I did delete and re-add things a few times.

Think I found a way around it. I copied the form and pasted it with a new name, deleted the original, then renamed the copied version with the previous name. After opening this form in Design view, I was able to add a new control. Thanks for you help.

Tried that, but no luck. Can I go in and manually change something?

I'm not even close to 750. Is there a way to fix this? Reset a counter, etc?

I have a form in my Access database that after trying to add another field to it today, I get the error "Microsoft Access can't create any more controls on this form or report." I'm guessing I reached some type of limit that I was not aware of. How can I get around this?