Search results for query: *

I happen to keep my financial files on a zip disk. So, I put an internal IDE Zip drive in my box. Every time I put in a disk, the explorer (or whatever it is called now) opens up. I really don't like this and wish it would not, but I can't seem to dig up the place to prevent this. I turned off...

Private Sub Text57_Click() Dim rst As DAO.Recordset Set rst = CurrentDb.OpenRecordset("AssignedNumber", dbOpenDynaset) Text57.Value = rst!AssignedNumber rst!AssignedNumber = rst!AssignedNumber - 1 Set rst = Nothing End Sub */ This bit is supposed to fill a field on a form with the...

How do I get the logfile to truncate? I have tried everything (except obviously the right thing). Actually, everything short of writing a query to do it, which I have not attempted since every gui way seems to fail so my faith in writing the query is low. I do daily FULL backups, I only have...

We are creating a form that "creates" an EAN-13 code when requested. These codes have a fixed 7 digits(basically a license)followed by 6 digits you can do anything you want with. We have decided to use the 5 digits following the license as the ones which will indicate unique...

I have to calculate a check digit from a 12 digit code. Each digit needs to have an arithmatic operation done on it. My first hurdle, how do I get the 12 digit number into another table with each digit in its own field (so I can then go to work on them). I thought I will likely have to convert...

I have an application that creates an EAN code (13 digit code of which the first 7 numbers are a purchased license and static, the next 5 assigned by the app, and the last digit is a check digit using the EAN ISO approved check digit algorithm). I am struggling as to how to get this to work. I...

I have worked with SQL to deliver reports in the past, but have never had to create anything more than a simple data imput form. Currently, I have been given the task of creating in Access2K a form which allows for data imput (got that part OK) and then creates a new EAN-13 license for the...

I have a report that has 3 groups and 4 fields. The one field not grouped is "message size" so that I can sub-total message volume against the other 3 groups which are "site", "transaction", and "destination site". I managed to get the report to sort...

I have done this before, I just can't figure out why my straightforward import of a flat fixed length field won't allow the last string to be converted to an int. This always worked in the past. Now I am getting the error conversion invalid for datatypes. What did I forget to do??

DTS data jobs that I used to be able to run with no problem in SQL7 are now refusing to run in 2K. Other jobs run when scheduled. The really odd thing is that I can run these jobs by selecting them in local packages area in Enterprise Manager and selecting execute. I figured it had to be...

I don't remember having problems with this before (good since I don't know how to do it!). I have a text file source which is fixed length fields. The last field is a "number" representing length of a message. When I setup DTS import using the wizard before, I seem to remember having...

I have a huge (500mg and growing) text file which is fixed field length with no delimiters. I need to determine is the 28-->77 characters are ever repeated in a subsequent row/record, and if so, spit them and the entire record it is contained in out to another file leaving only one occurence of...

I recently upgraded from SQL7 to 2000. One of the tasks in my database was to go out and retrieve a couple tables from an Access database. I used the default name in my SQL7 database which was the same as the table name in Access, namely, '_EAN13Codes'. SQL2000 doesn't complain about the DTS...

Enterprise manager times out prematurely on some queries and the maximum setting for timeout threshold seems to be 30000 ms. I have been told this is a bug (not being able to increase the timeout threshold). Any fix?

I have a SQL server machine that has Perl on it. No one currently with the company knows how to use Perl. Unfortunately for me, I am supposed to come up with the answer to the following question, oh, like yesterday! I apologize in advance for my ignorance, but what little I do know of Perl is...

I have a mess on my hands and very limited personal or organizational resources. I apologize in advance for what is likely a stupid question, but here goes; I have a fixed field text file that consists of the headers from MQ Series messages. Each record 'should' contain a unique 48 character...

I have a very LARGE text file which has interspersed 2000 unique codes throughout alot of junk I don't care about. The task of identifying these codes was dumped on my desk. My first thought was "Why didn't you learn Perl when you had some free time?". My second was, this should be an...