Search results for query: *

Hello, I am getting the following error message when tryin to run the code listed below: Server: Msg 241, Level 16, State 1, Line 1 Syntax error converting datetime from character string. Code: SELECT T1.EMPI, T1.DATE, T1.VALUE FROM plmCombinedLab AS T1 WHERE T1.EMPI IN (SELECT TOP 2 T2.Date...

I'm trying to return one of two values if a person has a BMI>25 or if they have a weight of >210 I would like the true value to return. The following code returns BMI when neither of the above criteria is true. How can I return only the true value? Expr3: IIf([Weight]>="210" And [BMI]>="25"...

Hello, I have a table called Labs and a table called EE's. Each EE has many labs in the lab table. I am trying to figure out how I find the top 2 labs (based on date) and return that along with all of the fields in the EE table. Would I use a sub query? Something like this? SELECT * FROM ee...

Hello, I have a table called Labs and a table called EE's. Each EE has many labs in the lab table. I am trying to figure out how I find the top 2 labs (based on date) and return that along with all of the fields in the EE table. Would I use a sub query? Something like this? SELECT * FROM ee...

Hello, I have a form with a button on it. I would like the button to open a second form when clicked. The problem I am having is linking the second form to the record in the first form. This is not a sub form/form example, they are two seperate forms. Can this be done. Thank you.

I have an Access form with a button on it that opens a sub form. I cannot get the sub form to open linking to the record id on the first form. Any suggestions? Here is the code I use to open the sub form: Private Sub Command178_Click() On Error GoTo Err_Command178_Click Dim stDocName As...

Hello, I have written 2 sql statements in my code below and only one table displays on the page. If I comment out one sql statement, the other works, but they will not work together. Could you please point me in the direction of a solution? Thank you <%@LANGUAGE="VBSCRIPT" CODEPAGE="1252"%>...

Hello, I have about 150+ text files which I need to import into Access. I have the following code I used earlier to import spreadsheets. Can anyone modify this or provide direction as to how I can automate importing 150+ spreasheets? If Len(Trim(Nz(MyTextBox,"")&"")) = 0 Then msgBox "please...

Hello, I have 150+ text files which I need to import into SQL server. Any suggestions how I can do this without going through each text file individually? Would it be possible to write code to import all of these files at the same time or loop through each file until all have been imported...

I have a web page with a few rows displayed in a table. I would like to display some text that flashes or stands out in a different color when a new row is added to the table. How can I disable the text ("New!") after a certain amount of time or after a user clicks on the new row and previews...

Hello, I have some asp pages that are quite generic looking and would like to spruce them up with a template downloaded from the web. Does anyone know if HTML templates are compatible with ASP codes or are they tricky?

I have a tree menu which displays a list of fields from my table. I would like the users to click on an item from the menu and then have the system generate code to pull the corresponding information from the database and display it on the same form, different table. Example: user clicks on...

hello, I have form A which users click on a hyperlink and the hyperlink values is displayed on form B. Users input text on from B and that is input into the datbase. I am having trouble inserting the passed parameter from form A into the database. Here is the code I am using: frmName =...

Hello, I am trying to insert data from two fields, eventually more. Could you please tell me how I would code the two fields? I have the following for my insert statement and am not sure about the syntax before frmcontact. When do you use double and single quotes? sqlStatement = "INSERT INTO...

Hello, Can anyone point me to some code which would build a dynamic vertical menu. A tree menu would be best, but any verticle drop down would do. Also, I need this to populate from a database. Thank you,

Hello, I have a report generated from a query of 7 fields. I am using an IIf statement, so if true criteria is met I calculate 1 point for each true field. Is there a way to color the fields on the report for each one that meets the true criteria? Thank you,

Hello, I have 3 fields in a table (field 1, field 2, field 3) which are all combo boxes with a value of yes, no & N/A. I need to assign 1 point to each field if they are a "yes". I would like to display the sum of all points for each row within a form. Where and how would I query for a "yes"...

hello, I have a form with two subforms on it referring to the same table. Basically, I have sectioned off the fields into two subforms. I have a button on one form which saves the entry and clears the text box. What I would like to do is clear the checkbox on the 2nd subform once this is...

Hi, I have two fields (Start Time and End Time) on my Patient form. Is there a function I can create to auto populate those fields with the Now function. I am thinking start would be the time the form opens and end would be when the user moves off of a record. Thank you.

Hello, I have a data sheet view form with a column titled "Patient Name". I would like the users to be able to click on a name from the Patient Name field and have that open to another form called "Details", but I would like the Details form to default to the selected record. Any advice how...