Search results for query: *

(I originally posted this in the Access forms forum by mistake. Sorry for the duplication) I have been given the task of converting an MS-Access 2003 application whose database currently resides on SQL2000 (mixed mode) and move the database to SQL2005. They want the database to reside on a...

Hi I have been given the task of converting an MS-Access 2003 application whose database currently resides on SQL2000 (mixed mode) and move the database to SQL2005. They want the database to reside on a Windows Authentication Mode SQL Server. This means that I would need to impersonate a...

I have two tables: tblA =============== CustNbr int SeqNbr int Field1 varchar Field2 varchar tblB ================ CustNbr int SeqNbr int FieldX varchar I want to update Field2 in tblA with the values from FieldX in tblB where tblA.CustNbr=tblB.CustNbr and tblA.seqnbr=tblB.seqNbr. When...

I am inserting data from an XML string into a SQL Server 2000 table. I have no way to assure that the data I assume is numeric coming in via XML is in fact numeric. So it is causing my insert to fail. Here is the insert statement: INSERT into sm_InvBalanceRoot (LocCd, CatCd...

I've searched the archives here and tried things I've found but nothing is working. Here's my problem: My Windows Service has to read the contents (1 line) of txt files. A source file comes in, I read it and process. Then I read the next source file. Sporadically I get the following exception...

I am writing a Windows Service and I need to have the service perform some function at 10 past and 40 past every hour. How do I set up the timer to do this? I am assuming I would use system.timers.timer somehow? Thanks for your help.

I have a SQL table that has a number of fields including these two: EmpID char(6) EffDate datetime There can be 1 or many EmpId's. What I am trying to do is find a simple way to delete all the duplicate EmpID's except the one with the most recent EffDate. For example, if this were my data...

I have a 3 year old Dell Dimension 8100 (1.8GHz processor, 512mb ram, 60gb Ultra ATA/100 Hard Drive, 32mb NVIDIA GeForce2 MX 4X AGP graphics card, 48x cd drive)that had run W2K Professional through its entire life. Over the past few months it began to have problems (hanging when trying to...

Hi. Yesterday I added a new Win XP SP2 pc to my home network (3 W2K Professional pc's). The initial connection to my network (peer-to-peer workgroup) went fine. But then the connection goofed up on the XP machine. I cannot access the workgroup. It gives me the message in the subject line. But I...

In Access XP I have a report that first fires off a group of queries to do a bunch of stuff and place their results into a work table (after deleting the contents of this work table). The report than reads this table and produces the output. The problem is when multiple users try to run this...

I have an asp.net app that is one long form that the user fills out. I want to produce a printer-friendly version of this form on demand. What would be the easiest way to do this? Crystal Reports is out of the question because they have priced themselves out of the company I work for. Thanks.

I want to be able to read and process all items on my data grid without using the built in row by row editing of the data grid. I have a templated grid that opens up with n... records loaded and displayed in their corresponding controls within the grid (textbox, dropdownlsit etc). I want to be...

Hi again I have an Access XP form with a combo box on subform within that form. The combo box's rowsource is a query with a condition based on the value of a field in a textbox on the form. This value does not change once the user is on this form. What I am finding is that sporadically the list...

Hi I have an Access XP subform on a form. The subform has 8 textboxes across, Monday-Sunday and 1 textbox for a code. The subform is set up as continuous forms so the user can just continue to type in data and have new rows appear for them as they go. My question is this: If they type something...

Hi I have an offsite user that tried to open an Access 97 DB in Access XP and decided to poke the "Convert" feature. Now his db will only open in read-only mode in Access XP. Any ideas how to get this DB open read-write? Thanks!

I have a report in Access 97 where a column needs to be in gray. So I put a gray box behind that column. Problem is, the other columns, which are text boxes (no color) can grow. This causes white spaces in the gray column. How do I resize the gray box to fill the entire detail area? You can see...

I have an Access 97 system that builds a lot of temp tables through queries in the system. Is there a way I can run a routine to identify which temp tables are there and to delete these tables? All of my temp tables begin with "TEMP". Thanks!

I have DSL through Earthlink (SpeedStream 5667 modem) I am using a Linksys 4 port router with 4 Windows 2000 machines connected. My router settings are: - Obtain an IP address automatically - Login: PPPoE - DHCP enabled - The DHCP table shows the 4 computer's IP addresses as 192.168.1.100...

In Access 97 I have a table that looks like this: IncidentNumber text SequenceNumber integer Description memo If I had data like this (I'll separate by commas for readability): A0000001,1,Blah blah blah blah. A0000002,1,This is the 1st desc. A0000002,2,This is the 2nd desc. A0000003,1...

Hi! In Access 97 I need to create a chart that looks like, well here is a mockup I did (I am not a good graphical artist): http://www.ncyankee.com/samples/graphsample.jpg On that sample, the blue lines are sums by person. The red lines are the average for the people on that team. I know I can...