Search results for query: *

I want to send an email through an access form when a button is pressed. But the email does not get send the email address me@me.com. Can someone let me know what is wrong? When I set the last parameter to True, i do get the outlook email page with the correct values for the emailtext, subject...

I am trying to save the value of a text field on the access form into a table using Update statement. CurrentDb.Execute "UPDATE PATIENT SET DROPOUT_REASON = '"& txtReasonDO.Value & "' WHERE PATIENT_ID = "& 1 & ";" I get errors when I have commas or quotation marks in the text fields, but...

how do i transfer excel sheets?

here is the code i am using to read the text fle. the error occurs at If arList(iPos) <> "" Then Set db = CurrentDb Set rst = db.OpenRecordset("SELECT * FROM UPCS") num = 15 With rst strname = "C:\Documents and Settings\dima\Desktop\Barcodes\barcode1.txt"...

i want to import an excel sheet into access table such that i ignore the middle 6 columns of the sheet. How can i do that? I tried to do this by first converting the excel sheet into a text file and then reading the text file. But i got a subscript out of range error. i think that this has...

actually, i found the mistake. it ad something to do with the code i had written before moving to next record. but i think that setting data entry to no was very crucial.

cycle property is set to all records. the default record move button does show me all the records. but i want to see all of them with my own move to next record button which is not working.

the controls are properly bound to the query fields. setting the dataentry to no is showing me the first record, but the next button on the form does not show me the next record. here is the code that i am using to move to next record. (i need to create my own next button for some reasons) If...

I have a form whose control source is a query which pulls records from a table based on certain parameters. For some reason, the records do not show up. I checked the query and it does show all the relevant records from the table.

thanks SeeThru and Pwise. Both suggestions helped me fix different problems.

new i just did not want to include the long sql statement in this post. i have a comment saying that i am leaving it blank for readability.

My form is based on qryQuestionnaire. After going through the recordset, I want to do a requery with new parameters. The code that I am using to do that is given below. but for some reason after requery, my form does not show the new record set. extractQuestions(2, Me!txtCycleForm...

i was thinking about what requery means? is it going to change the record set on which my form is based? the query returns a record set consisting of questions that can be answered in one way, i.e. as yes or no. The second time, i want to get those questions that are answered as either hard or...

i have a form based on a query. when i have finished going through the recordset, i want to open the form with a different record set. because i am using some of the variables on the first instance of the form to create the second instance, i need to keep the form opened. once i am done with...

okay, never mind... i figured that out thank you so much for your help tonight

thank you. that worked. but coming back to the first problem Me!ComboAnswer = DLookup("Score", "tblLikertScale", "[Description]='" & Me!txtAnswer & "'") is not working.

yes, i am now calling that field MyOption. Nothing is on a subform. all the fields of the form are based on a query which extracts fields from different tables. I removed the semicolon but still no luck.

id is a number and i made the changes that you suggested but still not working. instead i see in the value list the following: MyOption FROM tblLikertScale WHERE Id = 1 the first part of the SQL statement has disappeared for some reason.

I have a table with the following fields Id, Option, Score and i want to set the value list of the combo box using certain id. i am not able to do it successfully. Forms!frmQuestions!ComboAnswer.RowSource = "SELECT Score, Option FROM tblLikertScale WHERE Id = " & idx & ";" what am i doing wrong?

yes, my combo has an ID field that is the bound field and another field which is displaying the value. i don't understand what you are trying to say, but i also tried to set the value of the combo box using the following method. Me!ComboAnswer.Column(1) = txtAnswer.Value but that did not work...