Search results

pbaldy,, OK, got it . . . I have my fishing rod. Any takers ?

Arnelgp, I did changed 'anotherTable' to another table name.

Arnelgp, Did not work, I added 'From Administration', but it did fix the problem. INSERT INTO anotherTable ( [Name], [Survey_Taker_Telephone_Number], [Type], [Type_Score], [Contact_Me] ) (SELECT Leadership.Name, Leadership.Survey_Taker_Telephone_Number, Leadership.Type, Leadership.Type_Score...

NauticalGent, What happened . . .

pbaldy, Fish ?

How can I insert the below "Select" queries results (that works) in to one (1) table. SELECT Leadership.Name, Leadership.Survey_Taker_Telephone_Number, Leadership.Type, Leadership.Type_Score, Leadership.Contact_Me FROM Leadership Union SELECT Administration.Name...

What I'm doing is using a form for a survey. After the user answers the last question on the form (survey), press a button, his/her record is saved to a table that has all records (individual's responses). I want to capture the firstname, middlename, and lastname on the form and pass it to a...

OK,I found out that I can get the information in VBA. I guest I have to somehow (through VBA and SQL) insert the form information into a table via SQL query in VBA (via DoCmd command). Do you think this is the solution. I originally wanted to pass the firstname, middilename, and lastname into...

The only way a record shows in the query is when I advance to the next record (new record), then back to the previous record on the form. Is this the way that it suppose to work ? I wanted to retrieve the current record on the form without saving (i.e. advancing to the next record).

I created a new database ("Database3") and the same thing happens. See attachment.:banghead:

1. The data is in the form that I'm trying to retrieve 2. No error codes returned 3. The form, table, query, or report does not appear to be corrupted. How can I tell ?

Yes, I can retrieve all records from the table without the filter. Here is the SQL code: SELECT Spiritual_Gift_Totals.Survey_Taker_First_Name, Spiritual_Gift_Totals.Survey_Taker_Middle_Name, Spiritual_Gift_Totals.Survey_Taker_Last_Name, Spiritual_Gift_Totals.Leadership...

I thought I gave everything that is needed in my opening request. I'm using a query to retrieve a data field in a form. This query criteria is [Forms]![Questions]![Last_Name]. I also tried CStr([Forms]![Questions]![Last_Name]). The field definition in the table is "Short Text". The form is open...

That is, the current record on the form.

Thanks . . . No record(s) are displayed.

I would appreciate it if someone could tell me where to look for the resolution of this problem.

Any hints on resolving this failure ?

Can somone tell me what is wrong with my attempt to retrieve of a value (Last_Name) from an open form (Questions) to a query ? Form name is Questions Form field name is Last_Name This query criteria is [Forms]![Questions]![Last_Name]. I also tried CStr([Forms]![Questions]![Last_Name]). The...

Whoops . . . I see my mistake. Thanks ! ! !

Now I'm getting a return of "False". See code below i = 0 Do While i < 3 i = i + 1 Aout = Me.Controls("A" & i) MsgBox Aout = Aout & i Loop End