Recent content by moonbase

Many thanks. This has pointed me in the right direction and I'll play around with it later.

I am sure there's a simple way to do this but I can't get my head round it. I have a master table with accounts (account no, name, etc) and a linked table with transactions, many per account, (date, amount, etc). Is there an SQL statement to retrive the name from the master table with the date...

Joe, If you doubt my searching prowess, you should try it yourself. It's easy. I refer to a datasheet view in Access. The data loads instantly. I can zoom up and down the table. The codes are sorted so its easy to find blocks where the first 2 characters are what you want. You then presented...

Interesting reponses, firstly addressing whether it's good practice to display 100,000 records in a grid and secondly the problems with the grid, which was the point of the original question. The records contain translation codes and just 3 columns. The codes are sorted and are naturally split...

Yes, naughty, missed a 0 from original post. As mentioned, works OK if less than about 66,000. Showing a 100,000 records is valid in my application. The grid allows a quick visual check of the contents of various translation tables. The translation tables are created elsewhere and most contain...

Thanks for the suggestion but it didn't work. In fact I want to display 100,000 records but the scroll only works if there are less than about 66,000 records. I tried moving last - the last record is displayed but when you scroll up you get the same problem scrolling down. It looks like a...

I have a datagrid displaying about 10,000 records. When I drag the scroll bar down, if I go past about half way, it jumps back to near the top. What's going on? Page down key seems to work OK but it's laborious with so many records.

Thanks, that's useful. I'll look into running my VB application and connecting via ADO/OLE DB or ODBC. As suggested, I'll check out the drawbacks with ODBC.

I have an application written in VB 6.0 and have been asked about porting it to an AS/400 environment. I guess one option would be run my application on an attached PC and connect to the data via ODBC. Is practical to translate the code to a different language? (There is a small amount of user...

Thanks for the help guys. It actually turned out to be fairly straightforward once I'd got my head round it. But I'd have struggled without your help. This is what I ended up with: Public Function Hex2Currency(HexCurrency As String) As Currency Dim s As String Dim i As Integer '...

Big-endian

Thanks, this is along the right lines but when a say the right most byte is 5F, I don't mean a string of 2 ascii characters, I mean one byte, 8 bits. This can represented in this discussion as hex 5F or binary 0101 1111. To get your idea to work I need to create an ascii string of 2 characters...

Thanks for your help but I don't think you've quite got it. The rightmost byte in my example is hex 5F, this represents 0101 1111 binary, 95 decimal. So to use your code I first need to extract each nibble. Also negative numbers in two's complement format are not just postive numbers with the...

In the text file there are a series of characters representing a binary number in two's complement format. Conventionally they are represented in hex format: 00 00 00 00 20 5F

Sorry if the title of the thread is misleading. I haven't got a string of 0's and 1's. It's just binary/hex in the file, e.g. 00 00 00 00 20 5F in hex. So the first thing to do is unpack it.