Search results for query: *

Hi, I have a form that has many check boxes (over 50). After the user finishes check the boxes he needs to check, I would like to step through each check box and copy them all to a table. The fields in the table have the same names as the check boxes name but not necessary in the same order of...

Does anyone know how to use MsAccesss to read OPC server data? I have an OPC server that is collecting data and I would like to store and display these data in msaccess. I know the DDE would be a good start but I am having difficulties getting it to work. Any help is greatly appreciated. Thanks...

I am sending an email message using a code I built. Every time the message is sent, I get the following from Microsoft Outlook: "A program is trying to automatically send e-mail on your behalf. Do you want to allow this? If this is unexpected, it may be a virus and you should choose...

I need to disable/enable the save document function in group policy but I can't seem to locate this feature. I appreciate any input. Thanks, Sam East or West Home is Best.

I have a database that I converted from Access97 to Access2000. This database is copied from a server to a local workstation and gets executed from that station using AccessXP. I am puzzled of why the database quits on only one specific workstation but not the others. After I inserted some...

I have a database that I converted from Access97 to Access2000. This database is copied from a server to a local workstation and gets executed from that station using AccessXP. I am puzzled of why the database quits on only one specific workstation but not the others. After I inserted some...

I have a form that gets data from a query. The query might have many records; therefore, the form has the same number of records. I made a Command Button on the form to transfer the current record data that I am viewing, to a table. Thus, only the data I am viewing is supposed to be...

I am getting the following error when I try to edit a chart in my word document: "Word cannot edit the msGraph chart". Any idea? Thanks.... Sam East or West Home is Best.

Below is a function to step through a query, one record at a time until the end of the file. I am having a trouble inserting the value of each record “ActiveEmployeeName” to a table. I do not want to append to the table. I just want to have one record in that table which is the value that is...

Below is a function to step through a query, one record at a time until the end of the file. I am having a trouble inserting the value of each record “ActiveEmployeeName” to a table. I do not want to append to the table. I just want to have one record in that table which is the value that is...

Below is a function to step through a query, one record at a time until the end of the file. I am having a trouble inserting the value of each record “ActiveEmployeeName” to a table. I do not want to append to the table. I just want to have one record in that table which is the value that is...

Below is a function to step through a query, one record at a time until the end of the file. I am having a trouble inserting the value of each record “ActiveEmployeeName” to a table. I do not want to append to the table. I just want to have one record in that table which is the value that is...

I have a table of x number or records. Each record has a field name called LastName. I would like to go from 1st record to last record one record at a time to perform a calculation (query) on that record and then move on to the next record. How would you write a code to this task? Thanks, Sam

I have a table of x number or records. Each record has a field name called LastName. I would like to go from 1st record to last record one record at a time to perform a calculation (query) on that record and then move on to the next record. How would you write a code to this task? Thanks, Sam

I have the following function (see below) that runs a cross tab query which produces 1 record. However, sometimes, the query has no records to produce. At that time I get run-time Error. I tried to use the IsNull function, to solve this problem, but I guess I am using it wrong. Would anyone tell...

I have the following function (see below) that runs a cross tab query which produces 1 record. However, sometimes, the query has no records to produce. At that time I get run-time Error. I tried to use the IsNull function, to solve this problem, but I guess I am using it wrong. Would anyone tell...

I have the following function (see below)that runs a cross tab query which produces 1 record. However, sometimes, the query has no records to produce. At that time I get run-time Error. I tried to use the IsNull function, to solve this problem, but I guess I am using it wrong. Would anyone...

I have the following function (see below) that runs a cross tab query which produces 1 record. However, sometimes, the query has no records to produce. At that time I get run-time Error. I tried to use the IsNull function, to solve this problem, but I guess I am using it wrong. Would anyone tell...

Could anyone tell me how to pass the value of one field in a query back to a function? I.e. I have the following function: Public Function InitialDate() As Date InitialDate = DateSerial(2001, 7, 1) MsgBox [InitialDate] End Function I would like to assign the "InitialDate" to get its...

How do you setup criteria in the query to the module? Would you give an example? Thanks, Sam