Recent content by noccy

Ok, Thanks. I will try that approach =)

I have tried val(), but I use asp.net, and I get an error saying the val function does not exist..... noccy

That works, but I still get ARB1, ARB10, ARB11......ARB2, ARB20.... noccy

Why take away -3? noccy

Hello! I have a problem with sorting. I want to sort a recordset by part of the contents of a field. The field has ARB and then a numeric value: ARB1 ARB2 ARB3 etc I want to order the records by the numeric value. I have tried something like: "SELECT * FROM myTable ORDER BY...

could you post the code?

1. close the form 2. Open the form

If you create the columns you need in your table, and then use ADO to add the filenames... This might get you in on the right track Dim cn As New ADODB.Connection Dim rs As New ADODB.Recordset Set cn = CurrentProject.Connection 'Find all records where Filename is blank (that means that all...

Anyone know how to solve this problem with ADO? noccy

Hi! To specify the problem: I get data from two sources. The first set is a list of transactions with date, time, TransactionType, SenderAccount, ReceiverAccount, FinalAccount etc.... All accounts are unique Account numbers The second set is a list of all the accounts, and their owners...

Hello! I have a table like this: Account1, Account1Owner, Account2, Account2Owner,Account3, Account3Owner. All the account owners are blank In another table i Have Account, AccountOwner How can I join theese two tables in one query so that the accounts get the right owners? I see that i...

Hello! I use this code to get data from a txt file into a recordset: Dim cn As ADODB.Connection Dim rs As ADODB.Recordset cn.Open "Provider=Microsoft.Jet.OLEDB.4.0;" & _ "Data Source=c:\temp\temp\;" & _ "Extended Properties=""text;HDR=Yes;FMT=Delimited""" rs.Open "Select *...

Thanks You =)

Problem with query and two forregin keys Hello! I have the folowing tables: TblTransactions[Date, Time, SenderAccount, ReceiverAccount] TblAccounts[Account, Owner] How can I make a query like this: [Date, Time, SenderAccount, OwnerSenderAccount, ReceiverAccount, OwnerReceiverAccount]? I...

The fields SenderAccountNumber and ReceiverAccountNumber are the same as AccountNumber