Search results for query: *

I'm a newbie to SQL Server. I'm trying to create a database where multiple fields in a table can point to one field in a second table. I create a foreign key from Field1 in Table1 to Field1 in Table2. I then try to create a Foreign Key from Field2 in Table1 to Field1 in Table2. It won't let me...

What is the error message? just guess work without it

True true. A better way still would be close the connection if it is doing nothing for 5 mins

if Conn.state <> adstateopen then set conn = nothing reopen connection end if hope it helps

thanks alot

...I have a data file that is over 2GB and I need a file size reading. below is my current code Meth1 unsigned long GetFileLength ( FILE * fileName) { unsigned long pos = ftell(fileName); unsigned long len = 0; fseek ( fileName, 0L, SEEK_END ); len = ftell (...

...Function PointerToString(lpszString As Long) As String Dim lpszStr1 As String, lpszStr2 As String, nRet As Long lpszStr1 = String(1000, "*") nRet = lstrcpyW(lpszStr1, lpszString) lpszStr2 = (StrConv(lpszStr1, vbFromUnicode)) PointerToString = Left(lpszStr2, InStr(lpszStr2, Chr$(0))...

sorry Used same as johnwm

i get 424 KB (434,176 bytes)

try downgrading mdac to 2.5 and making sure u do not have a circular refrence IE you make a change then the bound control does a change and so on Failing that you will have to post your code so we can look at it for you

what circumstances does it crash??

try upgrading mdac also check your refs and mack sure that one does not say missing

you have a provblem with a refrence to a c dll. A virtual function is a pointer to function in a class

upgrade to dao 3.6 Try using service packing vb as there was a problem with the prev version.

just user pure SQL to do the look up, It will be much faster

Access: Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\db1.mdb;Persist Security Info=False SQL: Provider=SQLOLEDB.1;Password=*****;Persist Security Info=True;User ID=YourID;Initial Catalog=YourDBName;Data Source=YourServer

http://www.vbaccelerator.com/home/VB/Code/Controls/S_Grid/bugTrak11-5.asp and here http://www.vbaccelerator.com/home/VB/Code/Libraries/Subclassing/Adding_Scroll_Bars_To_Forms__PictureBoxes_and_UserControls/article.asp hope this helps

If i am understand your question you want to seek to a position in a data file and get some data ?? dim iFile as Integer Dim RetStr as string open "Filename" for binary as ifile seek iFile,YourPos RetStr = space(3) 'Set the size of the string to 3 bytes get iFile,,RetStr close ifile...

How do you want it displayed. In a grid or a simple textbox like HarleyQuinn has posted just note that if you have a space in your field name then you will need to do the following RS("Your Field Name") and not RS!YourFieldName

It is not a problem with your code. It is with the Database