Search results for query: *

Yes, I ended up at annoyances.org. It was the CD autoplay type issue, now it applies to Zip disks as well. I used XP Tweakui to turn it off (which locked up the system by the way, but worked fine after re-boot).

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...

Will give it a go after the meeting I should be paying attention to is over....

In this case both, although there is no reason why it has to be. ean13.AssignedNumber.AssignedNumber db.tbl.fld

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...

Well, it worked fine. Still thought this was part of the backup procedure. I guess it got a bit more complicated as more management features were added. Will add this so I can keep log in check. Thanks VERY much, -- Dave

Thanks, I have "shrunk" file, but it seems to get no smaller. I will give these a read. Thanks again.

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...

Big, DOH! The resetting to 0 worked fine. It was the decrementing code; rst!AssignedNumber = rst!AssignedNumber - 1 That did not work (the table is AssignedNumber and so is the field). You are correct in that I did create a table with that one entry AssignedNumber.AssignedNumber = 99999...

Jebry's code worked fine except it choked on the line #Set rst = Nothing I am continuing to dig and finding new ways to do stuff (I am a novice to Access but not SQL). I am so frustrated since Access makes things so 'easy' I feel like a fool when I can't figure out how to make the out of the...

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...

OKay, Dummie time. The way the number breaks down is: 1234567 - 12345 - 1 Static - increment - mod10 What I have done since yesterday is create a field to allow the user to use a picklist lookup for the correct static license (we own about 10). My problem (which I am sure is elemental) is...

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 got it working, I was picking the wrong tab for the sort, duh. Thanks.

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...

Nope, but it SHOULD work, right? I don't have to do anything more than define the destination column as int and the strings should be converted automagically?

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??

I figurede it had to do with permissions, never really figured out which one was doing it, but went back to a SQL service account which I used to use for both SQL and jobs, everything works now.