Recent content by creeping

Does anyone know why when I export Numbers (double) from a table to a text file it exports to only 2 decimal places Thanks

I found out the problem thanks. I need Access 2000 when I'm using 97

Can someone tell me why the VB "split" function does not work for me. What reference library do you need on?

thanks heaps

Hi, How do you use the MAX function on 2 fields in SQL to then produce the result a new field. i.e 12, 24 would go to: 12, 24, 24 << this is the max of fields 1 & 2 Cheers

Hi, I am trying to populate a listbox with Excel worksheet names from a ADO connection to a spreadsheet. What property do I need bring up the worksheet index and then find out the name of that sheet. Is it somehow possible to do this or do you have to use a different approach? Thanks

Does anyone know have to check in an access database if a table already exists with ADO? Thanks

thanks guys I got it to work

Hi I'm just starting out using ADO in access but I can't get the code to compile in Access 97. The first part of the code is: Option Compare Database Option Explicit Private Sub Command0_Click() Dim cnn As New ADODB.Connection Dim rst As New ADODB.Recordset Dim curdb As Database Set curdb =...

thanks

If I had a Refresh Combo Box on a form based on query and I then changed some of the data in one of the table relating to the query how do you get the combo box to update it's values. Cheers

If I had a Refresh Combo Box on a form based on query and I then changed some of the data in one of the table relating to the query how do you get the combo box to update it's values. Cheers

Thanks for all your hard work on that. It really cool that you have been able to do this with SQL. There are still a couple of little things I don't know how to fix. I need to have the range a +1 -1 To get the right answer. Currently you have used +-0.5 which sometimes works but not all the...

Sorry here is the excel file

Hi Nouba I tried using your query in Access but It not quite right. 1) I need the match to be unique i.e Once a number has been matched neither of the numbers can be matched with other numbers 2) You have got the blank cells right on the second selected sample but this occurance blanks also...