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

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

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.

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

i have a form based on a query. one of the controls, combo box, on the form is not bound to any field of the query. however, initially when the record on the form is changed i want to set the value of the combo box to one of the text boxes that is on the form. but i am unable to do so. can...

I want a combo box on my form to sometimes show the following value list: a b c d and sometimes I want it to show the following only: x y How do I dynamically change the value list of the combo box on the form?

rstQuestions is a recordset containing a set of questions. I am using the following code to move from one question to the next. I want my form to close automatically if I try to go to the next record after the last question. With the following code, I am not able to accomplish that. Instead I...

I have a form whose record source is a query. But I want to save this form entry to a table. How do I do that?

Hello, I am creating a query (the vba code is below) which extracts certain records from two different tables and shows the results in a form called frmQuestions. Now, I want to assign values to Session ID, Patient ID and Session Date. These all will be passed as parameters to this module. How...

I have been trying to write some VBA for a parameter query so that I am not required to enter the parameter via an input box. I tried the first method (the parameter value is criteria comes from txtQuesnID.Text (txtQuesnID.Value), but am getting this error: Microsoft office cannot move the...

The following code is suppose to read a text file. The problem is that the code is only reading the first line. The other lines are not getting read. Second problem is that the .Fields(Counter) = Now is not working. The error says data type conversion error, which I do not understand since...

Hello, I am trying to write some VBA code so that the user of my database does not have to enter the parameter to the query. I have tried unsuccessfully two attempts to do that. neither one is working. Can someone help? First way: Option Compare Database Private Sub cmdDialysis_Click() Dim...

hello, I have written the following code to import values from a text file and append them to a table. The problem I am having is that the date value form the text file gets changed after being imported to the table. The date field in the table is formatted to accept medium dates. Can someone...

Hello, I have another stupid question. I have created a table which a field type of OLE objects. I want to insert some wave files in it, but I have no idea how to transfer the wave files on my desktop to this field. Any help is appreciated.

I know exactly how to import a text file and append it to an existing table in my access database, but I do not know code this in VBA. Can someone help me out? thanks,