Search results for query: *

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!

I think I solved it... There was some code in the original SQL statement I didn't want and forgot to kill. I am 99.9% sure it works now. Thanks! If not, I will be back to beg :)

The chidl/Master relationship thing worked like a charm to fill the boxes I needed filled. However, I still have a boggle. I guess I didn't make it clear, but what I had hoped to do was use the criteria in those four boxes to return a record from a table and put it into attempt2. I tried...

If it helps matters at all, this is the VBA/SQL code I was trying to use. Private Sub Form_Load() Dim strSQL As String strSQL = "SELECT tblSigned.[School Year Start], tblSigned.[School Year End], tblSigned.CertNumber, tblSigned.CertType, tblSigned.Reason " & _ "FROM tblSigned " & _ "WHERE...

Nope, martial arts instructor actually (Well, and budget examiner) Mind running me through setting it up correctly?

Hi all, I have a form and a subform, let us call the form attempt1 and the subform attempt2 (Witty, huh?). Attempt1 is run off a query that allows the user to just type a Unique ID code and pulls up a record that is displayed in the form. This works wonderfully, and upon finishing it, I...