Search results

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

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

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

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?

Hi, Due to the amount of information I need to squeeze into this report, I'm trying to create a 3 page report. The problem I have is that while in design view, the bottom portion of the page will only stretch to 22 inches. Is this the max limit? In print view, I can see a full length 3rd page...

This is so weird. I have a form that I built and is based on a relationship between four different tables. I can enter info into the form, save it, and verify that it saved to each of these tables. The problem is that once I close the form and re-open it, none of the previously entered info...

Currently, I have a button on my form that users can click on to generate a report based on the info from the form. Once the report has opened, they publish the form with MS Word for further edit if needed. How do I set up the button so that it opens the report then automatically publishes the...

Can't seem to figure this out. I built a db for tracking and entering sales info but I'm having a problem with one of my combo boxes. To make entering data easier, I created a combo box that you can select a sales persons name from, then based on who is selected, their Title and Office location...

I currently have a few tables that use an autonumber as the primary key, however, I would like the autonumber to start with a series of letters if possible. For example: instead of it creating an ID of 1, then, 2, 3, 4, and so on, I would like it to append lets say "ABC" to the front of it...

I'm sure this is an easy one, but I just can't put my finger on it. I have a Table that logs Qty, Desc, Size, Price, and a check box. How do I get my report to return only the items with a check in the checkbox?

I've built the following tables (see below) with the indicated relationships. The problem occurs when I try to create a Form for data entry. The Form either shows up blank in Form View, or it won't allow me to input data into it. The data types for the primary key and related tbl match. The...

I'm not sure why this happens, but hopefully someone out there does. Every now and then, after I create a form which I plan on using for data entry, I switch to Form View and all I see is a blank page. Then, if I remove the fields in desgn view, then switch back to Form View, the text and lines...