Recent content by MisterMan

And of course, I miss the obvious. Thanks!

Only problem with this is that I would have to delete myquery each time, no?

The query works fine, and I decided to do a simpler version which merely pulls all the data from the table listed. I click the button now, and nothing happens...

Yes indeed it does.

Hey all, I am sorry for bothering everyone with this, as I feel it should be easy, but it is just not working. I have an imbedded SQl query in VBA on the Onclick property of a button; If IsNull(Me.Combo9) = True Or Me.Combo9 = "" Then MsgBox "Please select from the list!", vbOKOnly...

Printed the document out and mentioned it, but you know how it can be. Thanks again!

Not so much in the way I want to have it this way, but it's the way the people who sign my pay checks want it. Thanks!

I am writing an SQL query in Access to select information from one of a number of different tables. What I would like to do is have the query run and ask the user to input the month/year of the table (Which is the name of the tables stored) For example, run the query and a box pops up saying...

Hello, I have three tables: Table1 has personal information. 1st name, Middle initial, Last Name and ID# (PK) Table2 has phone information. #, Phone type, Time to Call and ID# (PK) Table3 is a simple table with Phone Type and Call Type (Short or long). Table3 exists so that I can have the...

Actually, I do believe I had it figured out. Once I made the FK not the PK in the DETable, it worked fine. Thank you everyone!

Of course, I just misunderstood your wording, sorry. They are joined. I've never seen a query do this before. (I was sitting here going "What's a Not Join?")

Not join?

I am just full of annoying questions today. I have a query that allows Data Entry into a table, but pulls some info from another table. For simplicity's sake, let us call one DETable and the other INFTable. The query draws the PK from INFTable, plus 5 other fields. The query also draws all...

THANK YOU!

Despite my best efforts, apparently my primary key has been corrupted somehow and has duplicate values. There are roughly 6500 different records in this database. Is there any way to find the duplicates without going through line by line? Thank you!