Search results for query: *

Let me first start with...I am teaching myself .net :) Now, having said that...I have a page that contains a 3-level nested gridview: parent child grandchild For the most part..it works. The parent and child grids both work perfectly. The grandchild however, is causing some...

Hello, I am trying to help my non-technical users :) I have a Access 2003 report that I need to print 6 pages on 1 sheet and rotate it 180 degrees. It is easy enough (for most people) to just go into the printer settings (i.e. rotate printer orientation 180 degrees and print 6 pages per...

Ok, I can't figure this one out. I have a grid with a combo box that has the following code: </asp:TemplateField> <asp:TemplateField HeaderText="Day of the Week" SortExpression="Day_of_Week"> <EditItemTemplate> <asp:DropDownList...

Ok, I have 2 tables. Tbl_IP_Address contains a listing of all IP Addresses assigned to my org. Tbl_MAC_IP associates the IP Address to the MAC address of a given device. I want to query for those IP Addresses not assigned to a MAC Address. Here is what I have so far: SELECT...

I have an Access 2003 database that is acting pretty strangely. The controls on the form are all unbound and I am using DAO to reference the tables / queries. I have a date field on the form that when clicked will open an ActiveX calendar control. When the date is selected on the calendar, it...

Ok, I have an Access 2003 database with a text field that "may" contain information like 'With 3" Base'. When pulling this information into a list box, my columns get messed up because of the ". I am relatively sure that I am missing something simple, but could someone please take a look at my...

Hey everyone. I have 2 systems, a development server (SQL Server 9.0.1399) and a Production server (SQL Server 9.0.3042). I have created an endpoint on each server where the only difference is the server it is pointing to. The code is as follows: Create Endpoint Birthday State = Started As...

I have a form that allows the user to either embed or link to graphics files. On all of my computers (I have 2 desk tops and 3 laptops) it works great. I embed the file and the actual picture shows up in my bound object frame. However, when my client does the process the icon shows up, not...

I am trying (unsuccessfully so far!) to open an embedded OLE Object as Read Only. Currently, if the user double clicks on the embedded object the associated application (word or excel etc.) opens and the user is able to modify the document and click the "update" button. When the user closes...

Hey everyone, I have an OLE Object (a Word Document) that I open in a form. To open the object, in an unbound form, I am using an image box. The image box populates properly with the correct record. If I right click on the object I am given the option to either Open or Edit the record. If I...

Hey everyone, I am obviously missing something with this code, only I can't figure out what it is. On the double click event of my UNBOUND list box, I am trying to delete the record selected. My code is as follows: Private Sub LstContracture_DblClick(Cancel As Integer) Dim...

Hey, I have a list box that is only showing the first 16 records (of 46) is there a size limitation on list boxes that anyone is aware of? I pull the data into the list box from a query. When I run the query I get all 46 records, but the list box only shows the first 16! Any info would be...

I have a report for patient assessment data. This report is filtered based on the AssessmentID and PatientID that the user selects on a form (They select the Assessment date the rest is done behind the scenes). I need to somehow get any hospitalization data that occurred between the date...

hey everyone, I have a form that enters patient assessment information. On this form, I want to pull in any hospital visits the patient may have had since the last assessment. I got this part working great through queries (thanks to some help in the query forum). Now, what I am trying to do...

Hi, I am trying to pull data where the data is between 2 dates. The problem is, I don't want the user to have select the dates. I want to be able to pull the data that is between the most current 2 dates. My tables are as follows: TblHospitalVisit HospitalVisitID HospitalVisitDateTime...

Hey everyone, I am trying to set up my home office. I have 2 computers a linksys router and a cable modem. I can get each computer to work directly with the cable modem. I can get one computer to work with the router and the cable modem, but I cannot get both computers to work. The second...

I'm stumped! I have a list box that gets populated through a query. The query pulls data from 7 tables! I have not been able to come up with a query that will limit the data! So, I was wondering if it can be done through the form. What I have done is create 2 queries. The first query...

OK, it's official! I have no clue what I am trying to do :) Lets see if I can explain it. I am trying to get a report of all Open cases based on the highest priority. I can't figure out how to get only the max value to show. I created a query to find all open batches. I then take that...

Help!!!! I have a form that is UNBOUND. I need to have the application ask the user if he/she wants to save changes before closing, if the user made changes to the data. OK, I have a pretty good start. The code below actually works as specified (for the most part) [ponytails] What happens...

hey everyone, I have a table with the following data: LastName FirstName MiddleInt Doe John D White Karen P Johnson Mary (note the third user does not have a middleint) Now, I want to concat the names into one field so the data looks like so: Doe...