Search results for query: *

Good question, I am writing the data to another table in the same database that uses the autonumber as the key and link between the tabels. I wanted to get the number prior to writing the first record so that I could write the second. Its been a long day.

true I agree that it would be better to get the next number after it is written. This will be used in a single user. The program is multi user but this is for a special import which only one user will be on the system at a time. Thanks for your assistance. I think I am going to write the...

Hi, thanks in advance I am working with a table that has autonumber Increment as the key filed. I am writting the records from VB. I would like to get the next Autonumber to be written prior to the record being written. now using a qry slelect max(autoField) from table XX provides me...

Hi, thanks in advance. I want to read all the registry “sections” under “configname” this is prior to the keyname and keyvalue. I want to put these sections into an array to use later. I have tried to use the getAllSettings, but this retrieves the keys Does anyone have a suggestion...

Thanks but no its not attached to a .dbc I found the problem is in the with RS it needs to be: With rs If .State Then .Close .Open strSql, cn, adOpenStatic, adLockBatchOptimistic The Cursor and Active Connection had to be removed. then it worked great...

Hi, thanks in advance. Im attempting to get data out of a VFP 6 table. I make the connection but while running through a recordset I get this message "Data provider or oter service returned an e_fail status" here is the code Im using Private Sub Command1_Click() Dim cn As...

Chip, thanks, thats what I did. The client had placed a phone system through the computer that required mdac 2.7 or higher. My program was using 2.5 I upgraded my program to 2.8 and the client also upgraded to 2.8 and all is working fine now. When I attepted to place other versions of mdac...

I see that I never got back to you. Thank you for your assistance. I am using the second suggestion and it is working fine. Now I can remove the dao 3.6 from my ref. thanks again

Hi, thanks in advance. How can I be sure that what I am writting will only use mdac 2.8 Im writting an vb6 program that uses access database. I will use an ado connection to connect to the data. Im not sure how I can tell if I am only using what comes with mdac 2.8 this is what the system...

Try this # strsql = "Select * from timedata where weekending BETWEEN #" & datBegDate & "# AND #" & datEndDate & "#"

Just found this on Microsoft Knowledge Base artical 198144 ' Converts (row,col) indices to an Excel-style A1:C1 string Function IndexToString(row As Long, col As Long) As String IndexToString = "" If col > 26 Then IndexToString = Chr(Asc("A") +...

Hi, thanks in advance, I have created an excel spread sheet from with in vb I am now attempting to put a formula into the spread sheet for each column. I am haviang a problem referencing the column I want to put in the formula. I use the column number but I think excel is expecting a b c d...

Sorry for not getting back sooner, got on other projects Im using a modified version of what you posted. Thanks for your assistance Jim

Hi, thanks in advance, I am working on a vb6 project using ado, I have connection into a access 2000 database I would like to know the commands to check to see if a table exists in the mdb. I have the I have the stuff to delete the table but I get an error if the table is not there. and what...

Thanks Jeremy yes it is going to get a lot more complex. I think I will use 2 cross tabs to get my results one for regular and one for over time. Thanks for your assistance Jim

Hi, thanks in advance. I would like to use the rows of a tabel to be the columns of a table. I have looked up this question and find normalized views and unions. I do not understand where you build these unions at. A cross tab file may work for what I am looking for but I will never know...

Hi, thanks in advance: Share a Connection name between two databases. Hi, thanks in advance. I want to have 2 connections to 2 different sql servers (2 different) computers. I have a table on the first server that tells me where the database I need to access is. I have created 2...

zemp, it was so simple. Thank you very much. It worked just like it should. thanks for your help Jim

Hi, I posted this in pervasive also but Im hopping someone herer can shed light on this error: thanks in advance Im getting this error when I attemp to run my insert sql " Run-Time error '12147217900(80040e14); [Pervasive][Odbc Client Interface][LNA][Pervaiive][ODBC Engine...

Hi, thanks in advance Im getting this error when I attemp to run my insert sql " Run-Time error '12147217900(80040e14); [Pervasive][Odbc Client Interface][LNA][Pervaiive][ODBC Engine Interface]Invalid date, time or timestamp value. I get this when I attempt to bring in a date from a...